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)

Can more than 1 metric be applied on an analytic in business objects?

2100

---

What task is 98% of the required work of a business analyst?

987

---

What's the Functional & Architectural Differences between Business Objects & Web Intelligence Reports?

2078

---

What is the profile and package?

2251

---

Can you please send me the migration related issues .

2032

---

Explain about a tricky situation for which you found a very simple solution?

943

---

Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....

1889

---

What is the difference between absolute and relative div positioning?

986

---

Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?

1060

---

What is difference between custom hierarchy and report based hierarchy?

954

---

Explain about a time when you discovered a more efficient way to do a work task?

1089

---

What is the difference between slice and dice and cross tab report?

997

---

Can anybody tell me what are the tuning problems?

1993

---

Explain the difference between detect alias and detect context?

1045

---

hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message

2010

---