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