If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Avoiding Default Sort on Page break column.

Started by Mpotla, 05 Sep 2012 10:02:30 PM

Previous topic - Next topic

Mpotla

Hi Folks,

I am creating List report using DMR package published using TM1 Cube. I have Tree prompt defined on Dimension called 'Region' with select . User can select values from any level.

In the List Query ,Instead of adding one detail filter ,I have created one data item with below expression.which is acting as prompt filter.

Caption(Set(Region.Region.RegionName ->?Param_Rgn?)). I have defined Page break on this Data item created.

When i defined the page break,Its taking default sort order on this Data item and creating the Page break, But my users want to see page break in other which they selected the values in the prompt.

The value of the data item containts values like CANADA(CAD), EUROPE(EUR). To remove the codes from this item i have used Substring(),position() and captured the string till '(' position. and i have used this calculated data item to define the page break .

Any help is appreciated.
Thanks,

Mc