EvDRE Structure 
When building an EvDRE workbook, you define the desired key ranges for the page, column, and row.
Features
The key of a cell is the current view of the cell. That is, the key is the combination of members (one per dimension) used to uniquely identify the value displayed in the cell.
A key range is a range of cells that contribute to the definition of the key of a range of cells. For example, a RowKey range is a range of cells that define a portion of the key, for example, the Account or the Category, of all the cells in those rows.
You can use the key range to define the key for multiple dimensions on both rows and columns. For example, a column key range (COLKey range) could define the Entity, Time period, and Currency for a range of columns. The Data range contains the data retrieved from the database, using the page, row, and column key ranges, the ranges must be enlarged to accommodate the desired number of dimensions. The ColKey range has more than one row and the RowKey range has more than one column.
Note
You can use the reserved heading ranges for Excel formulas or other Ev functions that retrieve, for example, the headings of the appropriate members. The system does not populate the heading ranges with data, but includes them in the expansion process, allowing for the replication of the content of these cells in the expanded columns or rows.
In addition, the system dynamically determines the combination of columns and rows with zero values, and suppresses them.
Example
In the following example, the column and row key ranges are A4, A5 & A6 and C2 and D2. The data range is C4, C5 & C6 and D4, D5 & D6. B4, B5 & B6 and C3 & D3 are reserved for heading ranges.
A |
B |
C |
D |
|
1 |
||||
2 |
actual |
budget |
||
3 |
||||
4 |
Cash |
|||
5 |
Accrec |
|||
6 |
Inventory |