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