Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 16 Oracle Analytics Lounge
- 216 Oracle Analytics News
- 43 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 79 Oracle Analytics Trainings
- 15 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
How to run a BI report from prompt commands
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.
Answers
-
Hi,
First
1378979 wrote:...but the user mentions this way does not work for him.
Doesn't make lot of sense.
Why doesn't it work? Technically not doable? Report not running?
And also what do you mean by running a report?
OBIEE analysis are webpages showing you the result: charts, tables etc.
So what does your user expect from a command line execution? The dump of the web page? Something else?
The answers to these questions would help ...
Keep in mind webservices exists in OBIEE, so you can execute reports/LSQL statements and you get the output back ....
0 -
Take the Logical SQL from the report, and you can parameterise it to your heart's content.
Then run it through nqcmd, or indeed any automation interface that supports ODBC or JDBC calls into the BI server. Or there are also Web Services as well.
0 -
Hi to all and thank you for yours answers,
First of all, allow me to describe the situation, an user has created a report wich must to be send it by email, as html embeded,
at 09:00 am is executed by a report job, the tables from the report gets info are feeded by some process that runs at night,
some times these process are still running and the email is sent empty, we use an scheduler to run shell scripts so I need
the commands to execute the report with parameters as the report job do it: email adress, output format, sql or report to execute,
I hope you can suggest me something.
Best regards.
0 -
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.
0 -
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
0 -
