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

Question about how solve a problem using MDX in a universe

Hi All,

We are currently in BO 3.1 SP2 with BW 7.0.

There are two cubes in the BW model, one for header details and the other for line items. They both have the following design:

Header Cube

Orders Order Quantity

10001 2

10002 1

Line Item Cube

Orders Line Item Brand Group Brand Material Order Quantity

10001 1 Brand Group a Brand1 M1001 1

10001 2 Brand Group a Brand1 M1002 1

10001 3 Brand Group a Brand2 M1003 1

10001 4 Brand Group b Brand3 M1004 1

10002 1 Brand Group a Brand1 M1001 1

10002 2 Brand Group a Brand1 M1002 1

10002 3 Brand Group a Brand2 M1003 1

10002 4 Brand Group b Brand4 M1005 1

In Webi, we need to analyze the KPI named Order Quantity by different dimensions.

1. Order Quantity without a dimension of analysis

Order Quantity

2

2. Order Quantity by Brand Group

Brand Group Order Quantity

Brand Group a 2

Brand Group b 2

Total 4

3. Order Quantity by Brand

Brand Order Quantity

Brand1 2

Brand2 2

Brand3 1

Brand4 1

Total 6

What we want to avoid strictly because of Information Volume matters, is to take all the data to the webi report and carry out a COUNT using formulas.

Could we obtain the "Count Different Orders" indicator aggregated by the different dimensions of analysis using MDX. Is this accurate and feasible?

Kind regards,

Edited by: Federico Sperling on Sep 9, 2009 5:46 PM

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Sep 09, 2009 at 05:24 PM

    Hi,

    what is the exact concern here ?

    You might want to think about switching the measure to be a "database delegated" measure. You should be able to have a single WebI report showing all the aggregated numbers / views

    Ingo

    Add a comment
    10|10000 characters needed characters exceeded

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.