Skip to Content
author's profile photo Former Member
0
Former Member

Query on multicube

Posted on Jan 11, 2007 at 02:34 AM 18 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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jan 11, 2007 at 03:36 AM
    1

    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
    10|10000 characters needed characters exceeded

    Comment on This Answer

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.