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

Full Load with deletion selections in Data Mart

Hi,

I have a DataMart INFOCUBE “A” to INFOCUBE “B”, Full loads must be diary. But the infocube “A” have snapshot, by the zvalid characteristic (AAAA.MM) Eg. 2006.06.

And the INFOCUBE “B” dosen’t have , it needs the last snapshot from INFOCUBE “A”.

I am using a delete selection (“deleted request from infocube after update”) from the infopackage with “infosources are the same ” checked, “Datasources are the same” checked, “Source Systems are the same” checked, and with the “selections are” same or more comprehensive, and I develop a abap routine in the data selection of the characteristic zvalid to create the year.month necessary for the extraction and i have other selection on 0project characteristic. But when beginning a new month, it do not delete the last request, it inserts the new one. ( even when the “selections are” overlapping).

Example that what I need:

31.01.2006

In the infocube A.

0project| Zvalid | amount

PROJ1 |12.2005 | 300

PROJ1 |01.2006 |100

In the infocube B

0project |Zvalid | amounT

PROJ1|01.2006 |100

01.02.2006

In the infocube A.

0project |Zvalid | amount

PROJ1|12.2005 | 300

PROJ1| 01.2006 | 100

PROJ1| 02.2006 | 200

In the infocube B

0project |Zvalid | amount

PROJ1 |02.2006 | 100

What is the correct combination in the “deleted request from infocube after update”?

I would appreciate yor help.

Regars

Victoria Leó

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Jun 06, 2006 at 12:16 PM

    Do you upload the cube from other sources too? Otherwise there is a flag in the InfoPackage that is called 'Delete entire content of data target'.

    It's under Data targets and you can change it if you select 'Select Data Targets'.

    Best regards

    Dirk

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jun 06, 2006 at 12:19 PM

    Hi Victoria,

    You need to delete the entire content from Cube B and load it with the latest snapshot data.

    Bye

    Dinesh

    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.