3 Replies Latest reply: Feb 7, 2013 4:41 PM by sunil k RSS

    Slowing Changing Dimension in HP

    korrq
      Dear Experts and Experienced

      How could use Slowing Changing Dimension in Hyperion Planning.

      I have a very serious case and I see no other way to deploy Hyperion Planning to Customer, without using SCD.

      It change the structure of one of the dimensions, which must be done by the user - that is, my application must have response time of a few seconds for this.

      I do not see how to use SCD for Planning.

      Does anyone have this experience and can share?
      If any material on this, please share.


      thank you
        • 1. Re: Slowing Changing Dimension in HP
          sunil k
          Not sure what do you mean by

          -----
          "It change the structure of one of the dimensions, which must be done by the user - that is, my application must have response time of a few seconds for this."
          -----

          Varying attributes provide ways to achieve SCD behavior in ESSBASE. However this feature seems to be not available in Hyperion Planning.

          If you can explain your situation with an example, you may get some good suggestions.

          Regards,
          Sunil
          • 2. Re: Slowing Changing Dimension in HP
            korrq
            Dear Sunil


            The following situation applies dimension of Operation Units

            UO_505050 (Parent)
            UO_505001 (Child)
            UO_505002 (Child)
            UO_505003 (Child)
            UO_505004 (Child)
            UO_505005 (Child)
            UO_505006 (Child)

            UO_505001A (Grandson)
            UO_505001B (Grandson)
            UO_505001C (Grandson)
            UO_505001D (Grandson)

            At some point - very recurrent.

            Section 1.
            The user will need to change the member UO_505001D (Grandson), to take a position below UO_505006 (Child). And you need to rename it to appear to users the new name.

            Then there is a consolidation.
            And then again the same situation occurs with point 1.

            And so often.

            Dimensions are more than 1000 members.
            400 users are.
            • 3. Re: Slowing Changing Dimension in HP
              sunil k
              I do not think i understand it very well. I would give it a try.

              A section of your outline looks like this at one point
              |UO_505050 (Parent)
              |_UO_505001 (Child)
              |__UO_505001A (Grandson)
              |__UO_505001B (Grandson)
              |__UO_505001C (Grandson)
              |__UO_505001D (Grandson)

              and then on user request, it should look like below
              |UO_505050 (Parent) look like below
              |_UO_505001 (Child)
              |__UO_505001B (Grandson)
              |__UO_505001C (Grandson)
              |__UO_505001D (Grandson)
              |
              |_UO_505006 (Child)
              |__ UO_505001A (Grandson) renamed to UO_505006A

              This is possible.
              And depending on what you want to do with the history data in UO_505001A, you can take an action. If you want historical data to be seen under new name i.e. UO_505006A, you can take a level 0 export of UO_505001A before ESSBASE database refresh and load it to new member through rule file after database refresh. In fact, you can just rename the member on ESSBASE end (by opening outline in EAS) before planning database refresh and historical data will line up as expected.

              Important point to remember is that when you rename a member on planning end, it is treated as delete and new addition at ESSBASE end when database refresh is done so current data does not get retained.

              Regards,
              Sunil