I have a report where I have a variable computed to give me a ranking of my clients based on their orders. I need to be able to put a filter on the report that will only show me the top 50 clients, but when I try to put a filter on the variable BO will not let me do this. Can anybody tell me what I can do?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Filter on Variables
- Thread starter khansen97
- Start date
Have one dimension column for eg id and one or more measures. Create Variable and assigned to new column. Try to apply rank on dimension here on id. Select id - select format - ranking - top = 50 , based on the variable name.
It will work.
It will work.
- Thread starter
- #3
The variable I am trying to rank on is created from measures from 2 different data providers. I can't create the variable in the query panel. Plus, when I try to apply ranking to my Client ID dimension, the variables I have created are not listed. Only the variables from the query panel are listed. Any Other ideas?
- Thread starter
- #4
Actually I think that I figured out what the real issue is. Hopefully this will help you all to understand what is exactly happening.
I have a variable on the report. It is predefined with a formula behind it. The values returned are a 1 or 0. I want to filter the data on ONLY showing the clients that have a 1 in this column. I know I want to filter on this, but for some reason the filter option is grayed out in the Insert menu. When I try to do this in the Slice and Dice it still does not let me. Its almost like I am not allowed to filter on this value. Any suggestions?
I have a variable on the report. It is predefined with a formula behind it. The values returned are a 1 or 0. I want to filter the data on ONLY showing the clients that have a 1 in this column. I know I want to filter on this, but for some reason the filter option is grayed out in the Insert menu. When I try to do this in the Slice and Dice it still does not let me. Its almost like I am not allowed to filter on this value. Any suggestions?
You have a problem. The ranking trick that we all use to solve this won't work because your variable comes from 2 data providers.
This is one of those rare occasions, where your best answer is to copy the data to Excel and then use the spreadsheet as a source for a different report.
Steve Krandel
Knightsbridge Solutions
formerly BASE Consulting Group
This is one of those rare occasions, where your best answer is to copy the data to Excel and then use the spreadsheet as a source for a different report.
Steve Krandel
Knightsbridge Solutions
formerly BASE Consulting Group
Would this not be doable using a complex filter ???
Select the table and right click
Choose Format Filters
Add the measure and then click on Define
enter the formula as
=<VariableName>=1
to filter on the ones
Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
Select the table and right click
Choose Format Filters
Add the measure and then click on Define
enter the formula as
=<VariableName>=1
to filter on the ones
Rgds, Geoff
[blue]Si hoc signum legere potes, operis boni in rebus Latinus alacribus et fructuosis potiri potes![/blue]
Want the [red]best[/red] answers to your questions ? faq222-2244
No, a filter won't work because this is an aggregated variable. This is really an unsolveable problem. The variable can't be filtered because it is aggregated. It cannot be ranked upon because it comes from multiple data providers.
Steve Krandel
Westbay Solutions
Steve Krandel
Westbay Solutions
- Status
Similar threads
- Locked
- Question
- Locked
- Question