Display label instead of var name on Drill Dimension

[Anonymous]

Hello everyone

I got a Drill Down Dimension which consists of 3 single dimensions:

- ALLOCATION_YEAR (as yyyy),

- ALLOCATION_YM (as yyyy-MM)

- $(v_alloc_date)

Last one is based on dimension ALLOCATION_DATE (as dd.MM.yyyy hh:mm:ss)

I already did Trunc on ALLOCATION_DATE to get rid of Timestamp but field still carries time 00:00:00 so i created a variable v_alloc_date with formula Date(ALLOCATION_DATE,'dd.MM.yyyy')

Now I would like to show on 3rd level not the variable name but some label like 'Allocation Date' or something nice looking.

Is there any way to fix it?

[undergrinder]

Hi Kamil,

It is so ugly. The label refer to the data model fields. I had same issue, but I can't find the thread.

The v_alloc_date variable convert to column in load script, then the labels will be shown as right.

G.

[Anonymous]

I tried that but when I use Date in load scrip I got an error so i need to do this as I'm doing it now 😕