Solved

How do I create an ssrs 2008 report from an SSAS cube?

Posted on 2011-02-24
9
513 Views
Last Modified: 2016-02-14
I am in my query designer with my cube pulled in.  I have the dimensions at the top added.  
I also have the measures added.  See attached graphic.

I should be able to see multiple rows, by warehouse-number-product description,  however, I only see the single row.  What am I missing?
0
Comment
Question by:rhservan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
9 Comments
 

Author Comment

by:rhservan
ID: 34970129
Here is the attachment for your viewing pleasure.
cube2ssrs.png
0
 
LVL 10

Expert Comment

by:itcouple
ID: 34970135
Can't see the attached graphic

Regards
Emil
0
 
LVL 10

Accepted Solution

by:
itcouple earned 500 total points
ID: 34970155
You  might have selected all member which I think returns "all" in other words not details just summary.

Switch to MDX view and send the query

Regards
Emil
0
Ready to get started with anonymous questions?

It's easy! Check out this step-by-step guide for asking an anonymous question on Experts Exchange.

 

Author Comment

by:rhservan
ID: 34970488
The attached graphic is the result of an MDX view.
0
 
LVL 10

Expert Comment

by:itcouple
ID: 34970611
The same time I was typing the answer. I replied with the answer after noticing it.

Regards
Emil
0
 

Author Comment

by:rhservan
ID: 34970695
The output certainly appears as a summary not detail though.  What else do you think it could be?
0
 

Author Comment

by:rhservan
ID: 34970962
SELECT { [Measures].[Net Available QTY], [Measures].[QTY On PO], [Measures].[SAW Available Qty], [Measures].[QTY On Sales Order], [Measures].[AverageCost], [Measures].[Extended Average Cost], [Measures].[QTY On Hand] } ON COLUMNS FROM ( SELECT ( STRTOSET(@ProductProductDescription, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@rawhouserawhouseNumber, CONSTRAINED) ) ON COLUMNS FROM ( SELECT ( STRTOSET(@rawhouseLogicalrawhouseDescription, CONSTRAINED) ) ON COLUMNS FROM [DEW]))) WHERE ( IIF( STRTOSET(@rawhouseLogicalrawhouseDescription, CONSTRAINED).Count = 1, STRTOSET(@rawhouseLogicalrawhouseDescription, CONSTRAINED), [rawhouse].[Logical rawhouse Description].currentmember ), IIF( STRTOSET(@rawhouserawhouseNumber, CONSTRAINED).Count = 1, STRTOSET(@rawhouserawhouseNumber, CONSTRAINED), [rawhouse].[rawhouse Number].currentmember ), IIF( STRTOSET(@ProductProductDescription, CONSTRAINED).Count = 1, STRTOSET(@ProductProductDescription, CONSTRAINED), [Product].[Product Description].currentmember ) ) CELL PROPERTIES VALUE, BACK_COLOR, FORE_COLOR, FORMATTED_VALUE, FORMAT_STRING, FONT_NAME, FONT_SIZE, FONT_FLAGS
0
 
LVL 10

Expert Comment

by:itcouple
ID: 34971755
Hi

It won't return anything because you selected everything as filter and it goes to where which is not returned.

You need to move that to on rows which you don't have there..... MDX is not the easiest thing in SSRS.....

Let me know try it and send you example/instructions before I confuse you more

Regards
Emil
0
 
LVL 10

Expert Comment

by:itcouple
ID: 34971797
That was easy.... go to design and just drag the dimension attributes to the "result grid"

Complicated explanation: it will duplicate it and on rows and where which normally doesn't work but of coruse ssrs uses sub cubes. Using MDX from scratch you do it differently.

Regards
Emil
0

Featured Post

Enroll in July's Course of the Month

July's Course of the Month is now available! Enroll to learn HTML5 and prepare for certification. It's free for Premium Members, Team Accounts, and Qualified Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to use Variables  and Custom code in SSRS report and Assembly reference to use compile shared code in SSRS. Its big question for all who are working with SSRS. It is easy to create assembly and refer in SSRS report, still there are some steps…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
There are cases when e.g. an IT administrator wants to have full access and view into selected mailboxes on Exchange server, directly from his own email account in Outlook or Outlook Web Access. This proves useful when for example administrator want…
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…

615 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question