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

Register | Login 

Want to sponsor BOB? 
Want to sponsor BOB? (Opens a new window)  

General Notice: BOB is going to retire...please see details here.
General Notice: No events within the next 45 days.

[Deski (XI)] Rank vs Alerts


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



Joined: 14 May 2008

Posts: 102


flag
PostPosted: Thu Sep 18, 2008 12:21 am 
Post subject: Rank vs Alerts

Hi,

My requirement like

Top 3 Rank set One colour, Bottom 3 Rank One colour and remaining data another colour how to using Alerts in Deski Report.

Any one help please regarding this one.


Regards,

Kala
Back to top
Jansi
Forum Fanatic
Forum Fanatic



Joined: 12 May 2008
ASUG Icon
Posts: 6577


flag
PostPosted: Thu Sep 18, 2008 12:31 am 
Post subject: Re: Rank vs Alerts

Create a variable say for example rk:
Code:
=Rank(<Dimension>,<Measure>)


Then apply an alerter stating all the conditions such as rank>3, rank <=3, etc,...

Alert for top 3:
Simple and it is just rk <=3

Alert for bottom 3:
Create another variable total
Code:
=NumberofRows(DataProvider(<Dimension>))


And then another bt:
[code]=<total>-3

Alert: rk > bt

Alert for others: Leave them to have the default format itself.

Hope this helps.

_________________
Search is your friend.
I can do all things through Christ who strengthens me. Philippians 4 : 13
God is your protective shade! Wanna read about Your protective shade?!
Back to top
kalabo
Principal Member
Principal Member



Joined: 14 May 2008

Posts: 102


flag
PostPosted: Thu Sep 18, 2008 2:31 am 
Post subject: Re: Rank vs Alerts

Hi,

Many Thanks.


Kala
Back to top
Display posts from previous:   
Register or Login to Post    Forum Index -> Building Reports -> Desktop Intelligence  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.0277 seconds using 18 queries. (SQL 0.0032 Parse 0.0008 Other 0.0237)
CCBot/2.0 (https://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