Forum Discussion
Sergey
OneStream Employee
2 years agoWhy is there no "View" dimension in Data Buffer ?
Dear community,
I am working on some Data Buffer and I noticed something :
As you can see (if it's not too small ...), the Data Buffer is not taking into consideration the data units (that...
chris_rothermel
OneStream Employee
2 years agoHi Sergey,
I had the exact same question when reading the Finance Rules and Calculation Handbook. See page 45 figure 2.12 (image below). I wrote in my copy of the book "Where is the View dimension?" Well the View dimension is special with respect to Data Units and Data Buffers. It is not part of the Data Unit but it controls how the data is presented in your Data Buffer. The View dimension effectively performs an additional calculation on the data on how it is loaded to the data buffer -- i.e. Periodic, MTD, QTD, HTD, YTD.
Know that the underlying database tables store all of the data as YTD and often you won't need to specify the View dimension -- if you want A#Account1 + A#Account2 you don't need to specify the View dimension.
I hoping for my DescribeDataBuffer method to be in release 8.3 and that tool will be a good aid for understanding the data buffer better.
Chris
chris_rothermel
OneStream Employee
2 years ago
Related Content
- 3 years ago