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)

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,

---

what is crosstab reporting,slice and dise and drill mode??

3 Answers  

---

what is casual dimension?

1 Answers   CA,

---

From Business Objects Web-I reports, we can link to other BO reports using Opendoc functinality. How do we link to reports in other reporting tool or how to give a link any website?

1 Answers  

---

why do we use crystal reports rather than webintelligence reports ?

7 Answers   CTS, Tech Mahindra,

---

Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

0 Answers  

---

1.How to convert deski document to webi in infoview? 2.what is connection type for free hand sql?

3 Answers   Wipro,

---

please differentiate star schema and snow fleak schema with dimension table, how end user is depending on them in creating reports.

1 Answers   Exilant, Wipro,

---

Explain about Short cut join?

2 Answers   Wipro,

---

When we go for OLAP , and When we go for OLTP for generating the reports ?

3 Answers   Honeywell,

---

if we shortcut join between two tables what will be the output?that it will give all columns or same columns?

2 Answers  

---

What is the diff b/w BO webi reports, crystal reports and xcelsius ? Thanks...

7 Answers   TCS,

---