Using SSRS 2008 R1

On page 140, there is a figure P2-9, and I do not know what they are trying to tell us to do here.

Where do I "create a dataset" as instructed if not in the report designer? And if this is where it is created, step 5 makes no sense then, since I am already there and by clicking the Design Mode, it wipes out what I was trying to do.

So exactly where and how do you do step 4, and what is the purpose of this, as I don't even see this in the sample report, but I would like to understand what it trying to be said here.

TIA
Rick

Hi,

I can understand you confusion. Actually the Figures P2-8 (previous page) and P2-9 are back-to-front.

Figure P2-8 - is the dataset properties window
Figure P2-9 - is how the report will look and operate

Grant Paisley
SQL Server MVP
Angry Koala
http://angrykoala.com

Hi,

I'm trying to work through the Cube Dynamic Rows recipe, but it appears that I'm lacking a table. I have AdventureWorks, AdventureWorks2008R2, AdventureWorksDW, AdventureWorksDW2008, AdventureWorksDW2008R2, AdventureWorksLT, AdventureWorksLT2008 and AdventureWorksLT2008R2 from codeplex, but I can't find a table call Measures. What am I missing?
The book indicates that it's in AdventureWorks.

Thanks,

Jnana

These recipes are against Analysis Server (not the relational database)

Measures are part of any Analysis Server Database.

So install the sample sql database(s) for SQL Server 2008R2 from codeplex
(you may already have these)
http://msftdbprodsamples.codeplex.co...ses/view/55926

And then as described
"The analysis services databases must be deployed manually using SQL Server Business Intelligence Development Studio after installation is complete. Please see Installing Analysis Services Database for more details.
"
http://msftdbprodsamples.codeplex.co...ces%20Database

Ideally you should call the Analysis Server Database
"Adventure Works DW 2008"

Hope this helps

Grant Paisley
SQL Server MVP
http://angrykoala.com

It appears, by the documentation that the Analysis DB doesn't work with SQL Express edition. Do I have to buy the Standard edition to work these example recipies?

Thanks for your help,

Jnana

You can purchase the Developer Version of SQL Server, around US $45, to get Analysis Services.

Ok so I've downloaded the report, and modified the following bits to try and get it to work with my Cube.

1. Changed the datasource.
2. Within the Query, changed the Cube name to [CSCDW] to match the cube in my environment.
3. Changed the measure to be a measure in my cube [Measures].[DC of Contacts]
4. Changed the dimension from Products to [Classifications with Details].[Directorate]&[1]

As far as I can see, this should work. The query executes but returns no columns and no data. What gives?!

Help!

What I have found works good is to turn on SQL Query Proflier for Analysis Services, restrict the output to query end, and you can the past the MDX into a query editor and see what's up.

You are on the right track, however you will need to set ALL the parameters.

The best way to find out the values is to create a query against analysis server in Management Studio and then drag on the members you want from the cube structure window onto the query area. Then cut and paste these values into SSRS parameter default values. (To test, also past them into the query parameters)

For example, here is the set of parameters for one of my client cubes:

pDateMbr

[Time].[by Calendar].[Month].&[2.01011E5]


pCube

RMU


pMeasureGroup

Device Allocations


pMeasure

[Measures].[Device Allocation Count]


pRowMbr

[School].[by Region].[All]
[School].[by Region].[Region].&[Northern Sydney]


pColMbr

[Device Status].[by Category].[All]


pFilterMbr

[Device].[Model Type].[All]

Grant

Sweet! just as you were replying, I had sussed that out. Appreciate the response(s) though! nice and quick, good to see from a forum like this!

Thanks again.