I'm setting up an aggegated fact in my datamart, but when I get to the "Aggregated Fact", the OID that references the Date entity is not present. What am I missing? It is selected as the Date dim (I only have 1 date dim).
The Date_OID has appeared correct in another fact table (based on different entity).
Here I would like to aggregate on "Avdeling" and Date.
I think I figured it out. A bit of a non-intuitive behaviour in the datamart. The Date entity is created as a date dimension as expected. BUT it is connected to the date selected as the "transaction date" and NOT the selected "date dimension". Confusing if you have several date fields in the related entities.
The "date dimension" seems a bit unnecessary then, why not merge the two options?
@TK_ I am glad you are able to get it going. What version of Compose are you running?
I understand the confusion, but not sure if merging will result in the data discrepancy. I would suggest you open a case along with the diagnostic package. This way we can check with R&D/Project management to see if those can be merged.