This content has been marked as final. Show 2 replies
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 .