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
It seems like your questions is raised in the won board. In Procurement there is no option to pass data from Informatica to Essbase.
Please choose the right board and ask your question again.