Hi, I have a Dimension in a DMR project. This Dim has 3 levels, and I don't wanna sort the 2nd level. I want that the 2nd level respect the database's order, but Cognos 10.2.1 is always sorting in ascendent order all levels.
I tried to configure the sort member folder on Dimension in many different ways, but no one had result.
Can anyone help me?
Hi,
The database doesn't have an inherent order - depending how the db query optimiser rewrites various queries, the data may come back in different order each time. In DMR you either define a sort order for the dimension or you don't - there is no "mixed" option where you can define sort order for some levels but not others.
Cheers!
MF.
In fact I don't wanna set any order in any level. I just wanna that the report shows each level respecting the database's order. But Cognos allways is sorting the data.
Hi,
If you don't specify sorting on the "Members Sort" tab, Cognos will not do any inherent sorting when querying data (ie there will be no "order by" clause(s) generated). However, as I mentioned before, there is no inherent "database order" of the data. Depending how a query is written to access the data, it may (or may not) use an index which might result in ordering as the data is retrieved. This is not Cognos sorting the data - it is a facet of how the database's query optimiser is utilising db structures to retrieve the data.
Cheers!
MF.