cancel
Showing results for 
Search instead for 
Did you mean: 

Issue with the overall result at reporting level

Former Member
0 Kudos

Hi Friends,

I have an issue with one report.

My issue is in the Column field for calculating transaction currency im using one Key figure with few restrictions.

Issue is here im getting different currency values for Examp

1000 INR

200INR

100 USD

500 JPY

10JPY

200 EUR

200 RON

________

*

________

like this we are getting values in the result.

At the summation level it is not calculating the total. I'm getting stat(*) symbol at the result column.

My requirement is need to calculate the result as individual currency fields like from the above values

Report output should be

1000 INR

200 INR

_________________

Result= 1200 INR

__________________

100 USD

___________________

Result= 100 USD

____________________

500 JPY

10 JPY

____________________

Result=510JPY

_____________________

etc.

Can anyone suggest me how could i achieve this one. Its urgent

Many thanks in advance

Regards

Aakash G

Accepted Solutions (1)

Accepted Solutions (1)

anshu_lilhori
Active Contributor
0 Kudos

Hi,

Use Nodim function---make a new fromula and add your keyfigure inside it NODIM (KF).

This function is available under data functions.

In case you need to display result currecny wise then workaround can be to restrict kF currency wise and dsiplay the same.So you need to make different columns for it.

Regards,

AL

Former Member
0 Kudos

Hi Saurabh & Anshu,

Thanks so much for the quick response.

Ya with NODIM functionality we ll get overall result with out unit value.

Is it possible to achieve the Currency wise summation value in a single column if yes please let me know

Many thanks

john_lang
Active Participant
0 Kudos

Hi Aakash,

Is it as simple as making sure the last drill down InfoObject is "Currency"?

By adding the currency InfoObject to the left of the key figure result table you will get all the current drill down characteristics sorted and grouped by currency.

Hope this helps.

John.

Former Member
0 Kudos

Adding to what john has said, you turn on the result line property for the last infoobject Currency in the drilldown and you will see the sub totals for each individual currency. Overall result will anyway still remain *.

Regards,

Arunan C

Former Member
0 Kudos

Hi Arunan, John ,

Thanks for the rely

I tried this bit its not working    

Former Member
0 Kudos

Hello Aakash,

so did you add the currency infoobject of that particular keyfigure to the drill down? Did you turn on the result properties of that object? Do you now see sub totals after every currency block like INR, USD? What exactly happens in your currency block subtotals?

Regards,

Arunan C

Former Member
0 Kudos

Hi Aakash,

Add currency characteristic in your drill down and apply exception aggregation on the key figure based on currency characteristic .

It will work.

Regards,

Saurabh Singh

Former Member
0 Kudos

Hi Saurabh,

I dnt know about Exceptional aggregates. How can i achieve this?    

Former Member
0 Kudos

Hi Arunan,

Let me explain what i did here

I have added the Ocurrency field in the Row block.

I have restricted the 0Amount with value type, currency type and i put it in the Column block.

Then for 0currency  in setting-->Display__>Results row changed to Always display from always suppress.

Result block is showing as

for 1st few INR getting sum value the it is not considering next USD again INR values repeating like this happening with other currencies

Please suggest sorry if im troubling you guys

Former Member
0 Kudos
9,628,962.92 INR
222,946.94 INR
268,653.40 INR
$ 3,070.74
*
102,405.42 INR
105,305.56 INR
83,098.14 INR
-132,592.86 INR
18,976.49 RMB
-*
130,747.46 INR
69,317.60 INR

Getting results as this

Former Member
0 Kudos

hmm, you should have seen a subtotal immediately after the INR block. Did you check the currency dimension of your amount keyfigure? Is it 0currency? In your above example, the currency field in the rows should have INR corresponding to your INR amounts and $ across your USD amounts etc. Is this fine? And is the 0currency added as last infoobject in your row?

Former Member
0 Kudos

Ya I dnt have any issue with the figures and the currency i,e USD, INR , JPY etc everything is correct the thing is i need to get individual summation for each currency.

Yea i have added Ocurrency is the last object in the row

Former Member
0 Kudos

Hi Aakash,

In bex query designer click on key figure go to aggregation tab in that u have option of exception aggregation and below in the drill down u have to select characteristic for which u want to define exception aggregation. select currency

Then

first define formula as NODIM for key figure.

Add currency characteristic in your drill down

Regards,

Saurabh Singh

Former Member
0 Kudos

Hi Saurabh,

Ya i tried that one but here that option is not enabled.

I tried by creating new report still that aggregation tab is not enabled.

Do u have any idea about this?     Edit option is also not available to Enable that aggregation tab    

Former Member
0 Kudos

Hi Aakash,

Are u trying to edit query in production ??? u cant edit it in production

  if not I have no idea why it is not enabled sorry .

Regards,

Saurabh Singh

Former Member
0 Kudos

No Saurabh. I'm trying in Development only

Former Member
0 Kudos

Hi Aakash,

No idea why exception tab is not enabled,,,,,,,it is disabled only in  case if you select always hide for the key figure in display tab, or ur query is locked . in ur case dont know why it is not coming

Regards,

Saurabh Singh

anshu_lilhori
Active Contributor
0 Kudos

Hi,

For your informaion--Exception aggregation only works on Formula or CKF.

It cannot be directly applied on Keyfigures.

So i hope you are making a new formula and putting your keyfigure inside it and then trying,If not then please do the same.

Regards,

AL

Former Member
0 Kudos

Hi Aakash,

as Anshu suggested define first NODIM formula for ur key figure first and then apply exception aggregation based on currency field and add currency field in ur query

Regards,

Saurabh Singh

Former Member
0 Kudos

Hi Anshu,

Thanks for the information i will try    

Former Member
0 Kudos

Hi Anshu,

Im getting Exception aggregate option here.

Could you please help me in getting sum values for each Currency separately.

@Saurabh,- I tried what you said but its not working

In Exception Aggegation i selected : Total

& in Ref Char : I have selected : 0currency

anshu_lilhori
Active Contributor
0 Kudos

Hi,

I was wondering and about to reply on the same that exception aggregation is not going to work in your case as it just aggregats the values based on refrence characterisitc.

Its not going to sort the values based on characteristic.

Regards,

AL

Former Member
0 Kudos

Ok ok thanks for the reply once again

Former Member
0 Kudos

I was just reading this thread and my thoughts on this:

You can sort the currency column by right clicking and saying sort by key

Its just a wild card which I can think of and it should work.

Sometimes solution can be simple and hidden from a complex world

Cheers!

Former Member
0 Kudos

Ok I just tried and it works.

So much for being confident

Former Member
0 Kudos

Hi Suyash,

Sorting is working but sum for each currency is not happening.

Former Member
0 Kudos

Akash,

Can you confirm ... one thing.....

have u deactivated all other objects "suppress results only" and on 0 currency field show it as " dipaly results will deff word with respective its currency ex; INR,USD,EURO, here it will first show all EURO data and its result and on.....

Regards,

Padugula

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Aakash,

I am not sure , but try once exception aggregation on the basic of currency characteristic .

Regards,

Saurabh Singh

Former Member
0 Kudos

If it is not possible i need overall result of all the currencies is this possible?

Former Member
0 Kudos

Hi,

for that define a formula as  NODIM for ur key figure and execute report

Regards,

Saurabh Singh