2 Replies Latest reply: May 25, 2016 4:58 AM by Kamil Stachowicz RSS

    Display label instead of var name on Drill Dimension

    Kamil Stachowicz

      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?

       

      QS_drill_name.png