I have athe value as 100 EUR.My requirement is that i have to show 100 in column A and EUR in column B.I know that i can use No dim functionality to show only the value.But how do i show the currency in a sepatare column.Kindly help.
create the formula and do the IO_technical_name / NODIM( IO_technical_name ) . Now it will display 1 EUR , now make some setting in the decimal points .
Your infoprovider will have a separate Dimension called "Units" . That Dimension contains an infoobject called 0CURRENCY or something similar. You may use that infoobject to report currency independently. Note that this will place the Currency field in the characteristic field area in your Bex Analysis grid, which may not be to your liking.
Since this is a question about BEx, it belongs in the BEx space and not the BI OnDemand space. I've moved the thread, but please use the BEx space for these types of questions in the future.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.