Hi everybody ,
I am using Oracle EPM 184.108.40.206
I am trying to deploy a essbase BSO cube with text measures from EPMA. In EPMA the text list has to be created as a smartlist dimension. I have even kept the Account member with data type as Text as the first level 0 member of the Account hierarchy.
When I am deploying am gettting no error . In EAS when I see the property of the member it shows as Text and also with the text list attached to it . But When I load data , the data also gets loaded and gives no error.
But when am viewing the data through Smart View or through HFR , the data is displayed as numbers and not as text.
What do you see in text list manager? You can view it by opening the outline and go to Text List manger tab.
Is the number in SmartView matching the number in Text list?
HFR you can still get it even without using a text list, you can always perform a conditional format and replace number by text.
I can see that it is working with EPMA Essbase too, (nothing wrong there, with EPMA)
Is there any member with a member formula, where you are getting numbers.
If that is the case then text list will not work there. I remember raising a bug for this when text list was introduced for the first time. If that is the case, then you might have to wait till next release (220.127.116.11) where I heard for the first time solve order is coming to BSO (I could be wrong here.)
Please mark answers as helpful/correct if applicable