4 Replies Latest reply on Mar 9, 2016 6:00 PM by Thomas Dodds

    Run SQL Script before running Dashboard

    Md. Altas

      Hi All,

       

      I have a unique requirement. I want to build a dashboard where I want to access a table. But this is just a temporary table. Before accessing the table I want to run a PL/SQL to load data to this table.

      For Example: - Say I am creating a Bill of Material table. Before accessing the table I want to run a script to explode the Bill of Material to lowest possible level and load to a temporary table.

      Then run dashboard.


      The reason I cannot use simple SQL is in SQL I cannot run loop. The Bill of Material details change by Item,, By organization. Few organization and items have only 3 level BOM, few of them have 8 level. Hence I need to run the PL/SQL to get data of all the items below the assembly, then load that data to temp table and then use this data for dashboard.


      Is it possible to achieve this in OBIEE?


      I am also evaluating other tools.


      Thanks for the input