When I deployed the cube I got the following:

ASMTutorial Errors_040813


Build

Unhandled exception in DevExpress Patch. Exception details (encoded):
System.ArgumentOutOfRangeException: Length cannot be less than zero.
Parameter name: length
at System.String.InternalSubStringWithChecks(Int32 startIndex, Int32 length,

Boolean fAlwaysCopy)
at DevExpress.Patch.Patch.(Project )
at DevExpress.Patch.Patch.(Project )
at DevExpress.Patch.Patch.(vsBuildScope , vsBuildAction )
------ Build started: Project: ASMTutorial, Configuration: Development ------
Started Building Analysis Services project: Incremental ....
Hierarchy [Dim Sales Territory].[Sales Territory6] : Attribute relationships do not

exist between one or more levels of this hierarchy. This may result in decreased

query performance.
Dimension [Dim Sales Territory] : Avoid visible attribute hierarchies for attributes

used as levels in user-defined hierarchies.
Dimension [Dim Currency] : Create hierarchies in non-parent child dimensions.
Dimension [Dim Product] : Create hierarchies in non-parent child dimensions.
Hierarchy [Dim Reseller].[Annual Revenue-Number of Employees] : Attribute

relationships do not exist between one or more levels of this hierarchy. This may

result in decreased query performance.
Dimension [Dim Reseller] : Avoid visible attribute hierarchies for attributes used

as levels in user-defined hierarchies.
Hierarchy [Dim Date].[Fiscal Quarter-Month Number of Year] : Attribute relationships

do not exist between one or more levels of this hierarchy. This may result in

decreased query performance.
Dimension [Dim Date] : Avoid visible attribute hierarchies for attributes used as

levels in user-defined hierarchies.
Hierarchy [Dim Promotion].[English Promotion Category-Discount Pct] : Attribute

relationships do not exist between one or more levels of this hierarchy. This may

result in decreased query performance.
Dimension [Dim Promotion] : Avoid visible attribute hierarchies for attributes used

as levels in user-defined hierarchies.
Hierarchy [Dim Employee].[Department Name-Title] : Attribute relationships do not

exist between one or more levels of this hierarchy. This may result in decreased

query performance.
Dimension [Dim Employee] : Avoid visible attribute hierarchies for attributes used

as levels in user-defined hierarchies.
Dimension [Dim Customer] : Create hierarchies in non-parent child dimensions.
Database [ASMTutorial] : The database has no Time dimension. Consider creating one.
Build complete -- 0 errors, 14 warnings
========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========


Error List

Warning 1 Hierarchy [Dim Sales Territory].[Sales Territory] : Attribute relationships do not exist between one or more levels of this hierarchy. This may result in decreased query performance. 0 0
Warning 2 Dimension [Dim Sales Territory] : Avoid visible attribute hierarchies for attributes used as levels in user-defined hierarchies. 0 0
Warning 3 Dimension [Dim Currency] : Create hierarchies in non-parent child dimensions. 0 0
Warning 4 Dimension [Dim Product] : Create hierarchies in non-parent child dimensions. 0 0
Warning 5 Hierarchy [Dim Reseller].[Annual Revenue-Number of Employees] : Attribute relationships do not exist between one or more levels of this hierarchy. This may result in decreased query performance. 0 0
Warning 6 Dimension [Dim Reseller] : Avoid visible attribute hierarchies for attributes used as levels in user-defined hierarchies. 0 0
Warning 7 Hierarchy [Dim Date].[Fiscal Quarter-Month Number of Year] : Attribute relationships do not exist between one or more levels of this hierarchy. This may result in decreased query performance. 0 0
Warning 8 Dimension [Dim Date] : Avoid visible attribute hierarchies for attributes used as levels in user-defined hierarchies. 0 0
Warning 9 Hierarchy [Dim Promotion].[English Promotion Category-Discount Pct] : Attribute relationships do not exist between one or more levels of this hierarchy. This may result in decreased query performance. 0 0
Warning 10 Dimension [Dim Promotion] : Avoid visible attribute hierarchies for attributes used as levels in user-defined hierarchies. 0 0
Warning 11 Hierarchy [Dim Employee].[Department Name-Title] : Attribute relationships do not exist between one or more levels of this hierarchy. This may result in decreased query performance. 0 0
Warning 12 Dimension [Dim Employee] : Avoid visible attribute hierarchies for attributes used as levels in user-defined hierarchies. 0 0
Warning 13 Dimension [Dim Customer] : Create hierarchies in non-parent child dimensions. 0 0
Warning 14 Database [ASMTutorial] : The database has no Time dimension. Consider creating one. 0 0
Error 15 Errors in the metadata manager. The attribute hierarchy for the Sales Territory attribute cannot be created because a hierarchy with the same ID or name already exists. 0 0


-------------------------------------------------------

It deploys but can't browse cube.
I followed the book copy word-for-word.
What gives?

Please raise your hands if you've had trouble deploying and processing the cube...

I loved the book up to page 54, Too bad if you can't load the example, the other 1000+ that may use the example are useless.

I messaged one of the MVP authors on Facebook on this issue. To bad he's so busy on tour, or speaking, or writing another book, that he hasn't answered.
Why can't the authors be addressed on this forum?

I've tried everything known to a devoted MS developer under the sun, for over a week now. MSDN, Google, you name it. Almost 100 views without a reply?
Apparently others out their may have issues with this as well.Funny replying to m own post.
Well here's the latest set of issues. The cube deploys with warning about the hierarchies, but the throws up errors when processing:

ASMTutorial-2 Deploy_041213


------ Build started: Project: ASMTutorial-2, Configuration: Development ------
Started Building Analysis Services project: Incremental ....
Hierarchy [Dim Promotion].[English Promotion Category-Discount Pct] : Attribute relationships do not exist between one or more levels of this hierarchy. This may result in decreased query performance.
Dimension [Dim Promotion] : Avoid visible attribute hierarchies for attributes used as levels in user-defined hierarchies.
Hierarchy [Dim Date].[Fiscal Quarter-Month Number of Year] : Attribute relationships do not exist between one or more levels of this hierarchy. This may result in decreased query performance.
Dimension [Dim Date] : Avoid visible attribute hierarchies for attributes used as levels in user-defined hierarchies.
Dimension [Dim Sales Territory] : Create hierarchies in non-parent child dimensions.
Dimension [Dim Currency] : Create hierarchies in non-parent child dimensions.
Dimension [Dim Product] : Create hierarchies in non-parent child dimensions.
Hierarchy [Dim Reseller].[Annual Revenue-Number of Employees] : Attribute relationships do not exist between one or more levels of this hierarchy. This may result in decreased query performance.
Dimension [Dim Reseller] : Avoid visible attribute hierarchies for attributes used as levels in user-defined hierarchies.
Hierarchy [Dim Employee].[Department Name-Title] : Attribute relationships do not exist between one or more levels of this hierarchy. This may result in decreased query performance.
Dimension [Dim Employee] : Avoid visible attribute hierarchies for attributes used as levels in user-defined hierarchies.
Database [ASMTutorial-2] : The database has no Time dimension. Consider creating one.
Build complete -- 0 errors, 12 warnings

------ Deploy started: Project: ASMTutorial-2, Configuration: Development ------
Performing an incremental deployment of the 'ASMTutorial-2' database to the 'PJA-D1_V1510\MSSQLSERVER_E' server.
Generating deployment script...
Add Database ASMTutorial-2
Process Database ASMTutorial-2
Done
Sending deployment script to the server...
Error -1056964601 : Internal error: The operation terminated unsuccessfully.
Error -1056571392 : OLE DB error: OLE DB or ODBC error: Invalid object name 'dbo.DimPromotion'.; 42S02.
Error -1054932980 : Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Dim Promotion', Name of 'Dim Promotion' was being processed.
Error -1054932979 : Errors in the OLAP storage engine: An error occurred while the 'Promotion Alternate Key' attribute of the 'Dim Promotion' dimension from the 'ASMTutorial-2' database was being processed.
Error -1056571392 : OLE DB error: OLE DB or ODBC error: Invalid object name 'dbo.DimReseller'.; 42S02.
Error -1054932980 : Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Dim Reseller', Name of 'Dim Reseller' was being processed.
Error -1054932979 : Errors in the OLAP storage engine: An error occurred while the 'Number Employees' attribute of the 'Dim Reseller' dimension from the 'ASMTutorial-2' database was being processed.
Error -1055129594 : Server: The current operation was cancelled because another operation in the transaction failed.
Error -1056571392 : OLE DB error: OLE DB or ODBC error: Invalid object name 'dbo.DimReseller'.; 42S02.
Error -1054932980 : Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Dim Reseller', Name of 'Dim Reseller' was being processed.
Error -1054932979 : Errors in the OLAP storage engine: An error occurred while the 'Phone' attribute of the 'Dim Reseller' dimension from the 'ASMTutorial-2' database was being processed.
Error -1056571392 : OLE DB error: OLE DB or ODBC error: Invalid object name 'dbo.DimReseller'.; 42S02.
Error -1054932980 : Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Dim Reseller', Name of 'Dim Reseller' was being processed.
Error -1054932979 : Errors in the OLAP storage engine: An error occurred while the 'Business Type' attribute of the 'Dim Reseller' dimension from the 'ASMTutorial-2' database was being processed.
Error -1056571392 : OLE DB error: OLE DB or ODBC error: Invalid object name 'dbo.DimReseller'.; 42S02.
Error -1054932980 : Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Dim Reseller', Name of 'Dim Reseller' was being processed.
Error -1054932979 : Errors in the OLAP storage engine: An error occurred while the 'Reseller Alternate Key' attribute of the 'Dim Reseller' dimension from the 'ASMTutorial-2' database was being processed.
Error -1056571392 : OLE DB error: OLE DB or ODBC error: Invalid object name 'dbo.DimCurrency'.; 42S02.
Error -1054932980 : Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Dim Currency', Name of 'Dim Currency' was being processed.
Error -1054932979 : Errors in the OLAP storage engine: An error occurred while the 'Currency Alternate Key' attribute of the 'Dim Currency' dimension from the 'ASMTutorial-2' database was being processed.
Error -1056571392 : OLE DB error: OLE DB or ODBC error: Invalid object name 'dbo.DimReseller'.; 42S02.
Error -1054932980 : Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Dim Reseller', Name of 'Dim Reseller' was being processed.
Error -1054932979 : Errors in the OLAP storage engine: An error occurred while the 'Geography Key' attribute of the 'Dim Reseller' dimension from the 'ASMTutorial-2' database was being processed.
Error -1056571392 : OLE DB error: OLE DB or ODBC error: Invalid object name 'dbo.DimReseller'.; 42S02.
Error -1054932980 : Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Dim Reseller', Name of 'Dim Reseller' was being processed.
Error -1054932979 : Errors in the OLAP storage engine: An error occurred while the 'Reseller Name' attribute of the 'Dim Reseller' dimension from the 'ASMTutorial-2' database was being processed.
Deploy complete -- 26 errors, 0 warnings
========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========
========== Deploy: 0 succeeded, 1 failed, 0 skipped ==========

Impersonation: Use System Account

Sending deployment script to the server...
Error -1056964601 : Internal error: The operation terminated unsuccessfully.
Error -1055391712 : The datasource, 'Adventure Works DW-wrox', contains an ImpersonationMode that is not supported for processing operations.
Error -1055784860 : Errors in the high-level relational engine. A connection could not be made to the data source with the DataSourceID of 'Adventure Works DW-wrox', Name of 'Adventure Works DW-wrox'.
Error -1054932980 : Errors in the OLAP storage engine: An error occurred while the dimension, with the ID of 'Dim Currency', Name of 'Dim Currency' was being processed.
Error -1054932979 : Errors in the OLAP storage engine: An error occurred while the 'Currency Alternate Key' attribute of the 'Dim Currency' dimension from the 'ASMTutorial-2' database was being processed.
Error -1055129594 : Server: The current operation was cancelled because another operation in the transaction failed.
Deploy complete -- 6 errors, 0 warnings
========== Build: 1 succeeded or up-to-date, 0 failed, 0 skipped ==========
========== Deploy: 0 succeeded, 1 failed, 0 skipped ==========

Sorry for the rant but I'm at the point of throwing the book out the window. Sorry Wrox. If I could hear from someone with a little more detail how they
successful deployed and processed the cube, with specifics on configuration,
I would be so grateful.

Thanks!

Hallelujah!
I found out how to process this and it worked! Here's the method I used:

From the output above I could see that the cube deployed, but had problems processing. Maybe the default method of processing was too fast for the cube to handle.

I right-clicked on the cube and chose "Process" to bring up the "Process Cube" window.

I then clicked on "Change Settings" and made the following changes to the "Batch Settings Summary":

Processing Order: Sequential
Transaction Mode: Objects in separate transactions
Dimension Errors: (Default)
Dimension key error log path: (Default)
Process Affected Objects: Process

Hit "Run" and viola! It RAN SUCCESSFULLY!

I could then open the cube browser tab, and it recognized the cube, AND OPENED!

I hope this helps anyone who is having trouble processing. Please let me know if this works for you.