topic Re: How can I use calculated dimension in set analysis? in App Development

How can I use calculated dimension in set analysis?

vitaliichupryna — Tue, 21 Dec 2021 22:04:53 GMT

Hi All,

In application I need show status it's not possible to create this field in the script, so I use calculated dimension.

Status:

IF(Aggr($(eAmountPS(vPeriod,SA)), Supplier)>Aggr($(eStretch_Goal_Per_Day(vPeriod)), Supplier), 'On Track',
IF(Aggr($(eAmountPS(vPeriod,MO))+$(eAmountPS(vPeriod,SA)), Supplier)>Aggr($(eStretch_Goal_Per_Day(vPeriod)), Supplier),'Possible w/MO', 'At Risk'))

It works pretty good, but now I need to add KPI that should calculate another measure based on Status dimension and should show only Values with Status = 'On Track'

How can I do this?

Thanks,

Vitalii

Re: How can I use calculated dimension in set analysis?

sunny_talwar — Wed, 28 Nov 2018 16:22:51 GMT

How do you define your variable eAmountPS?

Re: How can I use calculated dimension in set analysis?

vitaliichupryna — Wed, 28 Nov 2018 16:26:45 GMT

eAmountPS:

Sum({<$($1),$($2)>[Extended Cost]})

Re: How can I use calculated dimension in set analysis?

sunny_talwar — Wed, 28 Nov 2018 16:33:45 GMT

May bad, why don't you just do this

Aggr(If($(eAmountPS(vPeriod,SA)) > $(eStretch_Goal_Per_Day(vPeriod)), 'On Track'), Supplier)

Re: How can I use calculated dimension in set analysis?

vitaliichupryna — Wed, 28 Nov 2018 17:12:01 GMT

Thank you for help!

It's better way, but I still want show Value with on track status in KPI.

This solution works fine as a dimension:

Aggr(If($(eAmountPS(vPeriod,SA)) > $(eStretch_Goal_Per_Day(vPeriod)), 'On Track'), Supplier)

I tried do something like this in expression, but it doesn't show anything

Aggr(If($(eAmountPS(vPeriod,SA)) > $(eStretch_Goal_Per_Day(vPeriod)), $(eIncentiveValue(vPeriod))), Supplier)

Re: How can I use calculated dimension in set analysis?

sunny_talwar — Wed, 28 Nov 2018 17:37:06 GMT

What exactly are you looking to see? Count of Suppliers which are on track?

Re: How can I use calculated dimension in set analysis?

vitaliichupryna — Thu, 29 Nov 2018 08:19:44 GMT

No, I want to know Incentive value for Status On Track

Re: How can I use calculated dimension in set analysis?

sunny_talwar — Thu, 29 Nov 2018 12:00:04 GMT

May be try this

Sum(Aggr(
If($(eAmountPS(vPeriod,SA)) > $(eStretch_Goal_Per_Day(vPeriod)), Sum([Incentive Value]))
, Supplier)

Re: How can I use calculated dimension in set analysis?

vitaliichupryna — Thu, 29 Nov 2018 13:19:16 GMT

It doesn't work, but in any case thank you for your help.

Thanks,

Vitalii

Re: How can I use calculated dimension in set analysis?

sunny_talwar — Thu, 29 Nov 2018 13:23:42 GMT

Sure, if you are able to share a sample, I am more than happy to take a look. Else, not sure what might be missing