Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MDX Query

Status
Not open for further replies.

Jony77

IS-IT--Management
May 4, 2008
9
0
0
LU
Hello,

I have two dimensions, time and machine. The machine dimension has two levels, machine number and machine location. I have two measures, unit (measures the quantity of machine production) and average_unit. In the machine table of the database there are multiple entries of the machines and their time of production. So I can have multiple entries of the same machine with different production time.

My question is how can I write a MDX query which will show the different machines against the unit (quantity of production)

I tried this:

Select {[Measures].[Unit]} ON COLUMNS,
{[Machine].[All Machines]} ON ROWS
FROM [First_Cube]
WHERE [Time].[2008]


This query is wrong because it lists all the machines but I want to only list the DISTINCT Machine Number against the Measure Unit.

Thanks,

Jony
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top