fist of all I want to state my versions I am using for the upcoming scenario / question:
OBIEE: Version 126.96.36.199.0
OBI Administration Tool: Version 188.8.131.52.0
Oracle Essbase: Version 184.108.40.206.008.28
We are trying to implement a dashboard prompt which is directed to an analysis within Oracle BI Anwsers.
The data retrieved is stored within a dimension in our Oracle Essbase cube.
Dimension name: Station
Data value pattern: AP_ABC, AP_DEF, AP_GHI, etc. (where AP_ is a fix component / prefix)
Now we are trying to substring all values within the dimension without showing the prefix using the following formula within the dashboard prompt: SUBSTRING(Station FROM 4 FOR 3)
Within the dashboard it then shows me the correct values for selection: ABC, DEF, GHI, etc.
The problem occurs when commiting the prompt as the analysis does not show any results.
I have already searched within the OTN but did not find any solution so far. Maybe someone can help me out on this matter?
Best regards and thanks in advance