BOB: Business Objects Board
Not endorsed by or affiliated with SAP

Register | Login 

Launch Works 
Launch Works (Opens a new window)  

General Notice: No events within the next 45 days.

Alerts Arrows in webi report
1 members found this topic helpful

 
Search this topic... | Search WebIntelligence XI... | Search Box
Register or Login to Post    Forum Index -> Building Reports -> WebIntelligence XI  Previous TopicPrint TopicNext Topic
Author Message
alex1234
Principal Member
Principal Member



Joined: 13 Sep 2010

Posts: 146



PostPosted: Tue Aug 14, 2012 2:09 pm 
Post subject: Alerts Arrows in webi report

Hi Experts,
I need to integrate up and down arrows in a column in webi report based on the postive increase or decrease from certain point of reference. Is it possible to dispaly up and down arror like a scorecard in webi report. I know we can do alert to display different color of text but how to integrate arrow and alert?
Back to top
erik.stenson
Forum Associate
Forum Associate



Joined: 30 Jul 2012

Posts: 813



PostPosted: Tue Aug 14, 2012 4:07 pm 
Post subject: Re: Alerts Arrows in webi report

in the functions of the formula editor you can check out the char() function. It takes an input of ascii code. I never tried an arrow before but have used it to display other symbols like infinity.

here is a site that discusses ascii codes for arrows

http://stackoverflow.com/questions/2701192/ascii-character-for-up-down-triangle-arrow-to-display-in-html

You could probably just make two variables one for up arrow and one for down arrow using the char() function and then display those based on condition in alerter and choose whatever color you want.

hope that points you in the right direction
Back to top
erik.stenson
Forum Associate
Forum Associate



Joined: 30 Jul 2012

Posts: 813



PostPosted: Tue Aug 14, 2012 4:10 pm 
Post subject: Re: Alerts Arrows in webi report

=Char(9650) gives up
=Char(9660) gives down
Back to top
erik.stenson
Forum Associate
Forum Associate



Joined: 30 Jul 2012

Posts: 813



PostPosted: Tue Aug 14, 2012 4:12 pm 
Post subject: Re: Alerts Arrows in webi report

o found a better list of codes icon_smile.gif

http://www.nwmtwd.com/misc_character_sets.html

up is =char(8593) down is =char(8595)
Back to top
alex1234
Principal Member
Principal Member



Joined: 13 Sep 2010

Posts: 146



PostPosted: Thu Aug 16, 2012 3:35 pm 
Post subject: Re: Alerts Arrows in webi report

Thank you all. I will try that.
Back to top
nitin_gons
Principal Member
Principal Member



Joined: 26 May 2009

Posts: 436
Location: In my Mind...


flag
PostPosted: Fri Aug 17, 2012 1:44 am 
Post subject: Re: Alerts Arrows in webi report

if you want customized arrows(e.g. coloured arrow) you can use Images in the alert...a very helpful technique especially if you want arrows of different shapes(like only triangles) or if you want to show traffic indicators.
Mind you, if you are importing the report to excel the images wont show.
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> WebIntelligence XI  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 5 Hours
 
Jump to:  

Index | About | FAQ | RAG | Privacy | Search |  Register |  Login 

Get community updates via Twitter:

Not endorsed by or affiliated with SAP
Powered by phpBB © phpBB Group
Generated in 0.0542 seconds using 17 queries. (SQL 0.0028 Parse 0.0350 Other 0.0164)
CCBot/2.0 (http://commoncrawl.org/faq/)
Hosted by ForumTopics.com | Terms of Service
phpBB Customizations by the phpBBDoctor.com
Shameless plug for MomentsOfLight.com Moments of Light Logo