Skip to Content
Author's profile photo Raman Korrapati

How to Hide Compounding object from bex display

Introduction:  Thru my doc am covering below 3 points.

  1. How to hide compounding info object
  2. How to show key fig without currency.    
  3. How to show currencies saperate from key fig

        Over the period on scn very frequently i am seeing how to hide compoding at bex.  i thought share useful steps with simple way.

Here am taking 0GL_ACCOUNT and compounding info object 0CHRT_ACCTS.

/wp-content/uploads/2013/10/1_302628.jpg

  How to hide compound info object: 

As usual am taking Gl account and comp code into rows and amount into columns.

/wp-content/uploads/2013/10/1_302628.jpg

Thru above design my our put look like below. it shows chart of accounts/glaccount in GL Account column.

/wp-content/uploads/2013/10/1_302628.jpg

  

Above Gl account showing as X001/number. (X001 – Chart of accounts / number – gl account no.)

Now I need remove compounding info object 0chart_accts(X001)from display.

Now am dragging 0chart_Accts into rows and display as No display. Gl account and comp code display as key .

Always compounded object need to be placeed above to primary info object to hide from display. Like below

/wp-content/uploads/2013/10/1_302628.jpg

  Now my output results will be shown without coumpounded info object. Observe gl account clolumn.

/wp-content/uploads/2013/10/1_302628.jpg

If you want to remove result display for comp code then right click on that column–> properties–> Results rows–>always suppress.

/wp-content/uploads/2013/10/1_302628.jpg

  Once you choose always suppress then you won’t result row for every comp code. We will results at end of of the rows.As shown below.

/wp-content/uploads/2013/10/1_302628.jpg

 

Now we can see result rows at end of the results. My results rows are not showing total amount due to the different currencies.  So now I will display currecnies and amount in separate columns.

2. Show key fig without currency.

  To remove units/currencies we need to use NODIM data function with new formula. So along with amount key fig am creating new formula with use of NODIM function.

/wp-content/uploads/2013/10/1_302628.jpg

So in my columns I have amount and amount without currency(new formula). So now my out put results are below.

/wp-content/uploads/2013/10/1_302628.jpg

  If we hide amount from display we can see amount without currency only.

3. How to see currency as separate column

  Drag currency into rows , display as key.

/wp-content/uploads/2013/10/1_302628.jpg

So my out will be like below. Its ads currency column to above pic.

/wp-content/uploads/2013/10/1_302628.jpg

  Now I will hide amount from display(graded out). So our output report will looks perfect as we needed. Separate columns
for currency and amounts without currencies.

/wp-content/uploads/2013/10/1_302628.jpg

So here we see the out put as needed.

/wp-content/uploads/2013/10/1_302628.jpg

Thanks for reading….

Assigned Tags

      40 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Raman Korrapati
      Raman Korrapati
      Blog Post Author

      Glad receive first comments from the Bex specialist. Thank You Anshu.

      Thanks

      Author's profile photo Anshu Lilhori
      Anshu Lilhori

      Thanks for your kind words and this new title which you gave me i hope i embrace it properly. 😉

      Regards,

      AL

      Author's profile photo Former Member
      Former Member

      Good document, Thanks For Presenting  with detail steps.

      Author's profile photo Raman Korrapati
      Raman Korrapati
      Blog Post Author

      Thank You Giri

      Author's profile photo Krishna Chaitanya
      Krishna Chaitanya

      Nice one Raman.. Thanks for sharing..

      Seems that you, Anshu, and Suman all are on the same page 😉

      Regards,

      Krishna Chaitanya.

      Author's profile photo Raman Korrapati
      Raman Korrapati
      Blog Post Author

      Thanks for your compliments. But fact is anshu/suman are masters on bex.

      Thank You.

      Author's profile photo Former Member
      Former Member

      Thats really a useful information. This issue frequently occurs with many of us.

      Thanks a lot Ramna for sharing it.

      Regards,

      Priyanka

      Author's profile photo Former Member
      Former Member

      Nice Document Raman

      Author's profile photo Former Member
      Former Member

      Short and Simple explanation.. 🙂

      Author's profile photo Suman Chakravarthy K
      Suman Chakravarthy K

      Fantastic workarounds Raman 🙂 . Simple and nice..Thanks for sharing..

      Author's profile photo Raman Korrapati
      Raman Korrapati
      Blog Post Author

      Thanks for your kind words and appreciation.

      Author's profile photo Former Member
      Former Member

      Very nice document.

      Regards,

      Sushants

      Author's profile photo Yasemin ULUTURK
      Yasemin ULUTURK

      It covers very useful info that will help many colleagues. Well explained with screenshots. Nice job Raman, thank you for sharing.

      Regards

      Yasemin..

      Author's profile photo Manna Das
      Manna Das

      one more example of exploring new options in BI, great stuff, thanks for sharing

      Kind Regards

      Manna Das

      Author's profile photo Satendra Mishra
      Satendra Mishra

      Nice information raman.

      🙂

      Regards,

      SM

      Author's profile photo karthick Ravichandran
      karthick Ravichandran

      Very Useful Document Ram. Good Presenation and Stuffs.

      Regards,

      karthick

      Author's profile photo Martin Grob
      Martin Grob

      Hi Raman "How to hide compounding info object" is a nice approach haven't seen this solution before. Thanks for pointing it out.

      Martin

      Author's profile photo Sriram Vijay R
      Sriram Vijay R

      Thanks for sharing.

      in the last screenshot, are the result are cumulated irrespective of currency?

      Author's profile photo Raman Korrapati
      Raman Korrapati
      Blog Post Author

      Yes, Its summation of amount irrespective of currency.

      Author's profile photo Former Member
      Former Member

      These are some great tips, thanks for posting 🙂

      Author's profile photo Former Member
      Former Member

      Verh good document to read. 😆 .

      Author's profile photo Former Member
      Former Member

      Hiding Compounded InfoObject part is new learning for me.

      Thanks for Sharing 🙂

      Author's profile photo Nitesh Kumar
      Nitesh Kumar

      Dear Raman,

      Congratulations for entering the Top 50 list in SCN 🙂 .

      Your exploration on BI arena are really fabulous.

      Thank you for sharing one more nice document 🙂 .

      Regards,

      Nitesh

      Author's profile photo Raman Korrapati
      Raman Korrapati
      Blog Post Author

      Thank You Nitesh.

      Author's profile photo Former Member
      Former Member

      Very nice document 🙂

      Author's profile photo Former Member
      Former Member

      Well explained with screen shots.

      Thanks for sharing.

      Rgds

      Haritha

      Author's profile photo Former Member
      Former Member

      Nice one Raman....

      Keep Posting!!!

      Thanks,

      Purushotham. 🙂

      Author's profile photo Former Member
      Former Member

      Simply super.

      Author's profile photo Shyamala Valeti
      Shyamala Valeti

      Fabulous Document Raman.

      Thanks

      Shyamala

      Author's profile photo Former Member
      Former Member

      Thanks for pointing it out !

      Author's profile photo Former Member
      Former Member

      Very nice presentation and detailed explanation.

      Thanks for sharing.

      Author's profile photo Aparajit Banik
      Aparajit Banik

      Rama,
      Learning every day new from you..and your contributions!
      Heartiest Thanks! 🙂
      ` Aparajit

      Author's profile photo karthick Ravichandran
      karthick Ravichandran

      Very Detailed Explanation with your clear screenshots.

      Thanks Ram

      Author's profile photo Naveen Pathipaka
      Naveen Pathipaka

      Very nice presentation and Keep Posting!!!

      ---

      Naveen

      Author's profile photo Former Member
      Former Member

      Hi Raman

      This is regarding first part of your instruction: hiding of compounded element.

      Imagine that in your example you have two chart of accounts values in the data that your report should show.

      So before applying the instructions you would see sth like this:

      ChrtOf Acc/GLAccount     Key Figure

      X001/131000                    100

      X002/131000                    200

      After applying your instruction you will see this:

      131000                              100

      131000                       200

      Is there a way to have the result like this:

      131000                      300

      ?

      Kind regards,

      Adrian

      Author's profile photo Former Member
      Former Member

      Thank you for your valuable Document. Helped me a lot. Your help is greatly appreciated. 🙂

      Author's profile photo Arivazhagan Sivasamy
      Arivazhagan Sivasamy

      Nice document Raman.

      Arivazhagan. S

      Author's profile photo Former Member
      Former Member

      Thank you for the document Guru

      Author's profile photo Former Member
      Former Member

      Hi Rama, Nice post!

      Thank you for shared this information.


      Best Regards

      Venkat...

      Author's profile photo Former Member
      Former Member

      Nice  post.

      Regards,

      Syed.