Blog Overview
In Past few years SAP BEx designer changed/improved and added few options, however never added an option like deriving characters/strings/flags or status based on business logic ( like Completed, Open, In-Progress, True Or False etc) to derive such values in BEx designer is very difficult and in most of the times it’s not possible also. Apart from this we have few alternatives to bring characters/strings in BEx Analyzer like VB Macros, HTML Script, Java Script, BEx Virtual characteristics or adjusting data targets by adding infoobjects and writing ABAP program to populate desired values as per the business requirement.
Pros and Cons:
To implement above three alternatives we require extra maintenance/time and may lead to performance issues while ET&L and Analyzing data and also in few scenarios full data drop & reload is required.
Let’s take below example
Table | ||
Sales Region | Status | Sales in % |
AUSTRALIA | A = Best |
|
CANADA | C = Bad |
|
CHINA | B = Better |
|
GERMANY | C = Bad |
|
INDIA | B = Better |
|
JAPAN | C = Bad |
|
N KOREA | C = Bad |
|
S KOREA | B = Better |
|
SINGAPORE | B = Better |
|
UK | C = Bad |
|
In above table to derive “Status” column it may require virtual characteristics or add infoobject to data target and write ABAP program.
ROWS
Add Sales Region Infoobject and below this infoobject create new structure
As like below.
Right click on Structure and create 3 selections (Best, Better and Bad)
A = Best
B = Better
C = Bad
Keep the all selections (A, B and C) empty (do not drag & drop any char or key figure) as like below
COLUMNS:
Add key figure into columns and copy same key figure two times as like below and hide one key figure
Now, go to “Cell” Editor TAB
As shown below screenshot
Repeat same steps remaining B = Better and C = Bad “Cells” as above screen
How to derive “Sales in %”
Go to “Cell” TAB and write logic in “New Formula”
My logic as like below
Repeat above step for B = Better and C = Bad , as per your requirement
Settings
Select “Structure” and Right side you able to see structure Properties
Select “Display” TAB and un-check “Structure as Group: Only apply suppression if all elements are 0” as like below
Screenshot:
Select Report Properties and select options as like below screenshot
Now, you can see only “Results” which are required for us.
This Solution will work for similar scenarios as like below
Thanks for reading this Blog.
Regards,
Nanda
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
10 | |
9 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |