Skip to Content

How to filter on measure built in BOC story?

Hi,

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

Regards,

Kiran Shenvi

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    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.

    Best
    Daniel

    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?