Hi everybody ,
I am using Oracle EPM 220.127.116.11
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.
Kindly help .
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.
Ya Text list is visible in EAS.... and using conditional formatting is ruled out because I am using Text measures.. If I was to use Conditional formatting then I would not have enabled textmeasures..
I need to make this Text measures work . Kindly help.
Ok this is what i have in my system.
I've text list like
When i go to FR I can see Good Average and Bad. When you say that you are seeing numbers does that number correspond to anything from the list. Like you have 1 and Good, but you still see 1.
Also I would try with a classic essbase application to rule out the issues of EPMA.
I've to try that with an EPMA Essbase application (I don't like doing that personally, can't imagine Planning with EPMA, now Essbase :(). On classic it works fine.
http://www.orahyplabs.com Please mark the answers as helpful/correct if applicable
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 (18.104.22.168) where I heard for the first time solve order is coming to BSO (I could be wrong here.)
http://www.orahyplabs.com Please mark answers as helpful/correct if applicable