You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Skip to content
  • Register

    • ASO Time Balance aggregation not as expected

    in Planning 4 comments

    Summary:

    In BSO cube, there is accounts aggregated value based on time balance = First, Skip Value = Missing by having Period dimension member [Jan] rollup to [Q1] and then to [YearTotal]. However, the ASO cube doesn't aggregate based on the same behavior by rolling up based on Time Balance Property, it seems it rollup differently based on another [Entities] dimension.

    Currently, the Period dimension is Multiple Hierarchy Type. The Entities dimension is Dynamic Hierarchy Type.

    Eg: Period Dimension Hierarchy

    • Period
      • Beginning Balance
      • YearTotal
        • Q1
          • Jan
          • Feb

    We have tried to add MDX formula using CASE WHEN THEN END to simulate the time balance behavior at Period [Q1] member and changing Gen1 parent [YearTotal] member or changing Period dimension to Dynamic hierarchy type. However, we hit the following error when try to refresh database.

    Tagged:

    Howdy, Stranger!

    Log In

    To view full details, sign in.

    Register

    Don't have an account? Click here to get started!