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?

10|10000 characters needed characters exceeded

• 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.

10|10000 characters needed characters exceeded
• 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.

10|10000 characters needed characters exceeded
• 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!

10|10000 characters needed characters exceeded
• Former Member Pavel Afanasiev

Hi Pavel,

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

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

good info