US and Worldwide: +1 (866) 660-7555
Results 1 to 3 of 3

Thread: In My situation how to design the schema.xml

  1. #1
    Join Date
    May 2013
    Posts
    9

    Default In My situation how to design the schema.xml

    Sorry, I have no idea how to design schema.xml base my situation.

    I have three dimension table

    Account
    accountID AccountName
    A1 AAA
    B1 BBB
    C1 CCC

    Customer
    CustomerID CustomerName
    A2 AA2
    A3 AA3
    A4 AA4
    B2 BB2
    C2 CC2

    Product
    ProductID ProductName
    A Apple
    B Ball
    C Cat
    D Dog
    E Egg

    and Fact table
    accountID CustomerID Product QTY
    A1 A2 A 5
    A1 A3 C 3
    A1 A4 D 4
    B1 B2 C 10
    B1 B2 D 20
    B1 B2 A 33
    C1 C2 D 40

    Now I create a cube Composed of the dimensions' ID and fact table
    and the data show on the BI is that.

    accountID CustomerID Product QTY
    A1 A2 A 5
    A1 A2 B 0
    A1 A2 C 0
    A1 A2 D 0
    A1 A2 E 0
    A1 A3 A 0
    A1 A3 B 0
    A1 A3 C 2
    A1 A3 D 0
    A1 A3 E 0
    A1 A4 A 0
    A1 A4 B 0
    A1 A4 C 0
    A1 A4 D 4
    A1 A4 E 0
    A1 B2 A 0
    A1 B2 B 0
    A1 B2 C 0
    A1 B2 D 0
    A1 B2 E 0
    A1 C2 A 0
    A1 C2 B 0
    A1 C2 C 0
    A1 C2 D 0
    A1 C2 E 0
    B1 A2 A 0
    B1 A2 B 0
    B1 A2 C 0
    B1 A2 D 0
    B1 A2 E 0
    B1 A3 A 0
    B1 A3 B 0
    B1 A3 C 0
    B1 A3 D 0
    B1 A3 E 0
    B1 A4 A 0
    B1 A4 B 0
    B1 A4 C 0
    B1 A4 D 0
    B1 A4 E 0
    B1 B2 A 0
    B1 B2 B 0
    B1 B2 C 10
    B1 B2 D 20
    B1 B2 E 0
    B1 C2 A 0
    B1 C2 B 0
    B1 C2 C 0
    B1 C2 D 0
    B1 C2 E 0
    C1 A2 A 5
    C1 A2 B 0
    C1 A2 C 0
    C1 A2 D 0
    C1 A2 E 0
    C1 A3 A 0
    C1 A3 B 0
    C1 A3 C 0
    C1 A3 D 40
    C1 A3 E 0
    C1 A4 A 0
    C1 A4 B 0
    C1 A4 C 0
    C1 A4 D 4
    C1 A4 E 0
    C1 B2 A 0
    C1 B2 B 0
    C1 B2 C 0
    C1 B2 D 0
    C1 B2 E 0
    C1 C2 A 0
    C1 C2 B 0
    C1 C2 C 0
    C1 C2 D 0
    C1 C2 E 0

    but I want the data show like the fact table.

    if the value not exists in fact table and the cube not show.

    if i describe not clear please leave msg let me know.

    Or Please give me some suggestion about design the schema.xml

  2. #2
    Join Date
    Jan 2013
    Posts
    496

    Default

    MDX Crossjoin() gives the cartesian product of the sets. I'm not sure what BI tool your using, but nesting customer/account/Product is likely resulting in a straight CJ. Most tools will allow some method to specify NON EMPTY on the axes, which will eliminate all tuples that don't have data.

  3. #3
    Join Date
    May 2013
    Posts
    9

    Default

    Thanks mcampbell your reply let me find solution.

    I try NON EMPTY to solve my problem.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •