I'm having a heck of a time sorting by month in framework manager. I've dug around to see how to fix this, but it doesn't seem like there is a very good solution to accomplish this basic task based on what I was able to find. The month field wants to sort in ascending order, which it does, alphabetically of course. I know there is a way to perform a custom sort in a data module, but apparently you can't do so directly from a package (unless I'm doing something wrong).
Is there a way to perform the sort in the framework model so it's not left to someone in Cognos Analytics to define it there? I was people to pull directly from the package to their dashboards and reports and have month sort properly. This appears to be a HUGE oversight by IBM.
I have multiple data items available in my time dimension. Date month, date month num, first day of month, last day of month, year, etc. All I would like to do is apply a custom sort to my Date Month by Date Month Num. Is this possible?
Quote from: robblob on 07 Aug 2017 09:04:27 AM
I'm having a heck of a time sorting by month in framework manager. I've dug around to see how to fix this, but it doesn't seem like there is a very good solution to accomplish this basic task based on what I was able to find. The month field wants to sort in ascending order, which it does, alphabetically of course. I know there is a way to perform a custom sort in a data module, but apparently you can't do so directly from a package (unless I'm doing something wrong).
Is there a way to perform the sort in the framework model so it's not left to someone in Cognos Analytics to define it there? I was people to pull directly from the package to their dashboards and reports and have month sort properly. This appears to be a HUGE oversight by IBM.
I have multiple data items available in my time dimension. Date month, date month num, first day of month, last day of month, year, etc. All I would like to do is apply a custom sort to my Date Month by Date Month Num. Is this possible?
Hi,
Have you built DMR Regular Dimensions in your model? These give you the ability to pre-define member sort options, including sorting by a different attribute than the caption (eg the month number).
Cheers!
MF.
My model is built from a dimensional database. The date dimensions have already been created.
Quote from: robblob on 07 Aug 2017 09:39:09 AM
My model is built from a dimensional database. The date dimensions have already been created.
Hi,
I'm not referring to table structures. I'm talking about defining Regular Dimensions in your FM model (in your case, one corresponding to each dimension in your dimensional database).
MF.
MF,
Pardon my ignorance, as I'm fairly new to framework manager, but are you suggesting I build dimensions on top of a dimensional database?
Pretty sure I'm on the right track now. I had to create a new namespace and built a date dimension with a hierarchy based on the desired date field. Once the hierarchy was complete, I used the month_num of the year as my sort, which appears to have resolved the issue I was having before.