Hi

I desperately need to call an sql report based on a selection int he OLAP
cube. But I have some difficulties getting the logic right...

From AS I can use for instance an URL action to call a reporting services
(or report portal) SQL report and bring parameters along to control the
output of this report.

The parameters I send along could be determined by dimx.currentmembers in
the MDX URL statement....

The problem here isn't the exact values - the problem is the All member ...
where do I do something about this .... do I handle this in the SQL report
.... have some kind
of logic that says to disregard currentmembers when choice is all member ? I
cannot avoid sending dimensions along where All member is chosen ? What
about the
SQL sentence then ?

How would I do that with reporting services / Analysis Services ?

Help will be greatly appreciated...

/Michael

Maybe there's a better solution; but one way would be to build the SQL
query as an expression in Reporting Services, rather than using SQL
query parameters (this method is also used for MDX 2000 queries). In
that case, the "where" clauses could be selectively added, only when the
corresponding report parameter is not "All". For Time dimension example,
expression fragment is like:

" and ReportTable.TimeColumn = " + Parameters!pTime.Value)

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Sounds like a way to go....thanks Deepak....

"Deepak Puri" <deepak_puri (AT) progressive (DOT) com> wrote