Hi All,
I’m trying to fix an issue with dates and tried as much as I could but still not able to fix the issue. So I’m posting it here hoping someone will help me. As this is a data model issue it might take some time for you guys to help me with the issue so please help me in identifying the issue.
Basically, I’m trying to join a budget data table with another major “sales” fact table as I need to create a report with combination of fields from these 2 tables. As these 2 tables are not at the same granularity and neither of the tables have the date field that I need. I used 2 other calendar_dim and fiscal_dimension tables from same schema, joined these 2 tables got all the date related fields. Finally joined this date (Fiscal)table to main fact “sales” using the calendar_date_id.
Now the issue is when I create the report the data is not associated with the right time dimensions
Instead of 2016 Fiscal (2015 half and 2016 half calendar year) year, data is associated to 2014 Q3 which is not correct. So please can someone point me out what’s wrong with my code? Thank you,
I have attached the sample qvw and also the excel files with data.
Thank you,
Ramya
