Newcomer

Cube View Row Name Time Description in mmmm yy Format

4 replies
18 views

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 if an out-of-the-box solution is available.

aargueAuthor

Newcomer

Additional Context: the |CVTimePrior1| and other references do provide the period but do not have the appropriate format

Employee - Advisor

Employee - Advisor

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

aargueAuthor

Newcomer

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.

OneStream Employee

OneStream Employee

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.