topic Re: Creating & Using A New Dimension viaLoad Script in App Development

Creating & Using A New Dimension viaLoad Script

AycaAltiparmak — Sat, 16 Nov 2024 18:39:30 GMT

Hi All,

I would like to create a new dimension to use in my dashboard. I have a product hierarchy from HANA. I put an if statement to divide it into segments. But I could not see it when creating a new chart as a dimension. Do you have any idea?

Load PRHDA,
if((left(PRDHA,2)='BA' OR left(PRDHA,2)='BC' OR left(PRDHA,2)='BD' OR left(PRDHA,2)='BM' OR left(PRDHA,2)='BN' OR left(PRDHA,2)='BY' OR left(PRDHA,2)='BZ') ,'FDO',
if((left(PRDHA,2)='3F'OR left(PRDHA,2)='3P'),'FS',
if((left(PRDHA,2)='BB' OR left(PRDHA,2)='BE' OR left(PRDHA,2)='BG' OR left(PRDHA,2)='BH' OR left(PRDHA,2)='BK' OR left(PRDHA,2)='BL' OR left(PRDHA,2)='BO' OR left(PRDHA,2)='BP' OR left(PRDHA,2)='BQ' OR left(PRDHA,2)='BR' OR left(PRDHA,2)=' BS' OR left(PRDHA,2)='BU' OR left(PRDHA,2)='BW' OR left(PRDHA,2)='BF'),'SRA'))) AS NewSegment
From [DATALOCATION];
Load NewSegment;

Re: Creating & Using A New Dimension viaLoad Script

PrashantSangle — Tue, 12 May 2020 21:06:42 GMT

Hi,

from this code which field you are not getting in front end??

Regards,

max

Re: Creating & Using A New Dimension viaLoad Script

PrashantSangle — Tue, 12 May 2020 21:08:17 GMT

can you post your complete code over here? if you are getting any error during reload then share that too.

Regards,

max

Re: Creating & Using A New Dimension viaLoad Script

AycaAltiparmak — Tue, 12 May 2020 21:20:41 GMT

I could not see the 'New Segment' as a dimension in front end in any chart.

Re: Creating & Using A New Dimension viaLoad Script

AycaAltiparmak — Tue, 12 May 2020 21:23:40 GMT

My aim is to create a new dimension by using a current dimension- field name PRDHA. I created if conditions in the above code but still could not see the dimension in front end.

Re: Creating & Using A New Dimension viaLoad Script

PrashantSangle — Tue, 12 May 2020 21:24:50 GMT

did you reload dashboard after you modified the script. If yes then take filter pane from left panel. and add new segment in it.

you will also find that field in left Field section.

Regards,

max

Re: Creating & Using A New Dimension viaLoad Script

PrashantSangle — Tue, 12 May 2020 21:26:49 GMT

I got that just reload the dashboard and see .

By the way you can wildmatch() or match() to reduce if condition. for more details see in help menu

Regards,

max

Re: Creating & Using A New Dimension viaLoad Script

Angela_Zhou — Wed, 13 May 2020 00:36:36 GMT

I believe you renamed your new Dimension as "NewSegment" without space, and remove last line of "Load NewSegment;", which seems not necessary.

Also, suggest you using match to reduce OR inside IF statement as below,

Load PRDHA, if(Match(left(PRDHA,2), 'BA','BC','BD','BM','BN','BY','BZ')>0,'FDO', if(Match(left(PRDHA,2), '3F','3P')>0,'FS', if(Match(left(PRDHA,2), 'BB','BE','BG','BH','BK','BL','BO','BP','BQ','BR','BS','BU','BW','BF')>0,'SRA','Other') ) ) AS NewSegment From [DATALOCATION];