Forum Discussion
Solved
MTD vs YTD in report
Hi everyone, I need to load data in Onestream in MTD, and I imagine there is an out-of-the-box way to visualize that same data in YTD in a report without having to compute it through a BR, but I can...
The Stage, Forms and Journal data is converted to internal cube storage as the data goes into the cube. The View member (eg V#Periodic, V#MTD, V#QTD, V#YTD) take care of converting the internally cube stored values as necessary at reporting time using the AccoutType and Flow SwitchType properties. No BR logic is required, as the View members are all out box functionality that are applied when reading cube data.
Hi rhankey,
my idea was to work directly on the cube. I need to create a cube view that shows data in MTD or YTD based on user selection. Since I load data in MTD, I'm trying to understand how the YTD can be obtained. Is there a default calculation that does it, or do I need to set up a BR to calculate YTD values based on the MTD?
The Stage, Forms and Journal data is converted to internal cube storage as the data goes into the cube. The View member (eg V#Periodic, V#MTD, V#QTD, V#YTD) take care of converting the internally cube stored values as necessary at reporting time using the AccoutType and Flow SwitchType properties. No BR logic is required, as the View members are all out box functionality that are applied when reading cube data.