Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > SQL Server > SQL Server 2012 > Book: Professional Microsoft SQL Server Analysis Services 2012 with MDX and DAX
Password Reminder
Register
Register | FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Book: Professional Microsoft SQL Server Analysis Services 2012 with MDX and DAX
This is the forum to discuss the Wrox book Professional Microsoft SQL Server 2012 Analysis Services with MDX and DAX by Sivakumar Harinath, Ronald Pihlgren, Denny Guang-Yeu, Lee; ISBN: 978-1-118-10110-0
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Book: Professional Microsoft SQL Server Analysis Services 2012 with MDX and DAX section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developersí questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
Old April 8th, 2013, 11:02 AM
Registered User
Points: 11, Level: 1
Points: 11, Level: 1 Points: 11, Level: 1 Points: 11, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Apr 2013
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Unhappy Deployed ASMTutorial with errors and can't browse [pgs.53-56]

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?
Reply With Quote
  #2 (permalink)  
Old April 13th, 2013, 10:43 AM
Registered User
Points: 11, Level: 1
Points: 11, Level: 1 Points: 11, Level: 1 Points: 11, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Apr 2013
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Well, this is unfortunate...

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!
Reply With Quote
  #3 (permalink)  
Old April 14th, 2013, 12:31 PM
Registered User
Points: 11, Level: 1
Points: 11, Level: 1 Points: 11, Level: 1 Points: 11, Level: 1
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Apr 2013
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default Raise your hands and shout, Halleluja!



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.
Reply With Quote
Reply


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Compile warning. Ch.3, p.53. PEHowland BOOK: Beginning iPad Application Development 1 September 13th, 2010 10:31 PM
help an oldman (56) daviddisman C++ Programming 0 February 16th, 2007 10:53 AM
Chap. 2 Page 52-53 session anmolnandha BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6 2 November 30th, 2006 02:07 PM
Hung up on Ch 2, Pg 53 - new to VB xxxiii BOOK: Expert One-on-One Access Application Development 4 July 20th, 2006 09:25 AM
Chapter 2 - Page 52, 53 Chudz BOOK: Beginning PHP, Apache, MySQL Web Development ISBN: 978-0-7645-5744-6 8 February 19th, 2006 06:09 PM



All times are GMT -4. The time now is 10:13 PM.


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.