Skip to main content
A
aargue
Newcomer
May 28, 2024

Cube View Row Name Time Description in mmmm yy Format

  • 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. 

2 replies

A
aargueAuthor
Newcomer
May 28, 2024

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

S
OneStream Employee
sameburnOneStream Employee
OneStream Employee
May 28, 2024

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

sameburn_1-1716910532522.png

sameburn_2-1716910767982.png

sameburn_3-1716910782116.png

 

Hope this helps

 

 

A
aargueAuthor
Newcomer
May 28, 2024

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. 

F
OneStream Employee
FredLucasOneStream Employee
OneStream Employee
June 3, 2024

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.

Terms & ConditionsAccessibility statement