Forum Discussion
Hi 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
Also, I have some mnemonics to help remember the contents of the Data Unit and Data Buffer
Every Person Can Save Time = (Cube) Entity, Parent, Consolidation, Scenario, Time
View All Fat Orangutans Including Ugly Ocotopuses = View, Account, Flow, Origin, Intercompany, U1-U8
Yeah, I do include View in the Data Buffer category. 😉
Related Content
- 2 years ago
- 11 months ago
- 3 years ago