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

Delta Management

Dear experts,

I am facing following problem:

I've got to correct amounts in a cube. This we wanted to do by a correction file in csv form. We calculated (manually) the must-be amounts and wanted to add the amounts in the cube. The end-amount is wrong (it is to high) and doesn't add the origin amount from the csv file but some kind of "older" delta.

The data model and loading logics is: CSV --> Full load --> DSO write opt. --> Full Load --> DSO standard --> Delta Load --> InfoCube

Hope there are any ideas...

Best regards

Patrick

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Apr 21, 2011 at 06:38 AM

    Dear Patrick,

    If it is Development server

    1. First check whther there is any data in cube related to the Flatfile data, If there is any data just delete data and load it to Dso and then cube.

    2. If there is no data in any of the Upward floe, then GOTO Transformations from Datasource to DSO, then select keyfigure, doubleclick on keyfigure change property to summation and activate it and load data to upward floe from flatfile.

    It will works

    Regards,

    Marasa.

    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.