Report at Material level(for all the plants)?

[Former Member]

Hi Experts,

We have simple query which gives following output.

&Plant&Material No&Creation Date&Issue date&QTY issued&

P1 M1 01/10/2004 01/01/2005 10

P2 M1 01/12/2004 15/12/2004 20

P3 M1 01/01/2005 15/01/2005 30

Actually I want to report at material level ( for all plants in one shot ) , additionaly I want to show the minimum creation date for that material and minimum issue date and sum of all 3 qty issued.

The output should look like

&Material No&Creation Date&Issue date&QTY issued

M1 01/10/2004 15/12/2004 60

Can any body suggest how do i get the date fields with the above condition

Thanks in advance.

Regs,

Mahantesh

[Former Member]

Hi,

Any hints/thought?...

Regs,

Mahantesh

[Former Member]

Hi Mahantesh ,

Try this:

Take two more KFs in the cube.

1) Creation Date as KF

Type: Date

Exception aggregation : First value

Aggregation reference : 0material.

2) Issue Date as KF

Type: Date

Exception aggregation : Last value

Aggregation reference : 0material.

In the query take 0material in rows and above 2 KF in the columns (May be , here , you need restriction also. 'Creation Date as Characterstic' > 01.01.1000 ,Issue Date as characterstic' < 31.12.9999 )

With rgds,

Anil Kumar Sharma .P

[Former Member]

Thanks Anil. rewarded points for suggestions/

Mahantesh