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

rmoff

Why not report against the underlying data and model the BoM as a parent-child hierarchy?

[Deleted User]

One thing you could do is to use conditional requests: create a condition which checks whether there's a row in the table or not. The conditional analysis being an analysis with either an EVALUATE wrapper or direct DB request.

Md. Altas

Thank you very much for the input.

I will study these suggestions and get back.

Thomas Dodds

Your issue is more of a data model matter versus a tool matter ...  +1 to rmoff's and Mr. Berg's comments