I am facing issue in cognos powerpaly transformer cubes.
The last day of the year getting in the first week of the same year.I am using Sunday is my week first day and Saturday is my week last day.but i need to populate last day of the year like 53 rd week or first week of the next year.
example 2012/12/31 is populating in the first week of 2012.
My source is IQD from cognos 8 and week is a calculation like week_of_year(date)
I was checked all the options in model,but i could not find any solution.
could you please help.
Many thanks in advance