ANALYZE_RSZ_TABLES

[Former Member]

Hi SDN,

By executing ANALYZE_RSZ_TABLES program, does it going to change any RSZ tables? I am trying to make sure before I try running this program.

Please give your thoughts.

thanks

[Former Member · Accepted solution]

The program does NOT update/delete anything just by running it. It will idenitfy a variety of problems, and for some, will provide options to correct/delete the items it flags.

Depending on what system you run this on and the nature of the inconsistency, you may be required to Open up BEx requests for the deletions to to work if th eobjects had been transported previously, e.g. if you previously deleted an InfoProvider, but not the queries on the InfoProvider.

[Former Member · Accepted solution]

Hi Pizzaman,

what I understand is, this program essentially identifies the potential inconsistencies related to queries but <b>donot</b> rectifies any of those problems.We need to follow the recommendations given by the report to fix the issues.right?

Can you please reply to this thread as well.

Best regards,

[Former Member · Accepted solution]

Some of the inconsistencies are things that you can simply select the corrective option the program offers. Other items that are reported are things you probably will take no action on, e.g. the pgm flags variables that have the same name as an InfoObject.

The program checks perhaps 15 - 20 things as I recall, and in the results, offers and option to run another program to perform an extended analysis of certain query components.

Run the program in your test environment and review the results. The OSS Note on this program and the rpt itself offers explanations and suggested actions. You can exit the program if you are not ready to take action or are still unsure.

As far as the other thread - Bhanu's link to the Modeling document is a good one. THe document does a good job of explaining the joins that occur when you include a Nav Attr in a query. Have you ever reviewed the SQL stmt that is generated? That's a good way to understand what's going on. You can either use tran RSRT to run a query in debug mode to get an Explain or using tran ST04.

[Former Member]

Hi,

For sure the report allows some small changes in RSZ* tables. This is the way how small inconsistencies can be solved. In some cases also deletions are possible. All these operations are pretty safe for other existing queries...

Regards,

Maxim

[Former Member]

To my knowledge this reports only checks for incosistencies but does not make any changes to the RSZ* tables. It is an analysis tool but not a correction tool.

Please refer to the SAP Note 792779 for more info. Good luck!