Please, if possibly to put a a screemshoot of sample data and the configurartion of your time dimension?
1. Check if you time dimension, have a composite key, maybe data level produces some the issue to aggregate data at TO_DATE (time series function)
2. Check if your metric has level configuration.
Please check the below screenshots of sample data at differnet levels.
Year level is curect
Quarter level is currect
Month level is currect
week level is showing wrong
Finally date level is currect.
Time dimension layout.
in my fact table I have units for each date wise.
I have calculated "Units YTD" by using below formula.
ToDate("Core"."Fact_DWASV_WKLY_REVENUE"."UNITS" , "Core"."Dim_DW_DATEDim"."Year" )
Please let me provide any solution.
Thanks in advance.
1 person found this helpful
"1" isn't a very good choice for a key since it isn't unique. What's happening is a rollup of ALL week 1's across all time.
You need properly unique keys like "Wk1-2015" or something like that.
You are currect. At week level key is not unique so I concatenated "Month/year" and "week no" and used at week level as a chronological key.
Now am getting.
Thanks for support.