In pentaho,I used the below is the MDX Query for dropdown ,
WITH
MEMBER [Measures].[Years UniqueName] AS
[Time].currentmember.UniqueName
SET YEAR AS UNION( [Time].[All Years] , [Time].[Years].Members )
SELECT
[Measures].[Years UniqueName] ON COLUMNS,
YEAR ON ROWS
FROM [SteelWheelsSales];
Here ,when i clicked on "All Years" I got all the year details(eg:2003,2004 etc.).
Now, I need to use MySQL for the dropdown and want to get the field "All years" in it. When I click on it, all details need to display.
Can anybody help me to change the above MDX query into MySQL..