Solved

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

Posted on 2011-02-24
9
509 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
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 

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

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

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

This code started out as a fix for a customer that had incoming data that was hunderds of numbers and words long that was to fit in one column. The problem was that the customer did not want to split words or numbers when wrapping in the column. …
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…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

770 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