Skip to Content
0

How to filter on measure built in BOC story?

Mar 15, 2017 at 07:13 AM

109

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Daniel Lauer
Mar 15, 2017 at 08:02 AM
3

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded

Hi Daniel,

Thanks for reply. Your suggestions are excellent.

I tried using them both but still in problem.

1) HANA View:

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.

Repository: Encountered an error in repository runtime extension;Model inconsistency. Create Scenario failed: Calculate On Request Node Flag inconsistent, Attribute 'M_final' isn't marked, but used Attribute 'M1' is(calculationNode (finalAggregation) -> attributes -> attribute (M_final))

I am not able to reuse the calculated columns at the same level with qualification as Attibute

Hence, I have to go for step 2

2) Measure Input Control

Over here I found one more issue and that is with Table View.

The data which I need to represent and filter is required in a tabular format.

BOC allows Measure Input Control but only for charts and not for table view. :-(

Regards,

Kiran Shenvi

1

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?

0