1 Reply Latest reply: Nov 19, 2012 8:20 AM by l.weber0815 RSS

    Inputfield

      Hello community,

      I have a problem, with building Inputfields. The data come from a query. The Inputfields don´t work. What is missing?

       

      Inputfield

        [DDV6I3WIO4DV98RHK9W24JQX9].[DDV6I3WIO4FEMHF07CRA9EJGT], //Liefertreue Auftragsmenge WLD

        [DDV6I3WIO4DV98RHK9W24JQX9].[DDV6I3WIO4G6B3QRIW6WBTXQL], //Retourenquote

        [DDV6I3WIO4DV98RHK9W24JQX9].[DDV6I3WIO4EMXV38VTBO6Z571]; //Servicegrad Mengen

      [ZAUFMON/ZAUFKUZU]:

       

      Load *;

      Select PseudoMDX (

       

      Dimensions (

        [0DISTR_CHAN] (),

        [0DIVISION] (),

        [0MATERIAL] (),

        [0PLANT] (),

        [0SALESORG] (),

        [0SOLD_TO] (),

        [0CALMONTH] ()),

      Measures (

        [DDV6I3WIO4DV98RHK9W24JQX9].[DDV6K7POHGWTLJUCN989BEZNX], //KUZU>0?

        [DDV6I3WIO4DV98RHK9W24JQX9].[DDV6KISXJM0NIHI5DNX1TBTHP], //Kundenzufriedenheit

        [DDV6I3WIO4DV98RHK9W24JQX9].[DDV6I3WIO4GXZQ2IUFMIE9C0D], //Kundenzufriedenheit Menge

        [DDV6I3WIO4DV98RHK9W24JQX9].[DDV6I3WIO4FEMHF07CRA9EJGT], //Liefertreue Auftragsmenge WLD

        [DDV6I3WIO4DV98RHK9W24JQX9].[DDV6I3WIO4G6B3QRIW6WBTXQL], //Retourenquote

        [DDV6I3WIO4DV98RHK9W24JQX9].[DDV6I3WIO4EMXV38VTBO6Z571]), //Servicegrad Mengen

        • Re: Inputfield

          I tried something different:

           


          SET ThousandSep='.';

          SET DecimalSep=',';

          SET MoneyThousandSep='.';

          SET MoneyDecimalSep=',';

          SET MoneyFormat='#.##0,00 €;-#.##0,00 €';

          SET TimeFormat='hh:mm:ss';

          SET DateFormat='DD.MM.YYYY';

          SET TimestampFormat='DD.MM.YYYY hh:mm:ss[.fff]';

          SET MonthNames='Jan;Feb;Mrz;Apr;Mai;Jun;Jul;Aug;Sep;Okt;Nov;Dez';

          SET DayNames='Mo;Di;Mi;Do;Fr;Sa;So';

           

          CUSTOM CONNECT TO "Provider=QvSAPOLAPConnector.dll;ASHOST=;SYSNR=00;CLIENT=100;XUserId=;";

           

          Inputfield

            [Servicegrad Mengen2],

            RETOURENQUOTEIN,

            LIEFERTREUEIN;

           

          [ZAUFMON/ZAUFKUZU]:

          Load *;

          Select PseudoMDX (

           

          Dimensions (

            [0REQUID] (),

            [0DISTR_CHAN] (),

            [0DIVISION] (),

            [0MATERIAL] (),

            [0PLANT] (),

            [0SALESORG] (),

            [0SOLD_TO] (),

            [0CALMONTH] ()),

           

          Measures (

            [DDV6I3WIO4DV98RHK9W24JQX9].[DDV6K7POHGWTLJUCN989BEZNX], //KUZU>0?

            [DDV6I3WIO4DV98RHK9W24JQX9].[DDV6KISXJM0NIHI5DNX1TBTHP], //Kundenzufriedenheit

            [DDV6I3WIO4DV98RHK9W24JQX9].[DDV6I3WIO4GXZQ2IUFMIE9C0D], //Kundenzufriedenheit Menge

            [DDV6I3WIO4DV98RHK9W24JQX9].[DDV6I3WIO4FEMHF07CRA9EJGT], //Liefertreue Auftragsmenge WLD

            [DDV6I3WIO4DV98RHK9W24JQX9].[DDV6I3WIO4G6B3QRIW6WBTXQL], //Retourenquote

            [DDV6I3WIO4DV98RHK9W24JQX9].[DDV6I3WIO4EMXV38VTBO6Z571]) //Servicegrad Mengen

           

          Slices (

            [0CALMONTH].[201201],

            [0CALMONTH].[201202],

            [0CALMONTH].[201203],

            [0CALMONTH].[201204],

            [0CALMONTH].[201205],

            [0CALMONTH].[201206],

            [0CALMONTH].[201207],

            [0CALMONTH].[201208],

            [0CALMONTH].[201209],

            [0CALMONTH].[201210]),

          From (ZAUFMON/ZAUFKUZU));

          Store * from [ZAUFMON/ZAUFKUZU] into .\ZAUFMON_ZAUFKUZU.QVD;

           

          join load Distinct [Servicegrad Mengen] as [Servicegrad Mengen2] resident [ZAUFMON/ZAUFKUZU];

           

          Know it says:

          "Duplicate keys when loading Input Field"