Skip to Content

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….

40 Comments
You must be Logged on to comment or reply to a post.