Find highest values for different Dimension combinations

[former_member773831]

Hi,

Let's assume I have a KPI (Measure) that can be displayed by different Dimensions (e.g. Country, Location & Region).

Is there any possibility in SAC that I can show the highest values of the KPI considering all the possible combinations of the dimensions. Like in Country X and Location Y the values is above a specific threshold). So basically that it checks all possible combinations of dimensions and displays the KPI with these respective dimension values.

Reason is that I would like to avoid showing multiple bar charts for each dimension that then shows the highest values. It should rather inform me which combinations have high values that are above a threshold.


Thanks"

[MKreitlein]

I don't know a standard solution on this, since I think Top N and sorting is always dependent on ONE dimension.

Easiest thing is to load your dimension combinations in one additional dimension, e.g. concatenated by space and then you can do a Sorting or Top N on that one dimension to see all combinations above your threshold.

BR, Martin

[former_member773831]

Hi Martin,

Could you shortly explain how to create such a dimension?

Best,
Luka

[MKreitlein]

See this help page:

https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/caed2d29695947c9bf46f4b3a...

Item #16, via a concatenation of the respective fields.

BR, Martin

[christophtill]

Hi luka_m,

Smart Insights should do what you are looking for.

Kind regards
Christoph

[christophtill]

luka_m, see this great new blog post from iver.vandezand and check out latest video to explain Smart Insights 😉

[former_member773831]

Thanks christoph.tillmann ,

Sounds good!

Best,
Luka

[William_Yu]

Hi luka_m,

Have you tried with Top N or sort feature of SAC chart or table widget?

https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/99d80bca03f54c12a427a8d19...

Best regards, William