In a column if the value is >10000, it has to show downwards
Arrow in green color,
If the value is <10000, it has to show upwards arrow in red
Color....
How to achieve this?
Answer Posted / anjireddy pothireddy
Hi All,
Business always interested in Trend/Arrows in tables instead of numbers .In 4.0 IPAD we can get this by writing some code.
we can use images and hyperlinks to get the same .But it needs some maintenance.
End Result
This blog gives you simple trick to show Trend/Arrows in your webi report as per condition.
We know that we can use ascii values in webi with CHAR() function.
CHAR(9660 ) - DOWN ARROW
CHAR(9650 ) - UP ARROW
CHAR(9679 ) - CIRCLE
> Insert new column to show Arrows/Icons
>Write alerter with sub alter to show Arrows/Icons with different colors as per condition.
>write condition : Sales Qty less 10
Format alerter as per requirement. In my case DOWN Arrow
Set color for ARROW :RED and width of arrow (you can change it by increasing font size and style as BOLD)
Now you need to create sub alert for the Sales Qty greater than 10
create alert
Format :
Display : =CHAR(9650)
Format : GREEN color
Now apply Alert in your blank column. That's it
Similarly you can create Alerters for ICONS also.
You can get ascii char values for different shapes from here
Code Charts
Unicode character table
Note : You can use all the ascii codes. Neglect &# and use the number .Some of them may give (rectangle box) in rich client /rich internet mode ,but you'll get the symbol in html mode (reading)
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
in sap bi we have wad, then why we go for sap bo
What is aggregate table and aggregate fact table ... Any examples of both?
Explain what is the difference between slice and dice and cross tab report?
How to create Index to the table in the universe designer and how it improves the Query performence
Explain what would you consider as your biggest achievement and why?
Explain about a task that really tested your analytical abilities?
Explain what three things do you consider to be the most important factors for a manager?
Which versions are used in the bo dashboard work?
Explain is it the job of a business analyst or systems analyst to draw the class diagram?
Can more than 1 metric be applied on an analytic in business objects?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
What are the steps to do to use alerts in bo?
Explain the difference between detect alias and detect context?