on 06-09-2011 8:58 AM
hi all,
i run my query using rsrt, and click on performance tab . there is error message:
ORACLE: Table /BIC/FZCCA_C01 has not yet been analyzed
how can i analyzed this ? shall i use rsrv and which part shall i use ?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Just a guess... You might have to refresh Statisitics on the ZCCA_C01 cube.
how do i refresh the statistics on this cube? via rsrv?
Vineet is right. It is about the statistics of the table.
You may firstly try to refresh the statistics for the cube in RSA1 -> cube manage -> performance tab -> refresh statistics.
If this doesn't work, you may also just create the statistics for this table in Tcd: DB20.
Regards,
Patricia
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.