This content has been marked as final. Show 2 replies
I got a Drill Down Dimension which consists of 3 single dimensions:
- ALLOCATION_YEAR (as yyyy),
- ALLOCATION_YM (as yyyy-MM)
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?