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?
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference in creating filters in designer and business objects?
Explain how can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
What is a fantrap in business objects?
Differences between business objects and web intelligence reports?
In banking domain how many Fact tables,Dimension table are present?
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....
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
what will be the contents for a functional requirements specifications
Difference between b.o 5.1 and 6.1b?
What would you consider as your biggest achievement and why?
Did you face any problems while creating reports? Name? Solutions?
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?