Purpose:While creating InfoCube we may use huge number of infoobjects at the same time we may
NOT 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. (InfoObjects
which 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)
ABAP
CODE 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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
8 | |
7 | |
6 | |
5 | |
4 | |
4 | |
4 | |
3 | |
3 |