BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Follow BOB on Twitter! 
Follow BOB on Twitter! (Opens a new window)  

General Notice: Upcoming Events: BI+Analytics Huntington Beach CA: Feb 21.

executing SQL query before run report in WebI-Universe Param


 
Search this topic... | Search Semantic Layer / Universe Designer... | Search Box
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Author Message
Tom4321
Forum Member
Forum Member



Joined: 12 Jan 2018

Posts: 2



PostPosted: Fri Jan 12, 2018 8:47 am 
Post subject: executing SQL query before run report in WebI-Universe Param

Hi,

I would like to ask how to run other query (e.g select * from dual) before the execution each report on universe.
I try do this via parameter begin_sql but doesn't work.

I use BO 4.1 and oracle database.
Back to top
Marek Chladny
Forum Advocate
Forum Advocate



Joined: 27 Nov 2003

Posts: 19117
Location: Bratislava


flag
PostPosted: Fri Jan 12, 2018 10:39 am 
Post subject: Re: executing SQL query before run report in WebI-Universe P

Hi Tom and welcome to Bicon_mrgreen.gifB!

What's the purpose of running a query before refreshing normal report queries?

_________________
BO: BI 4.0, 4.1 | XI 3, 3.1 | XI r2 | 6.x | 5.x
DB: Oracle, MS SQL Server, DB2, Teradata, Netezza
HW: Win, Linux and AIX servers
www.perpendulum.com

Latest Blog Posts
• 2013-07-16 Number of reports in a WebI document
• 2013-04-01 Optional prompts in a universe
• 2012-06-08 Calendar table script for Oracle
Back to top
Tom4321
Forum Member
Forum Member



Joined: 12 Jan 2018

Posts: 2



PostPosted: Fri Jan 12, 2018 12:11 pm 
Post subject: Re: executing SQL query before run report in WebI-Universe P

Hi Marek! Thank you for reply.

I would like to check if the daily data processing is finished and if not then I would like to block execution report.
Back to top
joepeters
Forum Fanatic
Forum Fanatic



Joined: 29 Aug 2002

Posts: 6257
Location: Connecticut, USA


flag
PostPosted: Fri Jan 12, 2018 5:18 pm 
Post subject: Re: executing SQL query before run report in WebI-Universe P

There are a few options, depending on how you identify processing as being completed, and how you intend to "block" the query.

Traditionally, this type of action would be done in the database. During ETL, the user account that BO logs in as would be disabled, or the synonyms that it users to connect to the tables are dropped and then re-created after ETL is complete. These can produce rather cryptic error messages for the BO users, however.

Another option is to create a new query in the report that causes an error during ETL processing, and I think this is more in line with what you were thinking. Let's say you have a status table that has a "datamart ready" indicator that is 0 if it is not ready (ETL is active) or 1 if it is ready. Your query would simply be "select 1 / ready_ind from datamart_status".

This too creates a cryptic message.

A third option (which I haven't tested but should work) is to create a function in Oracle that check for readiness and raises an exception if not. Then simply include a call to this function in the query. It won't return anything useful, but on failure it would display the exception message. Thus, the exception that the function raises could include a more meaningful message like "data is currently being loaded".
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Semantic Layer / Universe Designer  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0108 seconds using 18 queries. (SQL 0.0031 Parse 0.0002 Other 0.0075)
CCBot/2.0 (http://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo