Skip to Content

subquery in webi

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

Add comment
10|10000 characters needed 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

  • Get RSS Feed

1 Answer

  • Jun 20, 2017 at 02:41 PM

    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

    Add comment
    10|10000 characters needed characters exceeded