Hello BWers,
I created a query based on a multicube which joins two infocubes.
These two infocubes have got the fields, the same records, all is the same except the characteristic Z_HIS (char 6).
In the first infocube Z_HIS = '000000' for all records.
In the second one Z_HIS = '200712' for all records (but it could be equal to 200801, 200802, ... except 000000)
In the multicube, all characteristics and key figures are boxed and are considered coming from the two infocubes.
When i'm looking records in the multicube in BW, records are good.
For example :
id - infoprovider - z_his -- field1- field2.....
i1 -C1 - 000000 - A - xq ........
i1 -C2 - 2000712 - A - xq .........
But when i'm looking records in my simple query, z_his is equal to '200712' for all records (for C1 and C2).
I hope you could tell me how to resolve this problem and have in the query for one record two lines with one with the field z_his = 2000712 for infoprovider C2 and the other one with z_his = 000000.
Points will be assigned,
Cheers,
Vince.