- 17.9K All Categories
- 3.4K Industry Applications
- 3.4K Intelligent Advisor
- 73 Insurance
- 537.3K On-Premises Infrastructure
- 138.6K Analytics Software
- 38.6K Application Development Software
- 6K Cloud Platform
- 109.6K Database Software
- 17.6K Enterprise Manager
- 8.8K Hardware
- 71.2K Infrastructure Software
- 105.3K Integration
- 41.6K Security Software
OBIEE 12c: Substring Dashboard prompt
fist of all I want to state my versions I am using for the upcoming scenario / question:
OBIEE: Version 22.214.171.124.0
OBI Administration Tool: Version 126.96.36.199.0
Oracle Essbase: Version 188.8.131.52.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