AnsweredAssumed Answered

Get active person by selecting a date

Question asked by egonsa on Jul 11, 2018
Latest reply on Jul 13, 2018 by anobles

Good afternoon,
probably someone has a good instruction guide or example on how to create cubes to resolve this:

 

I have a mssql table "person" and "person-activity". In the table "person" I have the name, code of the person
and other anagraphic data of  the person. In the table "person-activity" I have the code of the person and the date of
the beginning of the activity and the end date of the activity.

 

In Board I would like to select a day and see all the active person in a dataview.

 

Example 1:

 

a) I select the 20.01.2018
b) table person-activity:
    person a - date of entry = 10.01.2018, end-date = 21.01.2018
    person b - date of entry = 01.05.2018, end-date = 20.05.2018
c) the result = person a

 


Example 2:

 

a) I select the 22.01.2018
b) table person-activity:
    person a - date of entry = 10.01.2018, end-date = 21.01.2018
    person b - date of entry = 01.05.2018, end-date = 20.05.2018
c) the result = any person

 


Is this possible or do I have to prepare the data before the import? For example an import day by day with all the active person?

 

Thanks for your help,
Egon.

Outcomes