Skip to Content
0

Avoid partial data load- Webi - BO 4.2

Apr 11, 2017 at 06:51 PM

59

avatar image

Hi guys

During month end, some of our fact tables take really long to load. We have universes which have more than 1 FACT tables in dfx. The problem is, end users do not know the loads are being run, so when they run a webi query over that universe who uses two fact tables, but one of them is still in loading state , the query still runs but obviously returns partial data... Is there a way to somehow notify users to prevent them running queries while data loads are incomplete? Its even more tricky with the scheduled reports...

Any ideas?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

AMIT KUMAR
Apr 11, 2017 at 07:30 PM
0

You need to go with the event based scheduling.

http://davidlai101.com/blog/2015/03/09/scheduling-jobs-based-on-trigger-events/

.

Share
10 |10000 characters needed characters left characters exceeded
Manikandan Elumalai Apr 14, 2017 at 04:45 AM
0

You should have a communication methodlogy which communicates to all the users as on when the latest data is vavailable.

For example if you have Sales data, as on when your ETL load completes for your Sales data mart (May be all sales related tables refreshed), trigger the email communication to End users(Sales Team) so that every on aware of the current data load status.

Thanks

Mani

Share
10 |10000 characters needed characters left characters exceeded
Manikandan Elumalai Apr 14, 2017 at 04:45 AM
0

You should have a communication methodlogy which communicates to all the users as on when the latest data is vavailable.

For example if you have Sales data, as on when your ETL load completes for your Sales data mart (May be all sales related tables refreshed), trigger the email communication to End users(Sales Team) so that every on aware of the current data load status.

Thanks

Mani

Share
10 |10000 characters needed characters left characters exceeded