Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.
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 😕