--- Grid ---

edited 12:33PM 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

Rich Text Editor. To edit a paragraph's style, hit tab to get to the paragraph menu. From there you will be able to pick one style. Nothing defaults to paragraph. An inline formatting menu will show up when you select text. Hit tab to get into that menu. Some elements, such as rich link embeds, images, loading indicators, and error messages may get inserted into the editor. You may navigate to these using the arrow keys inside of the editor and delete them with the delete or backspace key.