Solved

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

Posted on 2011-02-24
9
510 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
  • 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
Resolve Critical IT Incidents Fast

If your data, services or processes become compromised, your organization can suffer damage in just minutes and how fast you communicate during a major IT incident is everything. Learn how to immediately identify incidents & best practices to resolve them quickly and effectively.

 

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

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Time Corrections for Reports Working with a report, we made some interesting discoveries about the time corrections/updates We are using the following Parameters: Starting Entered Date (Date) formatted as Data type: "Date/Time" Ending Entered …
Introduction In the following article I’ll be discussing and demonstrating several different ways of how images can be put on a report. I’m using SQL Server Reporting Services 2008 R2 CTP, more precisely version 10.50.1352.12, but the methods ex…
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…

820 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