Posted: Wed Jun 28, 2006 3:36 pm Post subject: Re: How do I Filter on a "Rank" in Business Object
when you use rank() function, the variable will become a measure variable, and it will not store any values in it by default. This will stop you from filtering!! If you want to filter then it should be a Dimension variable.
Try apply ranking at the universe level using Database functions. _________________ help us help you! make sure your post has the following elements: • Does it include BO version, Database, an error, a problem, a SQL for object or Condition ?
• Does it include some sample data what you have?
• Does it include any code you already tried ? (working or not..)
• Did you explain what you want for results?
If any of those elements are missing,chances are you didn't post enough information for us to help you!