Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi.
Happy new year to all of you and thank you for the community
So, at new year, new strange issue.
I give you below the screenshot of one of my application that give me a strange thing concerning the calendar.
As you can see, I have the first row which is the year of documents on which I do the accounting in the pivot (just a count function), second row is the week, and third is the delivery date.
So basically, at the end of year 2012, is logical to have week 52 and 1 appearing as we have deliveries on both weeks.
But it is not logical there because if we refer to the year, we should normally have 2013 for the week 1 The two fields are in the load script : [Entete Année] = Year([Entete Date]) and [Entete semaine] = week([Entete Date]) where [Enete Date] is the date of documents stored in the DB.
Any idea ?
So, finally, the weekyear function gives the good information if I use a calculated dimension for the year instead of the one loaded in the script. If I use month as dimension, we have a week 1 within december. It's weird but logical.
You should probably use the WeekYear function instead of the Year function for the Entete Année field.
Thank you Gysbert. in the time you were answering, I had a look at it, and it seems that I should comme from that mistake. I'll confirm later as soon as I have verified.
So, finally, the weekyear function gives the good information if I use a calculated dimension for the year instead of the one loaded in the script. If I use month as dimension, we have a week 1 within december. It's weird but logical.