sorting not retained on drill down -cognos 8

[cognos05]

Sorting is not maintained on drill down in cognos 8.
Dimensional Package is used
Expression used in the query : Order(shipToReps,(tuple(currentMember(shiptocustomer Hierarchy),[Product],[Growth%],[Measure]),Desc).

Is there any issue in the above expression. It doesnt sort descending on growth % column on drill down.

Thanks,
Nithya

[MFGF]

Sorting is not maintained on drill down in cognos 8.
Dimensional Package is used
Expression used in the query : Order(shipToReps,(tuple(currentMember(shiptocustomer Hierarchy),[Product],[Growth%],[Measure]),Desc).

Is there any issue in the above expression. It doesnt sort descending on growth % column on drill down.

Thanks,
Nithya

Hi,

You would expect that to happen - when you drill down you effectively replace the expression with a new one - children(<selected member>)

Cheers!

MF,

[cognos05]

Hi All,
I dont see any replace expression option to be set in cognos 8. If I choose change expression then it asks for a data item to be chosen.

So what would be my expression be.will it be like
order(children(shiptoReps),(tuple(currentMember(shiptocustomer Hierarchy),[Product],[Growth%],[Measure],Desc)

Thanks,
Nithya

[MFGF]

Hi All,
I dont see any replace expression option to be set in cognos 8. If I choose change expression then it asks for a data item to be chosen.

So what would be my expression be.will it be like
order(children(shiptoReps),(tuple(currentMember(shiptocustomer Hierarchy),[Product],[Growth%],[Measure],Desc)

Thanks,
Nithya

What do you see in Data > Drill Behavior > Advanced? The default is "Replace expression" if memory serves?

MF.

[cognos05]

I see Replace Expression but there is no option to enter the replace expression.

Thanks,
Nithya

[cognos05]

If I set the replace expression it doesnt sort it.

[MFGF]

I see Replace Expression but there is no option to enter the replace expression.

Thanks,
Nithya

That's exactly my point. The default behaviour when you drill down is that your expression is replaced by a new generated expression, which is children(<the member you drilled down on>)

This is why your sort is not preserved, and it's exactly what I would expect (as I said originally). This isn't a solution to your problem, I'm just explaining to you why it is behaving the way it does.

You could try setting the behaviour on drilldown to "Change Expression" and select another predefined expression in your query that orders the members at the next level down? I'm unsure whether you would end up seeing all the members or just the children, though. I can't check at the moment - you're going to have to try this and see how far you get.

Cheers!

MF.

[cognos05]

Hi All,
I had two elements nested in my row.

Say A and B which comes from same hierarchy.

Now on drilldown of B , I should show the C for which sorting is to be maintained.

Expression on item B : Order(Level,tuple(currentMember(Hierarchy),[Shoulder Implants],[Growth%],[Measure])),Desc)

So for change Expression I create a data item and assign its expression as  :Order(children(B),tuple(currentMember(Hierarchy),[Shoulder Implants],[Growth%],[Measure])),Desc)

I am getting this error :The "orderSet" node is not expected to be a "set".

Thanks,
Nithya

[cognos05]

Hi All,

What should be the expression for the data item which would be called on a change expression property in drill down.

My actual items expression is Order(Level,tuple(currentMember(Hierarchy),[Shoulder Implants],[Growth%],[Measure])),Desc).

Thanks,
Nithya