7 Replies Latest reply: May 13, 2014 7:40 AM by FRANCISCO ROGERIO ALMEIDA DOS SANTOS RSS

    Set Analysis

    FRANCISCO ROGERIO ALMEIDA DOS SANTOS

      Good morning all,

      I have a problem in Sept analysis, I would like some help to improve the performance of the same, I have several expressions within my analysis would like an opinion to improve this analysis.

      I am currently performing the operations necessary in my analysis directly in the script, and using only 2 fields in the front end, someone has to know a little better this performance?

      Before was thus the expression

      sum ({<CLASSIF_CLI_FAT_DRE = {'test'}, CONTRATO_NOVO = {'test'}

      -

      sum ({<CLASSIF_CLI_FAT_DRE = {'test'}, {CODIGO_PRODUTO_FAT_DRE = 'test', 'test'}

      Now the expression is so because the calculation is being done in the script

      sum ({<line {'LINHA10'}, EXPRESSION =} = {'EXPRESSAO1'}> VALUE)

      -

      sum ({<line {'LINHA10'}, EXPRESSION =} = {'EXPRESSAO2'}> VALUE)

        • Re: Set Analysis
          Gysbert Wassenaar

          Set analysis can't be used in the script. You will have to use if statements instead. I have no idea what you're actually trying to sum. The statements you posted make no sense to me.

            • Re: Set Analysis
              FRANCISCO ROGERIO ALMEIDA DOS SANTOS

              I'll try to improve my question .
              Before was thus the sum expression
              ( { < CLASSIF_CLI_FAT_DRE = { 'test' } , CONTRATO_NOVO = { 'test' }
              - Sum ( { < CLASSIF_CLI_FAT_DRE = { 'test' } , { CODIGO_PRODUTO_FAT_DRE = 'test' , 'test' }

              Script is loaded in the next row.

              / / Linha10
              / / EXPRESSA01
              / / ( { < CLASSIF_CLI_FAT_DRE = { 'test' } , CONTRATO_NOVO = { 'test' } +

              Concatenate

              LOAD
              ' LINHA10 ' AS LINHA,
              ' EXPRESSAO1' AS ESPRESSAO , CHAVE_OCC_LANC ,
              CODIGO_EMPRESA_ THE COMPANY
              CENTRO_CUSTO_LANCAMENTO THE CENTER ,
              TIPO_CCUSTO_CONTABIL AS TYPE ,
              ANO_CONTABIL AS ANO_DRE ,
              MES_CONTABIL AS MES_DRE ,
              VALOR_LANCAMENTO AS VALUE ,
              CLASSIFICATION AS CLASSIFICACAO_DRE
              RESIDENT LANCAMENTO_CONTABIL
              WHERE
              CLASSIF_CLI_FAT_DRE = 'test' , CONTRATO_NOVO = 'test' ;

              / / Linha10
              / / EXPRESSA02
              / / Sum ( { < CLASSIF_CLI_FAT_DRE = { 'test' } , { CODIGO_PRODUTO_FAT_DRE = 'test' , 'test' }

              Concatenate

              LOAD
              ' LINHA10 ' AS LINHA,
              ' EXPRESSAO2 ' AS EXPRESSAO , CHAVE_OCC_LANC ,
              CODIGO_EMPRESA_ THE COMPANY
              CENTRO_CUSTO_LANCAMENTO THE CENTER ,
              TIPO_CCUSTO_CONTABIL AS TYPE ,
              ANO_CONTABIL AS ANO_DRE ,
              MES_CONTABIL AS MES_DRE ,
              VALOR_LANCAMENTO AS VALUE ,
              CLASSIFICATION AS CLASSIFICACAO_DRE
              RESIDENT LANCAMENTO_CONTABIL
              WHERE
              CLASSIF_CLI_FAT_DRE = 'test' and match ( CODIGO_PRODUTO_FAT_DRE , 'test' , 'test' )

              So on the front end I'm using the following .


              sum ( { <line {'LINHA10'}, EXPRESSION = } = {'EXPRESSAO1'}> VALUE )
              -
              sum ( { <line {'LINHA10'}, EXPRESSION = } = {'EXPRESSAO2'}> VALUE )


                

              But there are not only these two expressions on the front end there are over 100.


              I hope you understand

            • Re: Set Analysis
              Dariusz Mielczarek

              Rogerio,

               

              maybe it is good idea to attache sample application with your case.

               

              regards

              Daerk