This discussion is archived
1 Reply Latest reply: Dec 2, 2012 9:23 AM by Nasar RSS

How to delete specific entries of a cube ?

954011 Newbie
Currently Being Moderated
I have two kinds of requirement :

1. My staging table would contain only one day data, and that data has to be pushed in to the cube on a daily basis. For this, I used "load and aggregate" option.
This means the data that was pushed before would not be disturbed. Only the delta is added.

2. My staging table would contain entire data. In this case, the cube has to be populated with the new data and also delete rows in the cube when that corresponding row does not exist in the staging table.
Is there any option other than "clear and load" to achieve this ?

Thanks,
Lakshmi
  • 1. Re: How to delete specific entries of a cube ?
    Nasar Journeyer
    Currently Being Moderated
    David Greenfield has covered many Cube loading topics in the past on this forum.

    Check his following postings, and if you still have question then post again.

    https://forums.oracle.com/forums/thread.jspa?threadID=2435839

    https://forums.oracle.com/forums/message.jspa?messageID=10569983

    https://forums.oracle.com/forums/thread.jspa?threadID=2282513

    https://forums.oracle.com/forums/thread.jspa?threadID=2152852

    https://forums.oracle.com/forums/thread.jspa?threadID=2241299

    https://forums.oracle.com/forums/thread.jspa?messageID=10180677

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points