I am taking measure columns - "product description","tot cost" against a dimension "project name" .
I am generating this report in a planing form and OBIEE .
in planing form :
product description tot cost
P1 A 1500
p2 B 1700
p3 C 1800
in obiee report :
P1 16 1500
p2 17 1700
p3 19 1800
Somehow , measure's datatype are getting changed from char to number , in OBIEE report.
By default , the data type for all fact's is Double .I tried changing that to varchar , but result is same .
Do I need to change anything in physical layer / RPD .
OBIEE version : 220.127.116.11
Essbase version : 11.1.2
Your A,B,C values feel like they should live in a dimension, not a Fact.
That aside check the physical table in the repository, query data back through the repository tool and see what values you see.
It might be worth getting the repository to check the table against the DB.
Failing that drop the physical table and reimport, making sure to make the logical table back to the newly imported physical source.
Thanks for your reply . To confirm , the data type of product description column is "double" in essbase .
I found out ,thers's a RDBMS table , consisting of two columns - ID, text value . where product description's are in text value's with the corresponding ID's(integer values) .
Now , when I am creating a form in planning , its fetching the text values of product description (there's some inbulit setting's available for this in plannng) .
However , in obiee its fetching the ID values of product description .
1. Is there any similer setting I can do for OBIEE , so that it's fetches only text value's of product description .
2. If not , then I have to join the essbase fact table with this RDBMS table . I am not sure how to do it .