1 Reply Latest reply on Jan 2, 2020 2:26 AM by Andre Hagemann

    Passing data from Informatica to Essbase

    New Member

      From Informatica we are passing data to Essbase. The essbase table structure is attached. While inserting data in Essbase , it could be seen that data is inserted to only 6 decimal places (having NUMBER DATA TYPE) field. Just wanted to know that is there any setting in Informatica adapter that restricts the number of precision in Essbase.

       

      Values in Informatica :

       

      CLOGBP NONRTNCOL 18726.000000000000000 5.7736123
      CLOGBP NONRTNCOL 18726.000000000000000 0
      CLOGBP NONRTNCOL 18726.000000000000000 2.8215123
      CLOGBP NONRTNCOL 18726.000000000000000 14.2823123



      While Inserting in Essbase table it becomes

      Datatype : NUMBER ,  precision : 15 ( As per the essbase table)

       

      CLOGBP NONRTNCOL 18729.000000000000000 60675
      CLOGBP NONRTNCOL 18729.000000000000000 61
      CLOGBP NONRTNCOL 18729.000000000000000 19
      CLOGBP NONRTNCOL 18729.000000000000000 313