3 Replies Latest reply: Dec 7, 2014 8:01 PM by Leow J RSS

    How to use qlikview functions on SAP Bex Query

      Hi,

       

      In qlikview, we have the LOAD syntax and SELECT syntax to fetch data from our datasource in Non-SAP environment.

       

      Currently i'm connected to SAP bex query in qlikview and failed to apply qlikview functions like (YEAR(), MONTHY()) on my bex dimensions. My script are as follows:

       

      Load

      year([20CALDAY]) as [year dim],               //dimension columns

      month([20CALDAY]) as [month dim],

      [00O2TNO3P2EU3ZS6XG1FKXRS7].[00O2Tdffd3ZS6XG1FKYAQV]    as [measure 1]      //measures columns

      ;

       

       

      Select PseudoMDX D (

      Dimensions (

        [0HC_TREATMC] ([10HC_TREATMC], [20HC_TREATMC], [50HC_TREATMC]),

        [0CALDAY] ([20CALDAY])), 

      Measures (

        [00O2TNO3P2EU3ZS6XG1FKXRS7].[00O2Tdffd3ZS6XG1FKYAQV],

        [00O2TNO3P2EU3ZS6XG1FKXRS7].[00O2TNO3P2Eeexs0ELJ]),

      From (table));

       

       

      Please let me know how can i use qlikview functions on sap dimensions and measures in the LOAD syntax, thanks.