Skip to Content
Author's profile photo Nanda Anantha

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)

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.

How To Find Unused InfoObjects Part – 1.

Assigned Tags

      25 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo CH Raman
      CH Raman

      Very useful article Nanda. Thanks for sharing.

      Thanks

      Author's profile photo Nanda Anantha
      Nanda Anantha
      Blog Post Author

      Thank you Raman

      Author's profile photo Manohar Delampady
      Manohar Delampady

      Hi Nanda,

          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.

      Regards,

        Manohar. D

      Author's profile photo Nanda Anantha
      Nanda Anantha
      Blog Post Author

      Thank you Manohar.

      Author's profile photo Former Member
      Former Member

      Thanks, perfect

      Author's profile photo Nanda Anantha
      Nanda Anantha
      Blog Post Author

      Thank you

      Author's profile photo Prashanth konduru
      Prashanth konduru

      Useful Blog ... thanks for your efforts .

      Bookmarked n rated the blog ...

      Regards

      KP

      Author's profile photo Wasem Hassan
      Wasem Hassan

      its vey useful doc.

      Thanks for sharing. 🙂 🙂

      Regards

      Wasem

      Author's profile photo Nanda Anantha
      Nanda Anantha
      Blog Post Author

      Thank you

      Author's profile photo Anshu Lilhori
      Anshu Lilhori

      This one is really handy and the approach described is apt in such cases..Thanks for your efforts.

      Regards,

      AL

      Author's profile photo Former Member
      Former Member

      Hello Nanda,

      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?

      Thanks,

      Thomas

      Author's profile photo Anshu Lilhori
      Anshu Lilhori

      I have just gone through the code the only thing which needs to be changed

      Parameter w_cube(9) type c OBLIGATORY

      Give it a try and see if that works or not.

      Regards,

      AL

      Author's profile photo Former Member
      Former Member

      Hello Nanda,

      I changed W_CUBE from (8) to (9) and it works.

      Regards,

      Thomas

      Author's profile photo Nanda Anantha
      Nanda Anantha
      Blog Post Author

      Thanks

      Regards,

      Nanda

      Author's profile photo M Tibollo
      M Tibollo

      or:

      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.

      Author's profile photo Anshu Lilhori
      Anshu Lilhori

      This is simply superb..Thanks for sharing this approach..I was not aware those handy tools..I will check the same on my system.

      Author's profile photo Former Member
      Former Member

      Hello,

      BW-TOOLS or something similar does not exist on my 7.31 (SAPKW73106) System in ST13.

      Regards,

      Thomas

      Author's profile photo M Tibollo
      M Tibollo

      this means it's not installed.

      check this post: http://scn.sap.com/thread/1699966

      basis team should be able to manage this.

      BR,

      M.

      Author's profile photo Former Member
      Former Member

      Hi Nanda,

      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.

      Regards,

      Anil

      Author's profile photo Former Member
      Former Member

      Hi Nanda ,

      Very useful article . Thanks.

      Author's profile photo Nanda Anantha
      Nanda Anantha
      Blog Post Author

      Thank you Arun

      Author's profile photo Former Member
      Former Member

      Hi Nanda,

      Good Article.

      Regards,

      Rajesh.

      Author's profile photo Nanda Anantha
      Nanda Anantha
      Blog Post Author

      Thank you Sir

      Author's profile photo Former Member
      Former Member

      Hello,

      Thanks for the post but where I can find the ABAP code? Sadly I can't see it.

      Thanks.

      Author's profile photo Former Member
      Former Member

      Thank you for sharing,

      I cannot find the ABAP Code

      Best Regards,
      Alexandros