Technology Blogs by Members
Explore a vibrant mix of technical expertise, industry insights, and tech buzz in member blogs covering SAP products, technology, and events. Get in the mix!
Showing results for 
Search instead for 
Did you mean: 
Active Contributor

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:

  • Occupy database space
  • No room for new dimension’s for enhancing InfoCube
    with new infoobjects (Ex Merging new company data with existing cube)

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)

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.

How To Find Unused InfoObjects Part - 1.

Labels in this area