on 04-20-2011 5:42 PM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.