Hi ,
I have to filter my report based on a products set.
The products are coming from different levels and I have to go pick them or drag them to the set.
Is there a way to copy the members from excel to the report page ?
I have never done this? but is there a way to ?
Thanks,
Nithya
use prompt.
or you mean the products set are changing and are stored in some excel file and from there you want to use as input parameters for your report?
Why not create a filter?
Are the set elements known? Are they fixed? Are they determined by a prompt pick list? Is populating the set via a parameterized macro in the filter something you've considered? Can you define the set by an expression (for example unioning some sets in the expression, each set picking the members you want from each level)?
What's your data source? Are you working with DMR? Pure relational? OLAP? You mention members, which suggest either OLAP or DMR. If the set is known and fixed you could just put it into the context filter?
Why do you think you need to use excel?
Just out of curiosity, what is the relationship between the members? Are any ancestors / descendants of other members in the set?
yes the items that needs to be used in slicer are say 50 product items, so I have to drag all the fifty items to slicer one by one.
If I am able to copy these 50 products from an excel to the query , then I will select this member and put in slicer.
Otherwise I have to go pick all 50 members from different levels.
Thanks