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
- 12188 Views
- Cap Gemini, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 " .
| Is This Answer Correct ? | 9 Yes | 1 No |
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.
| Is This Answer Correct ? | 5 Yes | 2 No |
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
| Is This Answer Correct ? | 3 Yes | 1 No |
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)
| Is This Answer Correct ? | 1 Yes | 0 No |
what is meant by scorecards?
Any body help me...what are challenges did u face in Business object project?
'Add objects to the folder' (id - 1) for 'Auto Loans' (id - 2626). Please contact your system or permissions administrator if you require this right.
When is the Repository created?
What are the advantages of setting up LOVs in the Universe?
2 Answers Cap Gemini, Deloitte,
5.what is LOV? where it is store?
Difference between scope of analysis in webi and in deski?
What is Custom Sorting? In development environment we had applied custom Order on Month which is having the following list of values September,October,March,August and December only.But in Production environment Month is having all LiSt of Values like 12 MOnths(Jan to Dec).So ,How it will effect the Sorting in production environmentof universe and as well as in reporting????? Thanks in advance.
what is crosstab reporting,slice and dise and drill mode??
what r the universe connection types?
What is domain? How many are there in a basic setup? What are they?
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
Teradata 
