Skip to Content

Avoid partial data load- Webi - BO 4.2

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?

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Apr 11, 2017 at 07:30 PM

    You need to go with the event based scheduling.

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

    .

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 14, 2017 at 04:45 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Apr 14, 2017 at 04:45 AM

    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

    Add comment
    10|10000 characters needed characters exceeded