You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How do you filter on the results of another OTBI analysis in combination with a date prompt?

Received Response


I want to be able to split workers who are paid and unpaid and break them down by age, BU etc etc. Those who are paid may have additional assignments as non-workers so the simplest way I can think of is have one analysis that defines those who have the appropriate payroll relationship and define the unpaid people as being those who aren't in the first analysis. This seems to work with today's data but when I add a date prompt I get SQL errors. Is it possible to do this with an effective date prompt or

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!