Loading data into two cubes

[chris_robertson]

We want to set up a delta refresh from R/3 data that will pull data into two cubes. One cube I want all the records to be loaded, in the second cube I want to filter the records that are loaded into that cube. I can figure out how to load the data into two cubes, but can I place a filter on one of the loads. (i.e. only load records of where type = 'X')

Thanks,

Chris

[Former Member · Accepted solution]

You can do that in the Update Rules to the second cube... In the Start Routine...

DELETE FROM DATA_PACKAGE

WHERE type EQ 'X'.

(Please, verify the right syntax)

Then with only one Infopackage, you can load both cube with different conditions.

Hope it helps.

Regards,

Luis

[chris_robertson · Accepted solution]

Ok, this sounds like what I looking for. I will give this a try.

[chris_robertson · Accepted solution]

FYI - Final syntax of delete statement was:

DELETE DATA_PACKAGE WHERE REC_TYPE NE 'F' AND REC_TYPE NE 'Z'.

This tested as desired.

[Former Member]

Chris,

if you are running deltas then you can restrict the values by writing a code in the update rules.. since you want to restrict the data globally, you need to go for a start routine in update rules.. then your delta will also work fine and the data will be restricted to one cube..

Hope it helps..

thanks,

gattu

[Former Member]

Chris,

Its simple to create two infop packages to do restriction for one data target.. Just mention your selection criteria in the data selection tab and select the info provider in data targets tab and load it..

Hope it helps..

Thanks,

gattu

[Former Member]

Create 2 info packages; one info packege dont make selections and in the other make selections.

Ravi Thothadri

[chris_robertson]

How will that work with the delta refreshes though? It seems to me which ever one runs first will consume the delta changes and the other one won't have any records to load. Am I misundertanding this?