How to achieve Accumulated Column

    This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

    • How to achieve Accumulated Column

      Hi

      Please refer the attached Text file . I have the requirement to achieve the Output column. The Output column is an accumulation KPI_VALUE for month
      grouping by column CY_FY_INDICATOR and Year. For example for May the Output value is Apr+May of KPI_Value and in the same way for June output value will be Apr+May+Jun of KPI_PERIOD.

      KPI_CODE KPI_NAME GROUP_CODE DIVISION_CODE CY_FY_INDICATOR KPI_YEAR KPI_PERIOD KPI_VALUE Output
      46 NL LBN ACGNL FY 2008 Apr 33091 33091
      46 NL LBN ACGNL FY 2008 May 29685 62776
      46 NL LBN ACGNL FY 2008 Jun 31042 93818
      46 NL LBN ACGNL FY 2008 Jul 32807 126625
      46 NL LBN ACGNL FY 2008 Aug 32782 159407
      46 NL LBN ACGNL FY 2008 Sep 34952 194359
      46 NL LBN ACGNL FY 2008 Oct 32448 226807
      46 NL LBN ACGNL FY 2008 Nov 31515 258322
      46 NL LBN ACGNL FY 2008 Dec 24639 282961
      46 NL LBN ACGNL FY 2009 Jan 25155 308116
      46 NL LBN ACGNL FY 2009 Feb 31320 339436
      46 NL LBN ACGNL FY 2009 Mar 33091 372527
      46 NL LBN ACGNL CY 2009 Jan 25155 25155
      46 NL LBN ACGNL CY 2009 Feb 31320 56475
      46 NL LBN ACGNL CY 2009 Mar 33091 89566
      46 NL LBN ACGNL CY 2008 Apr 33091 122657
      46 NL LBN ACGNL CY 2008 May 29685 152342
      46 NL LBN ACGNL CY 2008 Jun 31042 183384
      46 NL LBN ACGNL CY 2008 Jul 32807 216191
      46 NL LBN ACGNL CY 2008 Aug 32782 248973
      46 NL LBN ACGNL CY 2008 Sep 34952 283925
      46 NL LBN ACGNL CY 2008 Oct 32448 316373
      46 NL LBN ACGNL CY 2008 Nov 31515 347888
      46 NL LBN ACGNL CY 2008 Dec 24639 372527




      How can I achieve the Output column using Jedox ETL Manager. What are the transformations I have to use to achieve it .


      Regards,
      MS.
    • Hi,

      you can probably achieve this easier if you go for Data-Driven Modelling. If you can use the ETL Manager, you should also be able to do that. The manuals cover some usefull material regarding this.

      Upload the raw KPIs into Jedox and then bring them in the desired order by using the modeller.

      I did this in October and from now on, I can simply add new numbers with a new dimension element (e.g. "November"). Either design the relation of the KPIs before uploading them or just build consolidation blocks.

      Best regards!
      Greetings from Germany, Frankfurt a.M.