Application Build
Showing results for 
Search instead for 
Did you mean: 

Forum Posts

function that can be used in a member formula

Do we have a function that can be used in a member formula that will calculate the average of the last 3 periods.Example: If my current forecast month is June, I want to calculate the average for the months of May, April, March for which I have actua...

0405V by New Contributor II
  • 1 replies
  • 0 kudos

13 Period time dimension vs UD

Hello everyone, We have a client that uses 13 period time dimension in their current system that we are moving to onestream at the moment. They use period 13 to load TB' post adjustments even input disclosures currently.We first wanted to use a UD di...

Resolved! Time member - 2023

Dear Team, I'm trying to use 2023 time member, to see all YTD values till today, but it seems to be empty.It doesn't make sense as we reported Jan-Apr figures. I have made a consolidation on T#2023 member, but it doesn't change anything. Am I missing...

Kamila by New Contributor III
  • 3 replies
  • 0 kudos

Cube View DatePicker, Time Zone and Custom Calculate

We're working on a solution, where users can enter and view a date through a Cube View using the Cell Type Date. The challenge is how OneStream handles date's (datetime) with time-zones. When a date is saved to the backend, it's converted to UTC time...

FrankDK by Contributor
  • 9 replies
  • 1 kudos