topic Dimension limitation with expression in App Development

Dimension limitation with expression

philgood34 — Tue, 12 Sep 2017 07:30:29 GMT

Hi everybody

I have a table with a dimension (SECTORS) and 2 measures ( CIB_CATTC & CATTC_REEL)

i want to select the sectors with CATTC_REEL< CIB_CATTC and be able to display only these sectors

So i tried to use the dimension limitation as shown

don't work 😞

anybody have an idea ?

regards

Phiilippe

Re: Dimension limitation with expression

karthikoffi27se — Tue, 12 Sep 2017 07:55:48 GMT

Hi Philippe,

Please use the below expression in your measure

=IF(CATTC_REEL< CIB_CATTC ,CATTC_REEL,0)

=IF(CATTC_REEL< CIB_CATTC ,CIB_CATTC ,0)

and in addons please disable the show zero values.

Many Thanks

Karthik

Re: Dimension limitation with expression

philgood34 — Tue, 12 Sep 2017 08:27:41 GMT

Hi Karthik ,

great trick !

obviously i added sum( ...) , and it's working !

i thank's you for that

the disadvantage is when i have 10 more measures with aggr expression for example, i have to apply the trick for all ... rather complicated

Anyway ... if there's no alternative with the dimension limitation or other fonctionality , i take your trick !

best regards

Philippe

Re: Dimension limitation with expression

its_anandrjs — Tue, 12 Sep 2017 08:35:19 GMT

You can do this calculation in the load script if you have many calculations on the script part you can handle it properly and it is optimized way as well.