Cube View Row Name Time Description in mmmm yy Format

Forum|Forum|2 years ago
May 28, 2024
2 replies
0 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.

A

aargueAuthor

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

S

sameburn

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

A

aargueAuthor

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.