No Data Returned on InfoSet over InfoCube - BW 7.4 SP7 MSSQL 10.0

[john_hawk]

Hi Gang,

My client has just upgraded to BW 7.4 SP7 MSSQL 10.0. Post upgrade, we are not able to return data from InfoSets containing basic InfoCubes through "Display Data", RSRT, or BEx. I have not been able to find an SAP Note of this subject.

Has anyone else had this problem?

Thanks,

John Hawk

[john_hawk · Accepted solution]

The Answer is -

Program SAP_FACTVIEWS_RECREATE per SAP Note 1993916  generate views for InfoCube E- F-fact tables post upgrade.

[RamanKorrapati · Accepted solution]

Thanks John for sharing program and sap note.

[Former Member]

Hi all,

plaese suggest a solution to me

In our SAP IDES ECC 6.0 EHP 5 system some data had missed(some plants info had missed) in 800 client, I checked 000 client here also no data..we don't have any backup for IDES. If I download the IDES from market place, then is it possible to get entire data of 000 & 800 clients. Could you please any one help me how to get back the data ..

Thanks in Advance

Regards,

Venkatesh B

[RamanKorrapati]

Hi Venkat,

This is BW forum and never post/include your issue in other threads.

if your facing problem about plant data then please post your issue at SAP MM forum.

MM forum link can find below link.

How to create a discussion:

http://scn.sap.com/docs/DOC-46003

Thanks

[Former Member]

Hi Ram,

Actually I am very new to this website, sorry for inconvinience, thanks for ur help..

regards,

Venkat

[former_member210615]

did you try activating the objects in flow, sometimes this issue haapens after the upgrade.

hope it helps

-laksh

[john_hawk]

Yes, we have verified

[KodandaPani_KV]

Hi,

please check the join conditions on info set.

have you performed any aggregarets after do roll up function and compression if you performed.

check the data in using T-CODE- LISTCUBE

Thanks,

Phani.

[RamanKorrapati]

Hi John,

at info cube level, all requests are available for reporting?

filling aggregates are done properly if exist?

please check thru LISTCUBE.

try to run program - RSQ_ISET_MASS_OPERATIONS and later try to check data from info set thru bex report.

Thanks

[john_hawk]

Yes, data is available in the component InfoProvider, as verified through "Data Display"

We have also verified the joins.

[RamanKorrapati]

Have you ran above program? please run and check the reporting on info set.

[john_hawk]

I have executed the program, and still no data is returned. I believe this to be a bug.

[RamanKorrapati]

Seems like that. mean while try to search oss note at sap market place.

In time please raise to SAP support.