Skip to Content

BEx Query - Hide (can be shown) and dynamic filter settings for KPIs

Dear Community,

I have created Key Figures in BEx Query Designer and selected the Hide (can be shown) option.

Unfortunately they now appear in the Dynamic Filters section. I have checked other queries we are using and I am unable to reproduce why the same settings for the formulas have different results.

For my purpose the KPIs should be "Hide (can be shown)" and NOT appear in the Dynamic Filters section. Has anyone experienced this? Any suggestions on how to solve the issue?

The screenshots in attachment show the settings for a KPI and the info screen when the query is executed.

Many thanks,

Jamie

cuserssm-3186desktop2018-04-12-15-12-21.jpg

cuserssm-3186desktop2018-04-12-15-13-23.jpg

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 04 at 12:55 PM

    Dear all, the parent KPIs have to be set to collapsed. The KPI itself has to be set to "Always show". Best, jamie

    Add comment
    10|10000 characters needed characters exceeded