Dayly and monthly measure's in one report

Question

Hi all

i gather dayly

1.  measure's  (fact_dayly_measure) (id_employee,date, measure1,measure2)

2. fact_dayly_measure coonect with Employee  , so in one day- all Emloyee with many attributes, changed day by day

3. fact_dayly_measure  connect with Calendar

So i need now add Plan_monthly_table that  consist monthly plan for employee. Of course measure's in plan_monthly_table  are diffirent  fact_dayly_measure

Is way union dayly and monthly measure ? Seems to be Employee  with dayly cannot to be conformed for plan_monthly_table

Is some tricks for to do it?

[Deleted User] · Answer

Aggregate by dimension "Time" = FIRST ;-)

Alex Sharkov · Answer

Thanks Christian!

That's work

But i have some problem with Employee now due to i formed on day   and plan_monthly_table  on month

and have to connect Empl on first day of month (just like this:

"PRECLEMP_REP_DATE" = "PLAN_DATE_MONTH" AND "PRECLEMP_EMPL_LOGIN" = "EMPL_LOGIN")

so Employee  may be not exist on first day of month

That's problem..

[Deleted User] · Answer

Alex,

just tie the measures to the respective level of a properly formed time dimension.