Dayly and monthly measure's in one report — Oracle Analytics

Oracle Analytics Cloud and Server

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Cloud and Server

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Dayly and monthly measure's in one report

Received Response
11
Views
3
Comments
Alex Sharkov
Alex Sharkov Rank 5 - Community Champion
edited Aug 13, 2024 5:27PM in Oracle Analytics Cloud and Server

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?

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Alex,

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

    pastedImage_0.png

  • Alex Sharkov
    Alex Sharkov Rank 5 - Community Champion

    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]
    [Deleted User] Rank 2 - Community Beginner

    Aggregate by dimension "Time" = FIRST ;-)

    pastedImage_0.png