My report needs to show by employee the amount of talk time spent on the phone to customers and the amount of time they were logged in to the phone system.
The talk time is in one fact table, and the login times are in another. So I’m going to need 2 queries.
I want to prompt the user to select a start and end date to run the report for, however I want to avoid them having to enter the dates twice (once for talk time and once for login time).
What’s the easiest way to accomplish this?
I have 3.1 SP2 and so have the option of selecting the 2nd query’s filters based on fields in the 1st query. However this gives me an error “A filter contains a wrong value”.
I have Universe conditions and query filters, both of which are optional so I don’t know which prompt will be used by the user.
I have tried creating a second query that is filtered based on the min and max dates returned by the 1st query.
This will work, however you can’t seem to be able to refresh both queries together. The 2nd query needs results to already be there for it to work. Which makes sense but you must be able to set the execution order of the queries otherwise it’s useless.
What if you refresh the document as such instead of refreshing separate data providers? The order of execution of the queries will be taken care by BO itself.
I meant to say that the report errors when running the queries simultaneously. So it needs the 1st query to have been run before the 2nd can use it’s data.
You might be right, but I can’t get it to work without erroring.
Anyway, Marek’s original idea works fine as I realised I could have multiple Universe conditions for different date fields that had the same prompt text. So the user only sees one prompt, but this gets used to filter multiple tables.
(BOB member since 2003-11-27)
(BOB member since 2008-05-12)