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 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 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 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 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 |
|