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

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?
rhservanAsked:
Who is Participating?
 
itcoupleConnect With a Mentor Commented:
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
 
rhservanAuthor Commented:
Here is the attachment for your viewing pleasure.
cube2ssrs.png
0
 
itcoupleCommented:
Can't see the attached graphic

Regards
Emil
0
Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

 
rhservanAuthor Commented:
The attached graphic is the result of an MDX view.
0
 
itcoupleCommented:
The same time I was typing the answer. I replied with the answer after noticing it.

Regards
Emil
0
 
rhservanAuthor Commented:
The output certainly appears as a summary not detail though.  What else do you think it could be?
0
 
rhservanAuthor Commented:
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
 
itcoupleCommented:
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
 
itcoupleCommented:
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
All Courses

From novice to tech pro — start learning today.