Purpose:While creating InfoCube we may use huge number of infoobjects at the same time we mayNOT use all infoobjects in BEx Report .
Disadvantages of holding unused infoobjects in InfoCube:
How to identify such unused infoobjects in InfoCube
Step 1: To get list infobojects used in Infocube goto table RSDCUBEIOBJ and give Infocube name execute
For Mulitprovider use table RSDICMULTIIOBJ
For DSO/ODS used table RSDODSOIOBJ
For Infoset use table RSQFOBJ
Step 2: Download all content in excel sheet
Step 3: Use following ABAP Code, it will generate one excel sheet in given path
Step 4: Filter value 1KYFNM with in column E and delete all records and after delete duplicate infoobjects.
Step 5: Compare both sheets infoobjects with VLOOKUP function in excel sheet. (InfoObjectswhich are not there in excel sheet which is generated through ABAP program those are unused infoobjects)
RSZ_X_COMPONENT_GET:Function module pull all infoobjects used in report (like in selections, filters and restricted key figures)
ABAPCODE Attached to the BLOG.
Note: You may change ABAP code as per your requirement.
Please find the new enhanced ABAP program to display unused infoobjects.
How To Find Unused InfoObjects Part - 1.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.