Solved

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

Posted on 2011-02-24
9
507 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
 

Author Comment

by:rhservan
ID: 34970488
The attached graphic is the result of an MDX view.
0
What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

 
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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Chart-Optimization-Tips.html).  This article explained how …
Written by Valentino Vranken. Introduction: The first step of creating a SQL Server Reporting Services (SSRS) report involves setting up a connection to the data source and programming a dataset to retrieve data from that data source.  The data…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This tutorial demonstrates a quick way of adding group price to multiple Magento products.

743 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now