2 Replies Latest reply: May 18, 2016 1:37 PM by Gabor Tarnoczai RSS

    Dynamically Rename Dimension in Published app

    sujith madhavan

      I am trying to rename a Dimension in published app based on the value from another table

      The table structure is below

       

      TABLEA

      LOC  Varchar2(50)

      QTY   Number

       

      TABLEB

      LABEL1         varchar2(20)

      LABELDESC  varchar2(50)

       

      In the first refresh, I am renaming the Dimension "LOC" in TableA based on the LabelDesc value in Table B,

      Data for Table B is as below for 2 refreshes.

       

      TABLEB

       

      LABEL1LABELDESC
      LOCLOCATION-ALL

       

      When App is refreshed with the above data LOC field gets refreshed successfully, no issue in visualization

      displays the renamed field correctly

       

      when The app is refreshed with the below data, Visualization breaks as it specifically searches for the field "LOCATION-ALL"

       

      LABEL1LABELDESC
      LOCLOCATION

       

       

      I have even tried renaming the field back to LOCATION-ALL and then rename it to LOCATION, it still does not work.

       

      Has anyone experienced this issue ?

      Note : This issue is only if the dimension is used in visualization and for published App