As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at firstname.lastname@example.org and provide your corporate email address, company, and name.
You can have month level and week level but you must ensure that your "months" will roll up isomorphically to weeks and weeks back to months. Months can begin in the middle of a week. Weeks can start and cross months. You want to make those rollups work properly - otherwise things won't add up. So when building your Time Dimension your months have to be looser.
Example. July 2009 started on a Wednesday and ends on a Friday. That means there are two partial weeks in Jul - the first and the last. You can define (with a Sun-Sat week) that July begins on the a real calendar date of either June 28 or July 5 for example. You might then have July be 5 weeks starting June 28 and ending August 1.
You can of course design your calendar however you want.
Hope that makes sense.
Bob Jude Ferrante Director of Business and Development WebFOCUS Performance Management Bob_Ferrante@ibi.com 917-339-5105
I'll take any questions about PMF - business or technical - anytime!
Yes, you can have records representing the month or even the year level in your source data. I recommend you use spaces instead of "NA". NA will display in the Preview but it may not work with reports.
Otherwise, looking at your data, it appears that your week 1 of 2009 starts on Jan 4th. So the question is what will happen when you run a report on Jan 1st through Jan 3rd and specify the Current Time Period? I've never tried this, but my best guess is that for weekly data you will see the last week of 2008 while for monthly data you will see Month 01. This may or may not be what want you want to see.