I have a small question on creating a query in BW for a multicube and I hope you could help me to solve my problem.
Cube1 (consists of 2 infosources data)
=====
1. Sales Order NO
2. Sales Doc Type
3. Gross Price
Cube2 (consist if 2 infosources data)
=====
1. Sales Order No
2. Billing Doc No
Query from my multicube should display
1. Sales Order No - cube2
2. Sales Doc Type - cube1
3. Billing Doc No - cube2
4. Gross Price - cube1 or cube2
How could I solve my problem as when i run the query, it is displaying '#' for the sales doc type..e.g
1. 100001 ZOR # 0.70
2. 100001 # 200001 0.70
suppose to display
1. 10001 ZOR 200001 070
Hope you can help me start from the creation of the multicube till the generation of the query.
Thank You in advance
Hi Harris,
To make the two different rows of different different cube into one row of multiprovider require correct identifiction.Also Multicube has certain limitations which needs to be consider while designing.
So Here are the steps for making your report work fine.
1) Just make sure that the characteristics which are in rows of the report should have identifiction from both the cube.
That is it should be present in the both the cubes or it will bring two rows one with the value for that characteristic from one of the cube and other one without value from other cube which is what is happening in you case.
2) Try to bring the sales documnet type from both the cube or remove it from the row it will solve the issue.
3) Try to bring sales documnet type from both the cube. Because a sales documnet type is a property of sales document and it no where related to billing document that's why it cannot be brought in one row with billing document and this is the only issues you have.
4)You can try to put sales document in the other cube as well and bring it in the multiprovider it will solve the issue.
It will help
Thanks
Add a comment