Skip to Content
author's profile photo Former Member
0
Former Member

Reverse Record in Cube

Posted on Feb 14, 2005 at 11:04 PM 18 Views

Hi,

In our scenario we load delat data into ODS and then delta data into Cube. I added new characteristics in ODS as well and Cube to fill in based on other existing field and a table lookup for value. I wrote the routine in ODS Update rule.

After the data i see reverse record in Cube? One record for the new characteristics filled in and another reverse record for new characteristics empty.

Basically the data in Cube is Double the Data in ODS.

How to eliminate this? What is the reason for this?

Thank you

arun

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Feb 15, 2005 at 08:56 PM
    1

    Hi Arun,

    When you initialize from the ODS you have to clear the data from the cube, otherwise you get dupicate data in the cube. you can use the ODS as a data store and never clear the data from the ODS, that way you have history. If you add new fields to the ODS do not delete the current data in the ODS and reinitilaize the ODS to bring in the new fields. If you need the new fields in the cube then clear the contents of the cube and initialize the delta into the cube.

    Hope this answers your questions,

    Aaron Blasi

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 15, 2005 at 12:45 AM
    0

    Hi,

    Does the data look ok in the ODS? If so, do you have more then 1 initialization in the cube. If you do then delete all data in the cube and re-initialize the cube from the ODS.

    Aaron

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 15, 2005 at 04:35 PM
    0

    Hi,

    Basically i need the history data in cube.I re-initialized the Delta from ODS to Cube deleting the Old delta initialization.But i didn't delete the data.

    What is the reason for one record with positive key figure value and one record with negative(Reverse) key figure value?

    Basically i added new characteristics in both ODS and Cube and the Routine for it is written in update rule of the ODS.I fill the characteristics

    How does the delta from ODS to Cube works? Can someone explain?

    Thank you

    arun

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 15, 2005 at 05:28 PM
    0

    Arun,

    Just for my understanding. you loaded the ODS intially. So that is one set of records. Next you added more characteristics in the ODS and filled the data. How did you change the history of the data.

    thanks

    amit

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.