Forum Discussion
Resident RockstarFiltering by a date table in a composite model
Hello Everyone!
I'm working on building the model for a report to combine 3 data sources. One of the sources is from Azure Analysis Services so I have to create a composite model to bring in the others.
The model below I have the date table (from AAS) related using the same date field to 3 tables. The filtering works fine for GA_TagInfo but does nothing for SF_Inquiry and SF_User_Fact. GA_TagInfo is using the event_dt column which is just the date for an event and the others use CreatedDate. Any help or ideas on this is greatly appreciated as I'm stumped!
That was my thought too. I also got caught up with the red herring of it being a composite model...
The issue was the CreatedDate fields were actually date/time formatted to just show date. Once I removed the time - everything worked as expected.
2 Replies
mahenkj2Solution Sage
You have 1 to many relationship from date table to other fact tables, and if all fields used in relationship are date fields it should simply work.
Certainly you also need to confirm if matching data is available in the fact table for filtered dates. and we do not know how you are using the visuals. if there are other visuals on canvas, and as we see you have some other relationships, so if there is any cross filtering going on?
- Syk
That was my thought too. I also got caught up with the red herring of it being a composite model...
The issue was the CreatedDate fields were actually date/time formatted to just show date. Once I removed the time - everything worked as expected.