-
1. Re: Top 10 in Set Not Pulling Top 10
John Sobczak Jun 20, 2016 8:10 AM (in response to Torey Weiss)I think the key is what dimension is the set based off of? You have several dimensions in the view.
-
2. Re: Top 10 in Set Not Pulling Top 10
Torey Weiss Jun 20, 2016 8:18 AM (in response to John Sobczak)The set is based off of the ID. So Top 10 IDs based on C. AUM.
-
3. Re: Top 10 in Set Not Pulling Top 10
Saurabh Singhal Jun 20, 2016 8:20 AM (in response to Torey Weiss)Hey Torey,
What is the Field/ Dimension on which the 'Set' has been created? If the intention is to display top 10 by Product Names, then the SET must be defined over Product Name. Hope that would resolve the problem.
-
4. Re: Top 10 in Set Not Pulling Top 10
Torey Weiss Jun 20, 2016 8:46 AM (in response to Saurabh Singhal)The Set is based on the ID dimension. Which is just a combination of Firm Name and Product Name.
-
5. Re: Top 10 in Set Not Pulling Top 10
John Sobczak Jun 20, 2016 8:24 AM (in response to Torey Weiss)Do you have any filters in your view - such as a date filter? If so, have you tried setting it to a context filter?
-
6. Re: Top 10 in Set Not Pulling Top 10
Torey Weiss Jun 20, 2016 8:46 AM (in response to John Sobczak)Yes! That worked. Thank you!
-
7. Re: Top 10 in Set Not Pulling Top 10
Torey Weiss Jun 20, 2016 10:35 AM (in response to John Sobczak)John,
Could you please explain the logic behind this so I can understand going forward?
Thank you!
-
8. Re: Top 10 in Set Not Pulling Top 10
John Sobczak Jun 20, 2016 10:43 AM (in response to Torey Weiss)The simplest way to think of it is that the query going to the data source queries ALL records independent of filters. Setting filters to context will only use the relevant filtered records.
-
9. Re: Top 10 in Set Not Pulling Top 10
Torey Weiss Jun 20, 2016 10:45 AM (in response to John Sobczak)Ok. Great, thanks again!
-
10. Re: Top 10 in Set Not Pulling Top 10
John Sobczak Jun 20, 2016 10:49 AM (in response to Torey Weiss)Torey, Sure. Can you mark this thread as correct to close it? Thanks.