1 Reply Latest reply: Dec 2, 2012 11:23 AM by Nasar-Oracle RSS

    How to delete specific entries of a cube ?

    954011
      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-Oracle
          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