How to find UNUSED InfoObjects list in BEx Query by comparing with Infoprovider.
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.
Very useful article Nanda. Thanks for sharing.
Thank you Raman
A great blog indeed. Just the thing I was looking for to optimize my newly created infocube. I've figured out some RED dimensions from SAP_INFOCUBE_DESIGN, and I hope this blog will help me drive the final nail into the coffin and remove unwanted infoobjects, there by optimizing the design.
Thank you Manohar.
Useful Blog ... thanks for your efforts .
Bookmarked n rated the blog ...
its vey useful doc.
Thanks for sharing. 🙂 🙂
This one is really handy and the approach described is apt in such cases..Thanks for your efforts.
as I worked with attachted Report for a lot of Cubes now, I see, that the variable works for Cubes with 8 Digits only --- but a lot of Cubes have 9 Digits, as SAP allows 9 Digits.
Could you provide an updated code.txt?
I have just gone through the code the only thing which needs to be changed
Give it a try and see if that works or not.
I changed W_CUBE from (8) to (9) and it works.
ST13 --> input BW-TOOLS --> choose infoobject usage --> F8 --> input your cube/multicube --> F8
==> you get a list with all the queries on this cube/Multicube and which infoobjects are used in these queries.
This is simply superb..Thanks for sharing this approach..I was not aware those handy tools..I will check the same on my system.
BW-TOOLS or something similar does not exist on my 7.31 (SAPKW73106) System in ST13.
this means it's not installed.
check this post: http://scn.sap.com/thread/1699966
basis team should be able to manage this.
This Article looks helpful.
Can you please paste complete ABAP code in your post it self, as my company policies not allowing me to download ZIP files.
Hi Nanda ,
Very useful article . Thanks.
Thank you Arun
Thank you Sir
Thanks for the post but where I can find the ABAP code? Sadly I can't see it.
Thank you for sharing,
I cannot find the ABAP Code