If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

How do you sort month name in framework manager?

Started by robblob, 07 Aug 2017 09:04:27 AM

Previous topic - Next topic

robblob

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?

MFGF

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.
Meep!

robblob

My model is built from a dimensional database.  The date dimensions have already been created. 

MFGF

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.
Meep!

robblob

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? 


robblob

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.