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)

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?

4 Answers   Cap Gemini,

---

What is security level in BO ?

3 Answers   Accenture,

---

what is main functional differences between BO and COGNOs?

5 Answers   TCS,

---

can i use stored procedure in webi?

4 Answers   CTS, Wipro,

---

Can you please send me the migration related issues .

0 Answers  

---

what are cascading prompts explain with steps

4 Answers  

---

HOW TO SEND THE PARTICULAR REPORT DIVISION AND PARTICULAR USER?

2 Answers   Polaris,

---

main purpose of aggregate awareness(not include make possible of use of aggregate tables)

2 Answers   Accenture,

---

1. how do u connect one report with another ? 2. how do u generate reports from different data sources( ex: oracle, sql server)? 3.how do u give the security to universe ?

1 Answers   BNP Paribas,

---

How can you access your repository with different user profiles?

2 Answers   TCS,

---

HOW TO SAVE UNIVERSES AND DOCUMENTS IN THE REPOSITORY?

3 Answers  

---

What is the error that occurs while detecting the cardinalities in the universe pane if we create a join between the normal table and the aggregate table...

1 Answers   TCS,

---