Hi,
The problem is concerning delivery data. There are tons of customer names coming from the source. If I make a prompt page where user can choose which customer's data he want's to see there are a really long list of different customer's names...
How can I restrict the data coming to the prompt so that it will only show the customer names to which has been delivered something over the last 12 months or so?
I have a measure 'Completed' telling the volume as well as object for 'Last 12 months'.
Thanks,
jl
Tune the prompt query with the proper filter on the query itself. This will restrict the set of Customers returned. You can also use a system of Cascading prompts where the user will make a pre-selection in the first prompt (like selection the period as number of months) and then return the list of customers in a second prompt based on input from the first. Lot's of possibilities, Cognos really shines here..
Ok, yes, I just realized I was able to filter the prompt itself...
So now i got the filters:
[Completed] > 0
and
caption ([Year]) >= ('2013')
So it brings me the list of customer names to whom something has been delivered in this year. But I dont get it how can I use that "Last 12 Months" object in the same way so it would bring me the data based on that??
Under that "Last 12 Months" object there's "Month" which shows those actual last 12 months. So if I drag that 'Month' to Prompt Page's Data Item's list and set the Detail Filter: '[Month] is not null', it shows me a list of Customer Names. More than just when there was 'caption ([Year]) >= ('2013')' but not all of Customers though. Guess that's correct then?? :) Not sure if best option though??
Using that item possibly intrduces a join in the SQL acting as a filter. You are aware you can check the proposed SQL to verify?