Search code examples
exceloracle-databaseoracle12canalysisobiee

Linking excel data source with obiee analysis


I am using OBIEE 12c and recently I created a data source from excel file using Visual Analyzer. I used this data source for creating analysis and it worked correctly. However, when I wanted to create an action link from this data source column to the other analysis in obiee created using another subject area, I got wrong results. So my question is, does OBIEE support action links between data sources created in VA and subject areas created in Admin Tool? If yes, how to do that?


Solution

  • If your table/column names do not match then the vanilla interaction will never work.

    You will have to go for the GoURL approach: https://docs.oracle.com/middleware/12213/biee/BIEIT/apiwebintegrate.htm#BIEIT355