What is Nodim in BEx?

What is Nodim in BEx?

Data function in BW BEx Query Designer NODIM is used to remove unit or currencies from key figures. It is useful while you need to calculate over key figures with different units or currencies.

How do I create a query in BEx Analyzer?

Navigate to Tools → BEx Query Designer in the Web Application Designer or It can also be accessed via the BEx Report Designer → Tools → BEx Query Designer. To define a new query, you need to navigate to Query → New in the Query Designer.

How do I use BEx Analyzer in Excel?

To start the BEx Analyzer, choose Start→ All Programs → Business Explorer →Analyze. This will open Microsoft Excel with the SAP BEx plugins enabled. A window will pop up asking you to log on to the BW system.

How do I edit a BEx query?

BEx Analyzer: If you are already in a cell of the query, in the analysis toolbar, choose Tools → Change Query . The Query Designer opens with the associated query….

1. Display the query in the Query Designer.
2. You can now make changes in the query definition.
3. You have two options for saving the query:

How do you add a query to a BEx role?

Go to the query in change mode and in the tool bar you will se e broadcast icon, You will see a option “Broadcast in a role”. CLick that and you can select a role and assign.

How do I activate BEx query?

Turn a BEx query into a Gateway service….Generate the project.

1. Create a new service in the Gateway HUB with this model in transaction: /IWFND/MAINT_SERVICE.
2. Activate and test the service.
3. Pull up the $metadata by appending it to the URL.

Can we use CKF in RKF?

Logic to caluclate the CKF (indicator) : Calculated the difference between dates and If output is >= 1 then 1 else 0. And created one RKF based on the CKF and restricted based on characteristics. When im seeing the query output, the RKF displays 1 in all the rows and its not restricted for the particular values.

How do I connect BEx query to analysis for office?

1.3 Procedure

1. Select Convert BEx workbook option from File ->Analysis tab.
2. Log onto the BW system by entering your credentials and click on Next.
3. Select the workbook you want to convert.
4. Only supported objects are converted and others remain as BEx Objects.
5. Once you choose to convert, the conversion starts right away.

How do you execute a query in BEx Analyzer?

Log into Bex Analyzer -> Open Query -> Select ROLE Folder -> Execute Query.

How to use nodim function in BW Bex Query Designer?

BEx Query Designer: Usage of NODIM function in formulas Data function in BW BEx Query Designer NODIM is used to remove unit or currencies from key figures. It is useful while you need to calculate over key figures with different units or currencies.

Is nodim(key) working as expected?

If you have an answer for this question, then please use the Your Answer form at the bottom of the page instead. NODIM (KEY) : Deassociate the Values from Measurement Unit to perform calculation. So it is working as expected.

What happens if the denominator equals zero in Bex?

If denominator equals zero, then based on your BEx global settings, it displays the character you set for ‘division by 0’operations.For example: #, X, blank space, 0 etc. In (Fig: 1) -> % share of ‘April Sales’ in ‘Total Sales’ is calculated as highlighted below: