| Author |
 Topic  |
|
|
smani
5 Posts |
 Posted - 06/07/2012 : 12:37:46
|
We have a need to filter the OLAP report based on 100's of individual ids that we get from the user.It is tedious to go and select these ids individually from the report.Is there a feature that can use an excel or a file to populate a NamedSet in Report Portal?
Thanks,
SSM |
|
|
admin
1640 Posts |
Posted - 06/07/2012 : 13:22:35
|
How does your list of 100's of individual ids look like? Is it a list of SSAS Unique Member Ids like:
[Customer].[Customer Geography].[State-Province].&[CA]
[Customer].[Customer Geography].[State-Province].&[FL]
[Customer].[Customer Geography].[State-Province].&[SC]
Or is it like:
CA
FL
SC
Dou you want to copy and paste your list of do you want to upload a file with the list? What file format (Excel, Text tab delimited, comma delimited)? |
 |
|
|
smani
5 Posts |
Posted - 06/11/2012 : 14:54:20
|
It will be like
CA
FL
SC
in Excel format.
Thanks,
SSM
|
|
|
|
admin
1640 Posts |
Posted - 06/11/2012 : 20:00:52
|
| It might be possible to add this feature to the dimensional search dialog. Can you specify the level for the list members? For the example above the level would be: State-Province. |
|
|
|
smani
5 Posts |
Posted - 06/12/2012 : 11:17:23
|
It will just be the state.
The users will give a list plain states.
Thanks,
SSM |
|
|
|
admin
1640 Posts |
Posted - 06/12/2012 : 13:47:40
|
It sounds like you are OK with having to specify the level.
Would you need an exception report for members that cannot me imported? For example, if your list has in item like Puerto Rico which is not in SSAS. The exception report would state that Puerto Rico could not be found. |
|
|
|
smani
5 Posts |
Posted - 06/13/2012 : 10:48:46
|
That would be a bonus,thanks!
Does this feature of entering a set of values already exist?If so, is there any documentaton on how that can be done?
Thanks,
SSM |
|
|
|
admin
1640 Posts |
Posted - 06/13/2012 : 11:58:44
|
| No, this feature is not yet available can we should add it in a future release. |
|
|
| |
Topic |
|
Report Portal
User defined list for OALP reports
