Analysis Services 2000 + Reporting Services 2005 + Parameters

Hi All,

I'm trying to create reports in RS2005 using AS2000 as my data source. I understand that if I use RS2005 on AS2000, I wont be able to enjoy the OLAP based parameters as in using AS2005. Does anyone know an easy way to easily use Parameters in RS2005 while still using AS2000?

Regards,

Joseph

I don't think I've tried RS 2005 against AS 2000, but my best bet is that you create an OLE DB connection against your cube, and then learn how to write MDX.

You need to create MDX queries for the parameters that you want to get from your OLAP cube as well as the main query.

All parameterized queries need to be prefixed with =" and ended with ", and to be on one line. (Copy into notepad, turn off word wrap and make it stay on one single line.)

I suggest you read through some articles by Bill Pearson over at Databasejournal.com

Mastering OLAP Reports: Parameters for Analysis Services Reporting ...

http://www.databasejournal.com/features/mssql/article.php/3644661

Mastering OLAP Reporting: Cascading Prompts

http://www.databasejournal.com/features/mssql/article.php/3386441

At least one of them should get you started.

Kaisa

Ampersand in email subscription report parameter

Hello everyone,

I'm trying to set up e-mail delivery report subscriptions. When I enter report parameters, it accepts the standard MDX syntax (ex. [Time].[All Times].[2006]), but when I try to access a member by it's key:

[Time].&[2006]

It raises the following error:

Default value or value provided for the report parameter 'pTime' is not a valid value. (rsInvalidReportParameter)

They seem to have the same problem here (see last paragraphs of the article):

http://www.microsoft.com/technet/prodtechnol/sql/2005/smartreports.mspx

Any idea would be very welcome. Thanks!

TGA

I have the same problem, I've tried replacing the ampersand with & and %26 but the parameter is still not excepted.

Ampersand in email subscription report parameter

Hello everyone,

I'm trying to set up e-mail delivery report subscriptions. When I enter report parameters, it accepts the standard MDX syntax (ex. [Time].[All Times].[2006]), but when I try to access a member by it's key:

[Time].&[2006]

It raises the following error:

Default value or value provided for the report parameter 'pTime' is not a valid value. (rsInvalidReportParameter)

They seem to have the same problem here (see last paragraphs of the article):

http://www.microsoft.com/technet/prodtechnol/sql/2005/smartreports.mspx

Any idea would be very welcome. Thanks!

TGA

I have the same problem, I've tried replacing the ampersand with & and %26 but the parameter is still not excepted.

Am I crazy, or is there no form validation for report parameters?

Maybe I am just not using the correct search strings, but it really appears
that there is no server side validation available for parameters in Reporting
Services generated reports? Is this true (so then I can stop looking)?
Thanks for your help.
--
Paul
Web DeveloperYou can do multiple things. First, in layout tab, Report Menu-> Report
Parameters you can set the data type of the parameter. This is a big help
off the bat. Next, realize that you have two different things: query
parameters and report parameters. RS kindof blurs the difference because it
automatically creates report parameters and maps them to the query
parameter. Your query parameter does not have to map directly to a report
parameter. Click on the ... in the dataset tab, parameters. You can map your
query parameter to an expression. This expression could do some additional
massaging of the data, however, it doesn't allow validation per se.
I agree, a validation expression and text that could be associated with a
parameter would be very nice to have.
Bruce Loehle-Conger
MVP SQL Server Reporting Services
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:1AA2FCD5-7442-4E01-A0C2-3DBA12758BCD@.microsoft.com...
> Maybe I am just not using the correct search strings, but it really
> appears
> that there is no server side validation available for parameters in
> Reporting
> Services generated reports? Is this true (so then I can stop looking)?
> Thanks for your help.
> --
> Paul
> Web Developer|||Thanks Bruce, the points about the parameter types and expressions does
confirm the understanding I had reached from my research and I feel more
confident that I didn't overlook something that might be more obvious to
others.
--
Paul
Web Developer|||FWIW: I tried to do "validation after the fact" by running some Load code
that validated parameters and, if I didn't like what I saw, throwing an
error with an information message. I couldn't get this to work right (maybe
somebody else has?).
So, instead, I added a textbox with "alert" formatting (red text or
whatever) into the header of the report. It's filled by a variable declared
in the report. Ordinarily it's invisible (empty string). However the Load
code can fill it with its information message to show that there is a
problem.
You could also change the visibility or hide other elements of the report by
using a "Success" boolean variable -- again, ordinarily it has the value
True but the Load code can set it False. Now the entire contents of your
report doesn't show except your error message. There's some other stuff
like that, which does work...
HTH,
>L<
"Paul" <Paul@.discussions.microsoft.com> wrote in message
news:629AC8DC-4FF8-441D-A0A9-04026C652C4C@.microsoft.com...
> Thanks Bruce, the points about the parameter types and expressions does
> confirm the understanding I had reached from my research and I feel more
> confident that I didn't overlook something that might be more obvious to
> others.
> --
> Paul
> Web Developer
>