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
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