Skip to Content
avatar image
Former Member

Query Output Format

Gurus,

Need your advice on how to achieve the following output on the Query:

................................Period 1..........Period 2.........Period 3

...............................Plan : Actual...Plan : Actual...Plan : Actual

Cost Center 115960...100....90........120.....130..........150.....160

Basically the report will show the Plan and Actual cost posted to the particular cost centre. We have total 12 Period (12 months), so 12 column on the output. Under each Period, I would like to sub-divide into 2 column u2013 for Plan and Actual cost.

Is this doable?

Please advice, thanks.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Sep 03, 2008 at 06:49 AM

    It can be done in a workbook, do seperate columns for plan and actual by period and merge the period cells to get this.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 03, 2008 at 07:14 AM

    If plan and actual are not different KF, create two restricted KF, one for actual and one for plan and put them in columns. Above the KF structure put the Period char and in lines the cost center char.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 03, 2008 at 08:36 AM

    Use 2 Strcutres in the columns in QueryDesigner.

    Can only be done, if the rows are not organized as Strcuture as you can use only 2 Structures in one query...!

    This is the best way in my opinion!

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Pavel Afanasiev

      Hi Pavel,

      I have decided to follow your second option:

      The other way of doing this is actually creating a column for each Period/KF combination. You would create a structure and then create new selections with:

      1. Period 1/KF Actuals

      2. Period 1/KF Plan

      3. Period 2/KF Actuals

      4. Period 2/KF Plans

      ... and so forth

      However, I have the following output on the Row:

      ................................Actual 1...Plan 1

      ...............................USD....... USD

      Cost Center 115960...100....90

      Acutal 1 is the New Selection created with Period 1/KF Actuals.

      Plant 1 is the New Selection created with Period 1/KF Plan.

      I donu2019t understand where is the USD coming from? I didnu2019t enter it in the Column.

      How to remove the Currency from here?

      How to include and display the Period on top on the New Selections?

      What I try to achieve is the following format:

      ................................Period 1..........Period 2.........Period 3

      ...............................Plan : Actual...Plan : Actual...Plan : Actual

      Cost Center 115960...100....90

      Please advice, thank you!

  • avatar image
    Former Member
    Sep 25, 2008 at 01:08 AM

    good info

    Add comment
    10|10000 characters needed characters exceeded