--- Grid ---

edited 1:26PM in FastCube
Hi


1) selecting a prameter to be displayed (compare attached image. please)

I would like to select individual parameters:

'VALUE' or 'P_VALUE' or 'BACKGROUND_VALUE'

to be displayed within the grid. Not interactively, but controlled
by a routine: Values only or P_VALUES only or

2) how to determine, the number of data columns and data rows
of a grid ?


Any ideas ???

Thanx a lot and Greetings, MZ

Comments

  • edited January 2013
    Hi.

    1.
    Working with measure:
    //<ex_HideMeasureAmount
      procedure ex_HideMeasureAmount;
      var AIndex: integer;
      begin
        AIndex := fcSlice.FieldsOfRegion(rf_CapFacts).IndexOf('Measure_1');
        if AIndex >= 0 then
        begin
          fcSlice.CapFactsFieldsAbs[AIndex].VisibleInData := False;
        end
      end;
    //ex_HideMeasureAmount>
    //<ex_ShowAllMeasures
      procedure ex_ShowAllMeasures;
      var i: integer;
      begin
        for i := 0 to fcSlice.FieldsOfRegion(rf_CapFacts).Count - 1 do
          fcSlice.CapFactsFieldsAbs[i].VisibleInData := True;
      end;
    //ex_ShowAllMeasures>
    //<ex_AddMeasureCountOfUniqueProducts
      procedure ex_AddMeasureCountOfUniqueProducts;
      begin
        fcSlice.AddFieldTo('CountOfUniqueProducts', 'Product', 'Type Products Count', rf_CapFacts, af_CountOfUnique);
      end;
    //ex_AddMeasureCountOfUniqueProducts>
    

    Imortant: fcSlice.FieldsOfRegion(rf_CapFacts).IndexOf - used Name of measure! Not Caption!

    2.
    column count:
    Slice.XAxisVisibleItemCount
    row count:
    Slice.YAxisVisibleItemCount

    Best regards,
    Oleg Pryalkov.

Leave a Comment