cancel
Showing results for 
Search instead for 
Did you mean: 

No data in InfoCube despite succsessful loading

Former Member
0 Kudos

Hi,

I loaded 57 data sets into InfoCube XYZ_002. (57 transferd / 57 added).

The Request ist ready for reporting, QM-Satus is green but i can´t see any data.

If i check "Content" => "Fact Table" I found 57 entrys but on "InfoCube Content" where non.

(no restrictions where selected)

(i testet the cube on rsrv, and it seems to be OK...)

Does anyone have a clue how i can find my data (and transferre it again)?

Where is the Problem, how can i fix it?

Thanks

Greetings

Daniel

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi Daniel,

You might have already done this, and may be silly. But try to Check/choose the Fields for Selection Check boxes etc, No of records, width of the output etc details while seeing the contents in the Cube.

Cheers

Prasad

Former Member
0 Kudos

Hi Prasad,

thanks for your answer.

I already did this. I even made a smal Query for re-checking.

It is not only a problem of showing the data, i even can not transfer it to the next InfoCube. (Update rule, e.t.c. is OK.)

Cheers

Daniel

Former Member
0 Kudos

Hi Daniel,

Could you be more specific, like, what the error/message you are getting after running your sample BEx report (No Applicable data found or some other message), or while trying to update the 1st Cube data further data targets?

Cheers

Prasad

Former Member
0 Kudos

Hi Prasad,

RSA1 shows no error. It shows every column-name (e.g. 0MATERIAL, 0VAL-CLAS and so on) but no rows (entrys).

update to data target: green, 0 from 0 records,

Details:

- Requests (messages): Everything OK

- Extraction (messages): Everything OK

- Transfer (IDocs and TRFC): Missing messages

- Processing (data packet) No data

=> Analysis: - No data available in the source system for this selection

btw: No restrictions (selection) for this update...

Cheers

Daniel

Answers (6)

Answers (6)

Former Member
0 Kudos

Throwed the old cube away. Created it new, made something (?) different. It worked.

Don´t know why.

Greetings

Daniel

Former Member
0 Kudos

Try running this program SAP_FACTVIEWS_RECREATE and then check.

Regards,

Malar

Former Member
0 Kudos

Hi Malar,

after running SAP_FACTVIEWS_RECREATE (including "my" cube) i tried to load data:

0 from 0 Records....

Thanks

Regards,

Daniel

Former Member
0 Kudos

Hi,

After running the program are u able to view the data is source cube???

Check if the datamart(Manage tab of source cube) for the request which u are trying to load is checked.

Regards,

Malar

Former Member
0 Kudos

Hi Malar,

yes, i can see data from this cube (liscube and query).

but i can't transfer Data to another Cube...

Thanks!

Regards

Daniel

0 Kudos

Hi Daniel,

According to me there can be two reasons:

1. In some of the cases, we can nit see the data from the target till we enter any selection for viewing the data.

if possible can u check the data from the source from which u are loading the data.

give one of the selection criteria for veiwing data.

eg. u can check data for a specific material number.

2. If the value for all key figures are coming as zero, then u can not see any data in the content tab.

Hope this will help u.

Mugdha

Former Member
0 Kudos

Hi Daniel,

Is it inventory cube.

regards

Prasad

Former Member
0 Kudos

Hi Prasad,

it is a inventory cube. and i found out, with selection "Record type between 0 and 1" i can find data.

now: how can i transfer these datas to another Cube?

Thanks.

regards

Daniel

Former Member
0 Kudos

Hi Daniel,

Go through this OSS note.I thingk it will be helpful to u.

OSS Note : 353042

Regards

Prasad

Former Member
0 Kudos

Hi Prasad,

thank you very much for this information. This part (extrakting Data from R/3 to BW is "unfortunately" working. I even can see the data.

But i need to extract the data from "0CP_IC_C1" to another cube.

So the question is: how to extract data from "0CP_IC_C1"?

Thank you.

Greetins

Daniel

Former Member
0 Kudos

HI Daniel,

Just chech whether u have compressed the cube with zero elimination if this is the case then there will be no data in the cube if u have any KF's values with 0...

To load the data to another cube just right click on the cube and click generate export data source and u will find one infosource in the infosource tab in rsa1 which prefix 8 to ur cube technical name and create the update rules and infopackage and load the data...

khaja

Former Member
0 Kudos

Hi khaja,

> HI Daniel,

>

> Just chech whether u have compressed the cube

YES

> with zero elimination if this is the case

NO

> then there will be no data in the cube if u have any KF's values with

> 0...

Thanks.

> To load the data to another cube just right click on

> the cube and click generate export data source and u

> will find one infosource in the infosource tab in

> rsa1 which prefix 8 to ur cube technical name and

> create the update rules and infopackage and load the

> data...

This part is clear!

I've made this weeks ago and all i got was "0 From 0 Records"...

Thank you for your help!

Greetings

Daniel

Former Member
0 Kudos

hi,

If you have selection check boxes ,Then you need to provide the Data Selection Criteria in the infopackage scheduler screen.So, this might be one of the reasons.

Also,U can check out the relevant infocube using Tcode listcube.this might help u in understanding the problem.

Regards,

Amar

Former Member
0 Kudos

Hi Amar,

listcube: same as RSA1: column yes, data: no...

check boxes for update: no checkboxes... "normal" selection screen... (btw: full-update)

thanks.

Regards

Daniel

Former Member
0 Kudos

Dear Daniel,

Are you working on BI7?? I have faced similar issue while wokring on BI7 initially, where in you need to go to RSSM and give the infoprovider name in Check for Infoprovider area and get into change mode and uncheck your infoprovider so that you get the relevant authorization to view the data. Hope this may not be the relevant answer but i faced a similar issue like.

Regards

Vijay

Former Member
0 Kudos

Hi Vijay,

I´m still working on BI 3.5 and i checked rssm. No relevant authorization for this cube was activated.

Nevertheless: Thank you!

Regards

Daniel