9 Replies Latest reply on Nov 12, 2018 7:36 PM by Christian Berg

    OBIEE 12c: Substring Dashboard prompt

    Carsten Weber

      Hi guys,

       

      fist of all I want to state my versions I am using for the upcoming scenario / question:

       

      OBIEE: Version 12.2.1.1.0

      OBI Administration Tool: Version 12.2.1.1.0

      Oracle Essbase: Version 11.1.2.4.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

       

      Carsten