Question Re: NODIM( ) usage in BEx in Technology Q&A

NODIM( ) usage in BEx

lakshminarasimhan_n4 — Mon, 11 Feb 2013 09:21:30 GMT

Dear Gurus,

I have 0cumulativebalance Keyfigure it was displaying currency key along with currency value Ex: 100 SAR. Now i wanted to bring the SAR into the KF column, and display only the currency values in the KF columns. so i have used a formula variable and included the KF 0cumulativebalance within NODIM(). But to my suprise i am not getting the SAR in the column of the KF.

Am i missing something?

Re: NODIM( ) usage in BEx

Former Member — Mon, 11 Feb 2013 09:27:48 GMT

NODIM(KEY) : Deassociate the Values from Measurement Unit to perform calculation.

So it is working as expected. It removed SAR unit.
Can you be more clear in what you asked for ?

Re: NODIM( ) usage in BEx

lakshminarasimhan_n4 — Mon, 11 Feb 2013 09:46:07 GMT

I have GL report, and it contains a keyfigure 0cumulativebalance, now when i run the query the output is like given below

Cumulative BalanceDEC 2012

-86,75,749.87 SAR

-2,19,700.00 SAR

-444.00 SAR

-8,400.00 SAR

34,833.33 SAR

0.00 SAR

-200.00 SAR

-2,80,359.59 SAR

-6,500.00 SAR

-91,56,520.13 SAR

But what i require is as given below

Cumulative BalanceDEC 2012 SAR

-86,75,749.87

-2,19,700.00

-444.00

-8,400.00

34,833.33

0.00

-200.00

-2,80,359.59

-6,500.00

-91,56,520.13

Re: NODIM( ) usage in BEx

anshu_lilhori — Mon, 11 Feb 2013 09:57:32 GMT

Hi,

You may use NODIM so it will remove the dimension from the keyfigure.

To display unit at the top of column--Go to query properties---Display tab--tick the check box Display scaling factors for keyfigures.

Hope this helps.

Regards,

Re: NODIM( ) usage in BEx

Former Member — Mon, 11 Feb 2013 10:13:36 GMT

Well,

If I understood it correctly you want it as below.

Cumulative Balance DEC 2012 SAR

-86,75,749.87

-2,19,700.00

To my understanding Unit only appear in header as above(by default) if that field would always fetch the same unit i.e in this case SAR everytime. In your case other values beside SAR is also possible hence not appearing in Header.

You can try this if you still want your data to appear as above

Use Description "Cumulative Balance DEC 2012 SAR"

Formula Variable : NODIM(0cumulativebalance) [Fix decimal places and sign as desired]

Regards

Sachin