Microsoft® SQL Server® 2008 MDX Step by Step

Errata for Microsoft® SQL Server® 2008 MDX Step by Step




The errata list is a list of errors and their corrections that were found after the product was released. If the error was corrected in a later version or reprint the date of the correction will be displayed in the column titled "Date Corrected".

The following errata were submitted by our customers and approved as valid errors by the author or editor.

Color Key: Serious Technical Mistake Minor Technical Mistake Language or formatting error Typo Question Note Update



Version Location Description Submitted By Date Submitted Date Corrected
Printed
Page CDROM
CDROM

Sample database installation fails When installing the sample database by running "Microsoft Press\MDX SBS\Setup\SQL Server\attach_db.sql", you may receive an error. To avoid the error, delete the "Microsoft Press\MDX SBS\Setup\SQL Server\MdxStepByStep_log.LDF" file and run the attach_db.sql script again.

Note from the Author or Editor:
Yes. The LDF file needs to be deleted before you run the attach_db.sql script. Once that is done, the script will run successfully. Sorry for the issue.

Anonymous  Oct 15, 2010 
Printed
Page xx
Number 11

Attempts to execute the query fail with Msg 5133, Level 16, State 1, Line 1 Directory lookup for the file "C:\Microsoft Press\MDX SBS\Setup\SQL Server\MdxStepByStep.mdf" failed with the operating system error 5(Access is denied.). Attempts to remove read only do not work, Logged in as Administrator and ran Management studio as administrator Book looks great but not much use without samples and DB.

Note from the Author or Editor:
Grant full access rights to the C:\Microsoft Press folder and all subfolders to resolve the issue

Rick Young  Sep 24, 2010 
Printed
Page xx
item 10

THe database cannot be attached to SQL Server 2008 R2. Error 5173.

Note from the Author or Editor:
The LDF file must be dropped.

Andre Magni  Aug 20, 2010 
Printed
Page xix
Attach the SQL server database instruction page xix

I have the database loaded. Thanks for the clarity on deleting the .lfd file. Now When I attempt to restore the Analysis services database the following occurs: The Script Provided for execution: ===================================== <Restore xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"> <File>G:\Microsoft Press\MDX SBS\Setup\Analysis Services\Mdx Step-by-Step.abf</File> <DatabaseName>MDX Step-by-Step</DatabaseName> <Security>IgnoreSecurity</Security> </Restore> ================================================== the error received: ================================================== Executing the query ... <Restore xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"> <File>G:\Microsoft Press\MDX SBS\Setup\Analysis Services\Mdx Step-by-Step.abf</File> <DatabaseName>MDX Step-by-Step</DatabaseName> <Security>IgnoreSecurity</Security> </Restore> Restore started. Restore finished. Error -1055653859: Restore failed. <Restore xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"> <File>G:\Microsoft Press\MDX SBS\Setup\Analysis Services\Mdx Step-by-Step.abf</File> <DatabaseName>MDX Step-by-Step</DatabaseName> <Security>IgnoreSecurity</Security> </Restore> Errors related to feature availability and configuration: Exceeded the maximum number of partitions in a measure group. The installed server editions allows not more than 3 partitions and not more than 1 writeback partition. Errors in the metadata manager. An error occurred when loading the Internet Sales measure group, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Data\MDX Step-by-Step.0.db\Adventure Works.0.cub\Fact Internet Sales 1.1.det.xml'. Errors in the metadata manager. An error occurred when loading the Step-by-Step cube, from the file, '\\?\C:\Program Files\Microsoft SQL Server\MSAS10_50.MSSQLSERVER\OLAP\Data\MDX Step-by-Step.0.db\Adventure Works.1.cub.xml'. Execution complete

Note from the Author or Editor:
Not sure what's going on. My first guess is either a problem with the edition or version of SQL Server. (It is intended for SQL Server 2008 Developer edition though I have restored the database to SQL Server 2008 R2 Developer edition.) If you are using 2008 Developer, Evaluation or Enterprise edition, the restore should work. If you are using any other edition, it will likely fail.

michael  Jul 24, 2011 
Printed
Page xx
iNTRODUCTION - Restore the Analysis Service Database

<Restore xmlns="http://schemas.microsoft.com/analysisservices/2003/engine"> <File>C:\Users\Willy\Documents\Microsoft Press\MDX SBS\Setup\Analysis Services\Mdx Step-by-Step.abf</File> <DatabaseName>MDX Step-by-Step</DatabaseName> <Security>IgnoreSecurity</Security> </Restore> Executing the query ... The following system error occurred: Access is denied. Backup and restore errors: File 'C:\Users\Willy\Documents\Microsoft Press\MDX SBS\Setup\Analysis Services\Mdx Step-by-Step.abf' specified in Restore command is damaged or is not an AS backup file. Execution complete NOTE: Attach the SQL Server Database was successfully installed.

Note from the Author or Editor:
The first line of the error message identifies the issue. Your Analysis Services instance does not have access to the folder containing the ABF file. Grant the Analysis Services service account the appropriate permissions and the restore will work.

William Mendoza  Jan 30, 2013 
Printed
Page 249
Item 4

WITH MEMBER [Product].[Category].[All Products].[Bikes & Accessories] AS Aggregate( { ([Product].[Category].[Bikes]), ([Product].[Category].[Accessories]) }, [Measures].CurrentMember ) SELECT { ([Measures].[Reseller Sales Amount]), ([Measures].[Reseller Order Count]), ([Measures].[Discount Percentage]) } ON COLUMNS, {[Product].[Category].AllMembers} ON ROWS FROM [Step-by-Step] This query produced 2 rows for Bikes and Accessories both when I entered it by following the books instructions as well as when I copied and pasted the authors code. I can't identify the source of the error. The only change that I've made is to upgrade to Service Pack 1 on SQL Server 2008 R2 Enterprise Edition. Thanks for any help you might offer.

Harold Jackson  Dec 26, 2011 
Printed
Page 294
13.

Hi, I think the expression should be like the following: Exists ( {[Product].[Product].[Product].Members}, StrToSet( "{([user].[user].[user].[" + VBAMDX!Right( UserName(), VBAMDX!Len(UserName()) - VBAMDX!Instr(UserName(),"\") ) + "])}" ), 'User Product Relationship' ) otherwise the allowed member set will not be userspecific and wan't work at all. BR, Stephan Schaumburg-Lippe

Note from the Author or Editor:
Thank you for identifying this error. You are correct that you should use STRTOSET. In the cube we used for the book, I took advantage of the order in which the two AllowedSets are evaluated but that is something that cannot be explicitly controlled so that the STRTOSET is the better approach for consistent security. Thanks again.

Stephan Schaumburg-Lippe  Jun 26, 2012