Skip to Content

How to filter on measure built in BOC story?


We currently have a data source(HANA View) which is LIVE Connection and based on that we have created a measure at BOC story level.

Requirement is to apply a filter based no the values on this measure in one of the chart. But BOC at present allows to apply filter only on dimension.

Because of this we are in a deadlock and cannot move forward. Please suggest.

Note :

1. we cannot see the dimension tab in LIVE connection so we cannot convert measure to dimension

2. HANA version is sps12 and BOC latest Version 2017.3.2


Kiran Shenvi

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Mar 15, 2017 at 08:02 AM

    Hi Kiran,

    adding dimensions in a model, based on Live Connection, isn't supported at this time, so what you see is expected behavior. Do you have a chance to change your underlying Calculation View in a way that you have both, measure and according dimension values? I guess that would be the cleanest way.

    In case you don't need total flexibility to filter your values, but only predefined value ranges (e.g. 0 to 3, 4 to 6), you could try this as well:
    Create to calculated measures in the model (not in the story) using this formula: IF (your_measure < 4, your_measure, 0). Accordingly for the second measure: IF (your_measure > 4, your_measure, 0). Use SUM as aggregation type. Then in the story you can use a measure input control for that certain chart to switch between the two measures.

    Hope this helps.


    Add comment
    10|10000 characters needed characters exceeded

    • Hi Kiran,

      I'm not sure what you mean by this:

      The final metric on which I want to make a filter uses 2 sub-metrics M1 & M2 (both created at Aggregation Node).

      When I define the final metric as M_final = if( M1/M2 > 1, 1, 0) then the model gives invalidation.

      Can you attach a screenshot of this?