cancel
Showing results for 
Search instead for 
Did you mean: 

data is coming in psa but not cube

Former Member
0 Kudos

Data is shown in PSA but is not updated in the cube.

Accepted Solutions (0)

Answers (5)

Answers (5)

former_member441329
Active Participant
0 Kudos

Since data is coming to PSA so I don't think source system etc problem would be there..still view your datasource and its associated source system..

then..go to RSA1.

1.Check the tree(collapse it) under your target infocube..shows transformation...under that your datasource..and under that your infopackage.

if not then problem is with creation/activation of transformation.....most probably..

2.Parallel to the transformation folder you will find DTP folder ..is it there..???

then try to execute the DTP.Check the properties of DTP..what you have mentioned there..may..be..some wrong property you have entered..or selection criteria..is the execution happening ...??? let us know..

Former Member
0 Kudos

Hi,

Search the forums with BF11.

With rgds,

Anil Kumar Sharma .P

Former Member
0 Kudos

Hi Anil Kumar

Checked BF11. BW is checked there.

Any other suggestion?

Thks,

julie

Former Member
0 Kudos

Create a DTP and push the data from PSA to the cube.

Ravi Thothadri

Former Member
0 Kudos

Hi Julie,

From BI 7.0 onwards when you create an info package on Data Source, data will only go upto PSA level.

You have to follow the following sequence for data transfer:

1. Create transformations on IS.

2. Create and Schedule info package on Data Source- This will pull data from DS to IS i.e PSA.

3. Create transformations on Cube

4. Create DTP on cube - This will pull data from IS to cube.

If DSO is also involved in b/w IS and Cube then you have to follow the steps given below:

1. 1. Create transformations on IS.

2. Create and Schedule info package on Data Source- This will pull data from DS to IS i.e PSA.

3. Create transformations on DSO.

4. Create DTP on cube - This will pull data from IS to DSO.

Note: select Full Extraction mode in this DTP

5. Create transformations on cube.

4. Create DTP on cube - This will pull data from ODS to Cube.

Note: select Delta Extraction mode in this DTP.

I hope this piece of information is sufficient to solve your issue.

Regards,

Ashu Gupta.

Former Member
0 Kudos

did u create a DTP to load from PSA to Cube? if so, execute the DTP to load the data. If not, create a DTP between PSA and Cube and schedule it.

Former Member
0 Kudos

Hi voodi,

DTP has been created already but data is not loaded in the cube after scheduling.

Julie

Former Member
0 Kudos

Hi Julie,

For which cube you are loading data. Is that standard cube? From which extractor you are trying to load?

Jayasudha

Former Member
0 Kudos

Hi Jayasudha

I am trying to load using 2LIS_11_VAITM using a custom cube.

Data is updated in psa but cant pass to cube. Transformations and DTP everything is ok.

julie

Former Member
0 Kudos

check whether any routine in transformations is filtering the data.

Are you facing this problem only with this loading?

Jayasudha

Former Member
0 Kudos

Hi ,

can you plz check the update option tab whether you had selected the option of only PSA or PSA and then Data targets .

if it was only PSA then you need to change to PSA and then Data targets then ran the infopackage .

regards,

Baaala.

Former Member
0 Kudos

Hi Baala,

I am using BI7

julie

Former Member
0 Kudos

Hi jayasudha,

I am not using any routines.

julie

Former Member
0 Kudos

Hi Julie,

Did you select the right Datasource and source system when you created your DTP? I suggest you delete your DTP and recreate it with the right selection for the Datasource and source system. Also make sure that you haven't accidently enterd any filter values in your DTP.

I hope this helps.