Forum Discussion

aargue's avatar
aargue
New Contributor II
11 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 III
11 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
11 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
    11 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.