cube view formula

Hi, this request is quite unspecific and it will be difficult for the community to get you to what you want to achieve. There are various ways to achieve this, and maybe dynamic or stored calculations may be an option too, depending on the exact requirements.

If you search for phrases such as "cube view formulas" or "cube view math" in this forum, you will find some posts.

In the documentation (https://documentation.onestream.com/8.4.0/Content/Home.html), you can search for input using the same phrases which will surface e.g. this section:

https://documentation.onestream.com/8.4.0/Content/Design%20and%20Reference/Cube%20Views/Create%20CVC%20and%20CVR%20Calculations.html?Highlight=cube%20view%20formulas

I hope this helps.

Hi, 

To add to Henning's post, I would assume that you want the time periods to be dynamic rather than hard-coded to 2024M12, 2025M1, etc?

The member filter builder available from the cube view screen also has some getdatacell examples. 

You can also raise a ticket with support if you need some hands-on help with building this rule.  

Thanks

Where can I find the  "Member Filter Builder" from the cube view screen? Yes please dynamic would be great