Skip to Content
0
Former Member
Jan 11, 2007 at 02:34 AM

Query on multicube

35 Views

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