Skip to Content
0

Between dates

Apr 13, 2017 at 05:09 PM

46

avatar image

Hi

I have 2 tables in a webi report.

In table 1 I have a start date and the manager name, in some cases the managers name will be blank.There is also a reference number for a job position.

In table 2 I have the reference number of a job position and a start date and end date.

I want to be able to create a variable that will show me either the managers name or blank if there is not one, for the job reference, based on the date range in table 2 (start date/end date), it should look at table 1 and determine from the start date in table 1 who the manager was for that job reference number.

Can anyone recommend how I can achieve this.

many thanks

Will

10 |10000 characters needed characters left characters exceeded

Hi,

Apply Merge on Job Reference in WebI report and create a table bringing in desired dimensions and measure.

Thanks,

Jothi

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

1 Answer

Koen Hesters Apr 14, 2017 at 02:13 PM
0

Hi,

follow Jothi 's explanation. merge the two tables on Job Reference,

then

  1. create variable v_manager as detail of the merged dimension Job Reference
  2. create variable v_mandager_date as detail of the merged dimension Job Reference
  3. you van now create table whith al dimensions (using the variables and the merged dimensions instead of table 1 dimensions)
  4. create variable v_check where you check the dates and show v_manager if it is required.

Can't grasp your data, so it could be the other way around, where you create detail objects of the second table.

But you got the idea

Grtz

Koen

Share
10 |10000 characters needed characters left characters exceeded