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
Quote from: nithya1224 on 05 Aug 2014 04:16:51 PM
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,
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
Quote from: nithya1224 on 06 Aug 2014 08:06:10 AM
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.
I see Replace Expression but there is no option to enter the replace expression.
Thanks,
Nithya
If I set the replace expression it doesnt sort it.
Quote from: nithya1224 on 06 Aug 2014 08:16:03 AM
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.
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
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