Answer / vams_gk

HI,

Create a Variable if(Column<=10000;Column +"^";Column +"V")

Alert on variable value >10000 Red

Sub Alert variable <10000 Grenn

For time being I have kept " ^(CAP) " " V " .

Answer / jai kishan

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.

Answer / padmalatha0923

by using new rule in 4.0 version we can make condition and the value to that condition by using format option in that new rule

Answer / 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)

What are the different types of connections?Explain?

1 Answers   Wipro,

---

What is difference between merged dimension and forced dimension??

1 Answers  

---

can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ? normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

2 Answers   iFlex,

---

how do u migrate BO 6.x to XI ? My Mail id is gunal_prabhu@yahoo.co.in

2 Answers  

---

What is difference between webi and infoview?

0 Answers  

---

How many universes will run maximum in single project

1 Answers   HP,

---

generally how do we get information for creating universes and reports

1 Answers   Satyam,

---

Can we get the data from two different databasess in reporting level?

1 Answers   Infotech,

---

What is a category?

3 Answers  

---

How to restrict the user to refresh or Run the report only 1 time in BO?

6 Answers   Perot Systems,

---

Once the project is submited to the Client. Client says that report is taking long time to run? Where u need to check?

2 Answers   Wipro,

---

whats the Diffrerence between business objects and cognos?

1 Answers  

---