Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Deleting records in OBIEE when they're deleted in Siebel

Received Response
72
Views
12
Comments
2»

Answers

  • 3025352
    3025352 Rank 3 - Community Apprentice

    hmm.. Not sure if I follow. I'm fairly new to OBI and data warehousing. My users want the most most accurate information, so if there are agreements or service requests that have been deleted out of Siebel, they don't want reports showing those records. I don't know what would be the best route to go about doing so.

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Ok in that case best read up on DWHing theory first. The whole point of a DWH is to collect information over time and keep historical information. If you just reload your whole DWH once a week you lose all that history and only ever have a one-moment picture of the corporation which is pointless.

    I'm on a super dodgy wifi so not even sure this post gets through let alone pull together a list of URLs bur google for Kimball design tips and read what he has to say of historization, soft deletes etc.