Y-T-D In ASO Cube PBCS
Hello Experts,
In accordance of Oracle Docs, ASO Cube doesn't support Dynamic Time Series Like BSO Cubes. I read some altenative ways but any work for me. I neet to create a simple YTD in ASO Cube (PBCS)
First Option
I created a new hierarchy "Acumulado" like bellow
Period
-BegBalance
-YearTotal
-Acumulado
-Acum_Feb
The member Acum_Feb is a Dinamic Calc with a Simple MDX formula: [JAN] + [FEB], the formula is validade. When a try to do a Deploy the error bellow is displayed
"ASO members with time balance members requires a time dimension to only contain stored hierarchies. Member: XX_XXXXX"