How to give conditions in a BEx query designer

The query designer formulas sometimes involve if then else kind of conditions or case statement type of logic. These type of logic can be easily given in the query designer, however the procedure is little tricky as you cannot write simple if statements in the query designer.

Scenario –

Suppose you have Amount and Net due date characteristics in the cube. The user gives the key date as query input.

Based on the difference between the net due date and the key date, the query should return whether the amount is

Due (i.e. net due date is in future as compared to key date) or

Overdue (i.e. the net due date is passed as compared to key date).

The query should also return the bucket information if the amount is overdue. Which means that the query should tell that the overdue amount falls in which bucket (>90, 61-90, 31-60 or 1-30).

These buckets are assigned based on the number of days calculated earlier which is the difference between the net due date stored in the cube and the key date entered by the user while query execution.

Also there exists in the transaction data, some data records where the net due date is zero, the query should not process such records.

Ebooks by How2bw

Blog Stats

43,676 hits

About This Site

how2bw is a website to help SAP users mainly in BW/BI. The authors are working in projects themselves and have written posts here about the issues they faced and any concepts they want to share. how2hana.com is another such initiative for helping BW Developers to smoothly transition to BW on HANA.

Get Used to HANA

Copyright @how2bw.com, 2016. Commercial use is prohibited. How2BW is not associated with SAP AG. We have made every effort to provide accurate information. Use the content of this site at your own risk. Images on this website are copyright free or belong to the software.

how2bw is a website started by IT professional working in Business warehousing and analytics using tools like SAP BW and Query Designer with more than 6 years of experience.
The mission of this initiative is to provide handy information which is easy to understand and implement and may turn out to be very useful for those working in projects.
Mostly the software help documents are not so easy to comprehend and search for specific issues. Also the software communities may be difficult to search for.
In such cases, this website information becomes helpful as these are live scenarios experienced in the ongoing projects.
How2hana.com is another such initiative to provide smooth transition of those working in BW to BW on HANA