COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: raro on 27 May 2008 06:25:54 AM

Title: how to sort elements in query subject
Post by: raro on 27 May 2008 06:25:54 AM
I suppose that sorting elements in a query subject should most probably be in alphabetical order (exceptions accepted).

Question:
How do you sort elements in a query subject in alphabetical order having more than one language supported for your query subjects?

Example:
Lets say your FM-modelling language is english. You sort all your QuerySubject elements in english. Then you translate  your query subject elements into spanish. How do you give the spanish user a sorted QuerySubject with their spanish elements?

e.g.

Turnover QS
-- Company
-- Country
-- Town
-- Partner
-- Turnover

in spanish it would be

Ventas QS
-- Compania
-- Pais
-- Ciudad
-- Partner
-- Venta

The spanish order should be:
Ventas QS
-- Ciudad
-- Compania
-- Pais
-- Partner
-- Venta

How do you change the spanish order wihtout changeing the english and visaversa?

Title: Re: how to sort elements in query subject
Post by: raro on 17 Jun 2008 11:08:29 AM
hmmm .. nobody here with more than one language in QuerySubjects?
Title: Re: how to sort elements in query subject
Post by: Darek on 17 Jun 2008 11:09:56 AM
I don't think you can. The order of Query Items is Static. Only if you used SDK the come up with a UI replacement for Cognos 8, you could do things like that.