Variable Error

[ravi_chandra3]

Hi experts ,

I have created a query based on custom infocube , it is successfully created but when i have created a variable to display date, then when i click on save it is showing me the error message with the following description.

the following is the error msg that i got .

============================================================================

1)Unexpected Error:RFC_ERROR_SYSTEM_FAILURE_EXCEPTION condition ' variable_not_found' raised.

2)Terminate : query designer must be restarted : further work not possible

============================================================================

why i am unable to save the query.reply ASAP.

[michael_devine · Accepted solution]

Hello,

Please execute the ANALYSE_RSZ_TABLES report through SE38 and check for any inconsistency in the query and correct it.

SE38 -> ANALYZE_RSZ_TABLES

Check for any 'Missing elements NOT used in any component.' These query elements are fragments of old queries or other query components not existing anymore in the system. Recommended solution is to delete those records from the table RSZELTXREF.

Regards,

Michael

[ravi_chandra3 · Accepted solution]

hi michael thanx for ureply

can u elaborate more about this plz as i am new to BI.

[michael_devine · Accepted solution]

Hi,

Please see this note for a full explanation of the report: SAP Note No. 792779

"Report ANALYZE_RSZ_TABLES is designed as a check-tool for detecting and solving different types of inconsistencies in the main query definition database tables."

Regards,

Michael

[ravi_chandra3 · Accepted solution]

hi michael i don't have a/c in sap.service.com site plz explain here i will assign full points .

NOte:plz explain in simple words

Thanx

[michael_devine · Accepted solution]

Hi,

Unfortuantely it is not simple. These tables are quite intricately linked. Anyway I would still recommend to run the report.

==Overview==

Report ANALYZE_RSZ_TABLES is designed as a check-tool for detecting and solving different types of inconsistencies in the main query definition database tables. The report performs checks in the tables containing the parts of the definitions of queries and query components: RSRREPDIR, RSZCOMPDIR, RSZCOMPIC, RSZGLOBV, RSZELTDIR, RSZELTXREF and RSZELTTXT.

==Execution==

Open transaction SE38 and run the report ANALYZE_RSZ_TABLES.

==Analysis==

The output is a report on the consistency of the tables mentioned above complete with details and descriptions of problem elements. There you may find some hints relating to the query or variable involved.

I hope this helps.

Michael

[ravi_chandra3 · Accepted solution]

hi michael

one more doubt

i have opened cmod Tcode and in that rsr00001 exit variable i navigated to EXIT_SAPLRRSO_001 FM and i have to write the ABAP code to display the current date. But unfortunately i am unable to write the ABAP code ACTUALLY I CLICKED ON DISPLAY BUTTON BUT STILL not able to write the ABAP code .

[Former Member]

hi ,

After u enter EXIT_SAPLRRSO_001 ,in the next screen u will find include program ,double click on the include click on the change mode, here u will write abap program.

Hope this helps.

Thanks,

Sai

[ravi_chandra3]

hi sai

i clicked on that include then after i clicked on display but still am unable to enter any letters

[Former Member]

Have you defined a customer exit variable? Has this variable been created in SE80/CMOD yet? Have you tried saving the variable alone, i.e. try to save the variable then save the query as a whole?

[ravi_chandra3]

hi kaled thanx for ur reply

i have created the variable using the cmod

i have saved variable first and then the query but still i am gettting the same