on 12-18-2014 12:02 PM
Hi all
Is there a way to somehow display what filters by measure are applied on a sheet?
Just by looking at the report, or the analysis pane, you don't see it.
It would be nice if this could be made visible through the Effective Filters Info Field.
Would this be possible?
Thanks
Bart
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi BArt,
yes, this is possible. I'd suggest you use the API functions.
SAPListOfVariables and SAPListOfEffectiveFilters
Those API calls via VBA see below ( example for first variable object, datasource alias could be 'DS_1')
dataSourceVariables = Application.Run("SAPListOfVariables", dataSourceAlias)
can give you an array of all values in variables , same for filter.
In my standard workbooks, I use such functions to display ( analog to old BEx workbooks either a hidden row area / hidden sheet) where by VBA I populate such values like Filter 0MATERIAL = 4711
etc.
When distributing that excel to users that information is still readable
Joerg
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
hi Tammy - yes I'm sorry i should have mentioned; i am aware it is on the information pane, but if we would send a workbook to a person that doesn't have analysis office, he would not know this filter was applied. That's why I really like the Effective Filters Info Field, but it would be good if this could also show the Measure Filters.
Hi Bart,
Where did you created your "Filter By Measure" ? on Dimension or on Measures ?
If it is on Dimension(right click on Dimension member and use Filter By Member) then if you use Effective Filters it shows the information
If it is on Measure(right click on Measure and use Filter By Member) then if you use Effective Filters it does not shows the information
Subhash
User | Count |
---|---|
88 | |
10 | |
10 | |
9 | |
6 | |
6 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.