Hi,
I would like to download to a file the execution of a Query. I thought in APD, but I am facing an issue.
The layout of the query is the following (and as I expect to be in the flat file):
KF 1 KF 1 KF 1 KF 2 KF 2 KF 2 Calendar day 01/02/2011 02/02/2011 03/02/2011 01/02/2011 02/02/2011 03/02/2011 Customer group Material A1 000000000030193470 10 12 14 16 18 20 A1 000000000030193473 12 15 18 21 24 27
But the layout of the file is:
Customer group Material Calendar day KF 1 KF 2 A1 000000000030193470 01/02/2011 10 12 A1 000000000030193470 02/02/2011 12 15 A1 000000000030193470 03/02/2011 14 18 A1 000000000030193473 01/02/2011 16 21 A1 000000000030193473 02/02/2011 18 24 A1 000000000030193473 03/02/2011 20 27
My query has in Row 2 Characteristics and in Columns 2 KF and one characteristic. Is there any problem?
Regards, Federico