sql server reporting services: SSRS with SSAS -- sql server reporting services

SSRS with SSAS

Ryan Chen
11/20/2006 6:15:01 AM

sql server reporting services: Does anybody know how to transfer parameter value into a report which data
source is a cube? I have tried the syntax in BOL, it works with reports based
on relational data source, but returned a blank report when the report is

Re: SSRS with SSAS

Kaisa M. Lindahl Lervik
11/21/2006 10:10:15 PM

Are you using the Query Builder to do it? Then mark your filter dimensions
as parameters (checkbox right at the end of the filter section) and you
should get a report with paramters that work.

You might find some more information in these two articles By William
Pearson

Mastering OLAP Reporting: Meet Business Needs with Matrix Dynamics, Part 1
http://www.databasejournal.com/features/mssql/article.php/3586081

and
Mastering OLAP Reporting: Meet Business Needs with Matrix Dynamics, Part II
http://www.databasejournal.com/features/mssql/article.php/10894_3592521_1

Kaisa M. Lindahl Lervik

[quoted text, click to view]