Print Page - Sorting Query Item in FM

Title: Sorting Query Item in FM - Data in DESC order
Post by: Brandimore on 04 Dec 2012 09:15:04 PM

Hi Folks

I have a relational model. I have a DateTime field in which I'd like to pre-sort to be in Descending order in FM.

The reason: The data is being used in sort of a unique manner. When the users use this dateTime field and they filter on it in the report, they will only choose 1 date. Hence, a date range prompt for them in QUERY studio (they don't use RS) doesn't make sense as it gives the illusion that it's to be used. So I changed the Prompt info to be 'Select Value' in the model.

So far that works fine. They select a single date.

The enhancement: They would like the latest date to be at the top of the list when they go to filter. I was hoping there'd be an FM option to easily do this, but that's not the case.

But maybe someone can confirm?

Thanks!

Title: Re: Sorting Query Item in FM - Data in DESC order
Post by: adik on 19 Feb 2013 09:29:17 AM

you can sort only when building a DMR, on strictly relational models you cannot sort.
wouldn't sorting from RS be an option?

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: Brandimore on 04 Dec 2012 09:15:04 PM