Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
savior faire
Posting Yak Master
194 Posts |
 Posted - 2008-10-21 : 14:44:57
|
| Good afternoon all,I am training myself and updateing my skill set in SQL 2005 Business Intelligence, and using the MS Press TK 70-445. In Chapter 16, Lesson #3, Exercise #1, Step 4(this is on page 483), instructs to enter the following MDX statement in SSMS while connected to Analysis Services:select ([Measures].[Internet Sales Amount], [Measures].[Reseller Sales Amount]) on columns,[Dim Product].[Product].[Product].Members on rows from [Adventure Works DW] I get the following error:"The 'Measures' hierarchy appears more than once in the tuple."If I remove either "Internet Sales Amount", or "Reseller Sales Amount", and re-submit the mdx query with just one of the preceding elements from "measures", the query runs fine.Just to ensure, my Project and Cube are correct, I used the SSAS Project code modules provided on the companion CD for this exercise, imported into BIDS, and deployed.Anyone familiar with this training materials?Thanks....Talk sense to a fool and he calls you foolish. |
|
|
savior faire
Posting Yak Master
194 Posts |
Posted - 2008-10-22 : 06:53:33
|
| Trying to keep my skill set and knowledge up to date?Anyone, with any ideas here???Thanks.Talk sense to a fool and he calls you foolish. |
 |
|
|
|
|
|
|
|
MS Press TK 70-445, MDX statement not working