Skip to Content
avatar image
Former Member

Visualization without linked dimension

I am trying to create a report with two models linked on a dimension. I need the count of records and am using calculated measure for this (count).

When I add the dimension from the secondary model (not the linked dimension), the count is incorrect. However, the count is correct if I use the linked dimension in visualization. I realized that the count is average based on the linked dimension when the other dimension is used for visualization.

Example -

Primary model -

Column A, Column B, Column C(measure)

Secondary model -

Column B, Column D (dimension)

Primary and secondary models are linked on Column B (linked dimension).

Result of visualization -

Column B vs Calculation count column - 100 (total across column B values)

Column D vs Calculation count column - 45 i.e. less than 100. Here count against each Column D value is average of corresponding results for Column B

I need to know how to get rid of the averaging being done for the other dimensions.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • May 18 at 06:08 PM

    I think you need to apply an exception aggregation. This is very helpful article on this

    https://www.sapanalytics.cloud/resources-applying-aggregation/ (worth reading and a bookmark even if it doesn't solve the issue!)

    Regards, Matthew

    Add comment
    10|10000 characters needed characters exceeded