Hi All,
In PBCS, I have created a BSO cube and ASO cube. My period dimension is pretty simple with BegBalance and YearTotal (with months descendants of YearTotal). After loading all dimensions I refreshed the database and it went all well.
Now what I am trying to do is to have an alternate hierarchy in period dimension with just months (shared) under a new node. Here I am struggling. When I include this new node I am getting an error.
The error I am getting is as follows:
Cube refresh failed with Essbase Cube: ASOPlan, Error code: 1060053, Message:
I have tagged the Period dimension as Multiple and have set the node (alternate hierarchy) as Stored.
My question is that whether we can have a shared member in period dimension in ASO (planning) in PBCS. Is it possible and I need to work with hierarchy types and data types OR this is something difficult to achieve.
Any suggestion is appreciated.
Thanks.
Message was edited by: VM I have updated the node to clarify further details and provide the error message.