4 Replies Latest reply: Aug 20, 2014 4:08 PM by Celvin Kattookaran RSS

    Copy Data Type Text - Hyperion Planning 11.1.2.3

    1030054

      Hi,

       

      Using Hyperion Planning 11.1.2.3.

       

      When you copy a cell using a calc script, from cell A to cell B, and the type of the account is text, if the user change the text in the cell B, the text in cell A is actualized with the modified text in B?

      Is there a way to avoid this, i mean, using data type text like if it was a number?

       

      Thanks in advance!

        • 1. Re: Copy Data Type Text - Hyperion Planning 11.1.2.3
          AmarnathK

          Ideally, it should not happen.

          But, why do you want to copy from Cell A to Cell B. Is there any specific reason for that?

           

          I would test it and see if it's really modifying the Cell A by inputting in Cell B

          • 2. Re: Copy Data Type Text - Hyperion Planning 11.1.2.3
            user739392

            Planning creates an entry for every new text in the relational DB. It does not create an entry if it finds an exact match and uses the exiting string's id as the value.

             

            So if cell1's value is "Text1", after running a calc script to copy cell1 to cell2, cell2 is now "Text1" as well. There is only one entry in the table. Now if you go and edit either one of them to "Text1 Modified", a new entry gets added to the table for that cell. If you go back to "Text1", no new entry will be created.

             

            So in short if cell B changes, Cell A value will not change.

            • 3. Re: Copy Data Type Text - Hyperion Planning 11.1.2.3
              1030054

              Nice to hear this! Thanks very much for the answer.

              • 4. Re: Copy Data Type Text - Hyperion Planning 11.1.2.3
                Celvin Kattookaran

                Goog explanation. I'm adding to it

                You are right about Planning creating an entry in relational. It adds the text and adds an ID.

                This ID gets stored in Essbase and it has an internal mechanism to match the ID with Text.

                So what happens when you perform a copy (DATACOPY) this copies the data in Essbase.

                 

                So now CellA and Cell B has same number and they will point it to the text. When you change the text no new entry and so both shows the same number.

                 

                A simple data copy won't help you. You don't have much of an option here (other than playing around with the tables and adding new entry there and send new data value to Essbase.

                 

                Regards

                 

                Celvin Kattookaran