How to run a BI report from prompt commands

Question

Hello,

Anybody knows if is possible to execute a Bi report from promp includying parameter?

I have an user that needs to execute a report with an automation tool.

I understand this can be made scheduling this with a report job, but the user mentions  this way does not work for him.

Best regards.

Gianni Ceresa · Answer

@1378979, if your ETL can manage that what @rmoff suggest is obviously cleaner (better than something running all the time to check if your tables are loaded).

rmoff · Answer

I'd use Agents, like @Gianni Ceresa says, but I would trigger them not on a schedule but directly from your ETL. You can read more in an answer I wrote to a SO post a while ago: oracle11g - Event/ETL based Agent in OBIEE 11g - Stack Overflow

Gianni Ceresa · Answer

So you are trying to reinvent the concept of agent to manage the issues in your ETL process taking too long.

The good thing is that agents can be configured in a way to manage this situation when ideally it run at 9:00 but in case sources aren't ready it wait for example 10-15 minutes more and try again.

In agents you can set a condition to decide if you can continue with the execution of the agent (started by the scheduler) or if you stop before to send something.

You can create a condition taking into consideration 2 elements:

1) your tables are loaded?

2) did the agent already run successfully today?

The first one you must know how to check it as apparently your table are empty when not loaded (or maybe you also have some ETL logs tables where you can read for a successful or finish status).

For the second one you can use the agents log table where you find a code telling you how many emails have been sent out. If for a given day you find a row with more than 0 than the agent already run and so you can skip.

You modify your agent to add the condition and change the schedule to run every 10-15 minutes starting at 9:00 (and maybe a end time of 12:00 or 17:00, depending on what makes sense from a business point of view).

Done!

You are still using OBIEE agents to manage the ETL load time delays and still provide the business with their report as soon as possible.