COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: ittimes on 06 Mar 2018 09:14:48 AM

Title: cognos notes
Post by: ittimes on 06 Mar 2018 09:14:48 AM
chart sort issue---

you want to sort a chart x , and create a new item for sort purpose , like 'minimum([Presentation Layer].[Alt7].[COL_27]  for [week of year])', so different period has the same minimum week data , you can sort by it, however you have to set the aggragation property to None for both of them.

_week_of_year (

cast([Presentation Layer].[Alternative7].[COLUMN_27] as date)

)

Title: Re: cognos notes
Post by: ittimes on 07 Mar 2018 10:41:32 AM
2:-- one parameter can be used by multiple value prompt.
so you give user the ability to multiple select measures from different locations