Sort on hidden field

Otzi

Row fields are sorted by value like text. I would like to change this sort order to some hidden number field but don't know how to do this.

-=Oleg=-

Hi.

Use in TfcCube before open cube:
// base fields feature
procedure SetBaseField(AField, ABaseField: String);
function HaveBaseField(AField: String): Boolean;
procedure ClearBaseFields;

For example:
Field1 - string field (to display)
Field2 - numeric field (to sort)
You need:
fcCube.SetBaseField('Field1', 'Field2');

Oleg Pryalkov

Otzi

Is it possible to add this feature to user interface as field property?
Beacuse I create cube dynamically from different datasets.

-=Oleg=-

You can set Base Field only before loading data.
Use event TfcCube.BeforeOpen to show your dialog to select and set needed fields.