Variable selection defaults?

[darryl_goveas3]

Hi experts,

I am trying to set the defaults displayed for values on a variable in a Bex report.

In Query designer, for the variable on the characteristic I went to the 'User Settings' button and under the 'Value restrictions' tab, 'No of displayed values' section tried both 'All Values' and later with '3500' in the 'Maximum number of values displayed'. In both cases, the Query still shows the default Maximum Records '1000' when we try to enter a value from the selection screen.

In addition to changing the default 'max # of records' displayed, I would also like to change the default sort order to be descending, but I don't see any place to do this?

Thanks!

Darryl

[Former Member]

Hi Darryl,

Any update on the sort order issue?

- Ajina

[darryl_goveas3]

Hi Ajina,

Sorry, I don't recall ever getting a final answer on that one.  It was a few years ago now, but I took a look at my old notes and our system and it appears we never applied a change to do this.

B.Rgds,

Darryl