Hi All,
I have an issue with Time balance and skip level properties in Hyperion Essbase.
I had set the Time balance property as LAST and Skip level property to NONE for a parent and 3 children under it.
But when i view a report where i have 3 children and parent, with data for months Jan, Feb and Mar and Q1 as total.
| Jan | Feb | Mar | Q1 |
X | 8 | 5 | 4 | 4 |
Y | 7 | 6 | 5 | 5 |
Z | 1 | #Missing | #Missing | 1 |
Parent | 16 | 11 | 9 | 9 |
Time balance property as LAST is reflecting correctly in Q1 as shown in the above figure.
But skip level property as NONE is not reflecting correctly for Q1, where for a child Z we have #Missing for Feb and March, but Q1 is picking the value of Jan as 1, which it should not be.
Can anyone help on the above issue.
Regards,
SR