How to Hide Compounding object from bex display
Introduction: Thru my doc am covering below 3 points.
- How to hide compounding info object
- How to show key fig without currency.
- 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.
How to hide compound info object:
As usual am taking Gl account and comp code into rows and amount into columns.
Thru above design my our put look like below. it shows chart of accounts/glaccount in GL Account column.
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
Now my output results will be shown without coumpounded info object. Observe gl account clolumn.
If you want to remove result display for comp code then right click on that column–> properties–> Results rows–>always suppress.
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.
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.
So in my columns I have amount and amount without currency(new formula). So now my out put results are below.
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.
So my out will be like below. Its ads currency column to above pic.
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.
So here we see the out put as needed.
Thanks for reading….