2014 DATA not appearing in SAP BI

[Former Member]

Hi

I partitioned all cubes for 2014 but users can't see data for 2014. I checked data is appearing in SAP BW but not in the report. Any suggestion please?

Thanks

[KodandaPani_KV]

Hi pawan,

As said AL and Raman fallow.

Have you performed the aggregates, roll up, compression check all things one by one, check in aggregates when last used for query.

check the ST05 -> active the SQL trace and filter with ur ID and check multi provider level any missing assignment please check.

Thanks,

phani.

[Former Member]

Hi

Thanks for reply. I found the solution, system didn't copy 2014 aggregates. Could you please give steps how to copy 2013 aggregates to 2014 directly in production.. i know there is function module not remebered now..

please give steps..

thanks

[Former Member]

Hi

Thanks for reply. I found the solution, system didn't copy 2014 aggregates. Could you please give steps how to copy 2013 aggregates to 2014 directly in production.. i know there is function module not remebered now..

please give steps..

thanks

[RamanKorrapati]

Check this - RSDDK_AGGRCOMP_COPY

[KodandaPani_KV]

Select aggregates what ever you want go to aggregate menu select copy, it will copy existing aggregates and make the fixed value as 2014.

Hopes it will help

THANKS

KV.

[RamanKorrapati]

Hi,

Please check your cube--> right click--> manage--> latest req was available for reporting or not.

check aggregates if any. whether its filled or not.

At your bex level, check the filters or restrictions on Time chars any.

Thanks

[anshu_lilhori]

Please check at queries if some year has been hard coded.

Regards,

AL

[Former Member]

Hi

Thanks for reply. I found the solution, system didn't copy 2014 aggregates. Could you please give steps how to copy 2013 aggregates to 2014 directly in production.. i know there is function module not remebered now..

please give steps..

thanks