Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: Cube / MDX - number of x having y

  1. #1
    Join Date
    Oct 2007
    Posts
    8

    Default Cube / MDX - number of x having y

    hi,

    Suppose i have 2 tables: Customer and Orders. Orders is my fact table. How can i create measures for the following query:
    - How much customers have orders above 1000 euros in 2008? (in percentages)

    Of course you have to drill down on this. E.g. first you see the percentages overall, but you should also drill to separate shops.

    Does any one an answer for this? How can i do this in my cube or in my MDX query?

    Tables:
    Customers (dimension)
    OrderLines (facttable): ordernr, customer, item, count, price

    Thank you in advance,

    Adriaan
    Last edited by avkekem; 03-10-2008 at 05:00 AM. Reason: added table definition

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.