Forum Discussion

aargue's avatar
aargue
New Contributor II
7 months ago

Cube View Row Name Time Description in mmmm yy Format

I have a column where I'm using a GetDataCell formula and I want my Time Row Header to show a date different than that of the Pov.  I've had a solution that uses a Business Rule but wanted to see i...
Cube View
Reports
sameburn's avatar
sameburn
Contributor II
7 months ago

Hi aargue based on your description you can achieve this with another substitution variable e.g. T#|CVTimePrior1|:Name(|MFTimeDesc|).  This will return the description from your time profile as the column alias

 

Hope this helps

 

 

  • aargue's avatar
    aargue
    New Contributor II
    7 months ago

    Hi Sameburn, 

    Unfortunately that doesn't work because I'm looking to reference the prior period used in the GetDataCell Formula. I've found a solution using a custom business rule but was hoping to find something easier. 

    • FredLucas's avatar
      FredLucas
      Contributor III
      7 months ago

      Hi aargue,

      Not sure I fully understand your use case, if you could share you current solution I'd be happy to give you my view on it.