subquery in webi

[former_member277624]

Hi

I need to run a query to show employees who joined the business between April 7th 2016 and April 6th 2017 and who are still employed on April 6th 2017. The reason for joining the business needs to be either Rehire or New Employee. If all the above is true I then need to show the position that they occupied on April 6th 2017. How would I approach this query - should I be using a subquery somewhere and if so could anyone guide me on how I might construct the query? Many thanks Will

[jyothirmayee_s]

HI,

In WebI query Panel, Bring in the Emp Name , ID, start date, end date, position Id or name.

Within query panel, you can drag the joining date and restrict with Between operator for above said dates.

Once you run the query, you should see all the employees between between April 2016 to April 2017.

Post back your analysis.

Thanks,

Jothi

[CdnConnection]

Will,

It depends on what is you data source? Are you using UNV/UNX? Are you using BW? Sub-queries are supported when using Universe against relational database.

Regards,

Ajay