I have created a custom table with the following fields: PersonID, PersonNumber, Month, Year, MonthStartDate, MonthEndDate, CountDays (measure), and CountOfficeDays. Using the Sandbox Framework, I created a logical star schema for this fact table and successfully joined it with the existing Worker dimension. After modifying the Absence subject area to include this new fact, everything seems to be working fine. However, I am facing an issue when trying to join this fact table to the Time dimension within the seeded Absences subject area.While I can pull person-related details like department and other information from the Worker dimension, I’m unable to add any Time dimension fields to the visualization. I even tested a version of the custom table without the MonthStartDate and MonthEndDate fields (i.e., PersonID, PersonNumber, Month, Year, CountDays (measure), CountOfficeDays(measure), but the issue persists.

The question I have is: If I am loading data for each person for every month of the year, what specific columns do I need to include to correctly specify the time period? I followed the documentation at https://docs.oracle.com/en/cloud/saas/analytics/25r3/fawag/add-fact.html.

Also , i am not clear on the aggregation rule i need to specify for each fact column. Could anyone please advise on this?

The documentation says the below but

1. Select the aggregation rule for each fact column to set the aggregation behaviour. You can set the time-balanced aggregation rule for a time dimension and hierarchy level-based aggregation rule for a dimension using these steps:
   1. For a fact column, click the Time-Balanced Aggregation icon.
   2. In the Time-Balanced Aggregation dialog, click Add Time Dimension, adjust the aggregation rule, and then click OK.
   3. For a fact column, click the Hierarchy Level-Based Aggregation icon, select the dimension and level. Click Add Dimension to add more dimensions. Click OK.

Thanks,

Veena