NODIM( ) usage in BEx

[lakshminarasimhan_n4]

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? 

[Former Member · Accepted solution]

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 ?

[lakshminarasimhan_n4 · Accepted solution]

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

[anshu_lilhori · Accepted solution]

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,

AL

[Former Member · Accepted solution]

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