Time Balanced Accounts and YTD Reports
In Essbase 11.1.2. we want to convert this BSO outline to ASO:
Time Dimension:
Year Total
--Q1 (+)
--Q2 (+)
--Q3 (+)
--Q4 (+)
Year Alternate Rollup
--YTD Q1
----Q1 (+) (Shared Member)
--YTD Q2
----Q1 (+) (Shared Member)
----Q2 (+) (Shared Member)
--YTD Q3
----Q1 (+) (Shared Member)
----Q2 (+) (Shared Member)
----Q3 (+) (Shared Member)
--YTD Q4
----Q1 (+) (Shared Member)
----Q2 (+) (Shared Member)
----Q3 (+) (Shared Member)
----Q4 (+) (Shared Member)
And we have around 6'000 accounts with TB last attributes...
Any ideas how to build such a time dimension in ASO?