Display Query FIlter Values in an Analysis IP Workbook Cell

[Former Member]

Hi,

I'm sure there is an easy way to display the filter values in a cell of an analysis workbook but I could not find an option to display it.

Like, I have a saved planning workbook and all I'm trying to do is to display the query filters(year is restricted to 'current year' and company code is restricted to' 2345') on the workbook so they are visible to business user as below.

Query Filters:

Fiscal year = '2015

Company Code = 2345

Data ---------------------

---------------------------

Please advice as how to display the dimension filter values of the query?

Thank you.

[Irmi_Kuntze]

Hey

you mean display like you can display the chosen UoM by displaying the defined names from name manager such as SOP_UoMTo or currency by SOP_CurrencyTo or all the other SOP_xxx fuundernctionalities?

That is not possible, because it would not just be one value

The difficulty is probably that it can be a complex selection with including or excluding more than one value for one or even more characteristics / attributes

I fully understand your requirement, we had that as well already in similar form.

I tried with EPM-functionalities such as EPMVariableValue, but I could not find the correct parameters for it. Unfortunately not all EPM functionality works with IBP...

I would like to have at least the filter name displayed as it is e.g. in job logs.

If you find a solution please post it here!!!

Yours

Irmi

[Former Member]

Hi Irmihild,

I was able to display the static filters in Analysis workbook that were set in the Bex query.

To display the name of the dimension for which a filter has been applied:

=SAPGetDimensionInfo("DS_1","0COMP_CODE","Name")

To display the value of the filter applied:

=SAPGetDimensionStaticFilter("DS_1","0COMP_CODE","TEXT")

you could display as "TEXT" or "KEY" or INPUT STRING

Similarly you could use other SAP functions like SAPGetDImensionDynamicFilters or SAPListOf StaticFilters (this will display all the static filters that were applied for that query.

I wasn't sure if this is what you were looking for but just wanted to share this information.