Skip to main content
April 3, 2024

Why is there no "View" dimension in Data Buffer ?

  • April 3, 2024
  • 2 replies
  • 0 views

Dear community,

I am working on some Data Buffer and I noticed something :


Sergey_0-1712151377714.png

As you can see (if it's not too small ...), the Data Buffer is not taking into consideration the data units (that makes sense) and not the View dimension either.

However, the data units will have the dimensions : Cube, Entity, Parent, Consolidation, Time, and Scenario.

--> Hence, where is the "View" member in all that ? Am I missing something ?

 


Sergey_5-1712153261891.jpeg

Regards,

 

2 replies

April 3, 2024

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.

 


chris_rothermel_1-1712156091862.png

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

 

 

 

April 3, 2024


chris_rothermel_2-1712156433716.png

 

April 4, 2024

The View member is effectively a virtual dimension, since all numbers in the database are YTD - they just get dynamically converted to other formats on request. Hence we don't keep any reference to it in DataBuffer objects, since they are largely meant to be low-level raw objects.

If you work with non-YTD formats, you will have to keep track of that yourself.