Sunday, March 11, 2012

Compare Report

Hi there,

I want to set up a report tha will take my 30 best customers of Q1 2006 and that will display also the facts of Q1 2007.

Can I use a parameter to select these customers on 1 report instead of 30 different reports.

Thx

Is this a report built off of an MDX query or SQL?

For SQL, just use the SELECT TOP n syntax.

For MDX, you may have to use a query expression.

If you could elaborate on the structure of the data and what would define a best customer that would help.

cheers,

Andrew

|||

Yes, you can create a report with one parameter which will be multi-valued and its available values from a query which uses TOP 30 in its SQL text.

Shyam

No comments:

Post a Comment