Skip to Content
0

subquery in webi

Jun 11, 2017 at 10:14 AM

123

avatar image

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

10 |10000 characters needed characters left characters exceeded

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

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Ajay Gupta Jun 20, 2017 at 02:41 PM
0

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

Share
10 |10000 characters needed characters left characters exceeded