SELECT 
[Measures].[Castka] ON COLUMNS

FROM [Ukazatele_doklady];

SELECT 
[Measures].[Castka] ON AXIS(0)

FROM [Ukazatele_doklady];

SELECT 
[Measures].[Castka] ON COLUMNS,
[Zakazka].[Cislo Zakazky] ON ROWS

FROM [Ukazatele_doklady];

SELECT 
[Measures].[Castka] ON COLUMNS,
[Zakazka].[Cislo Zakazky].MEMBERS ON ROWS

FROM [Ukazatele_doklady];

SELECT 
[Measures].[Castka] ON COLUMNS,
NONEMPTY([Zakazka].[Cislo Zakazky].MEMBERS) ON ROWS

FROM [Ukazatele_doklady];

SELECT 
[Obdobi].[Rok].MEMBERS ON AXIS(0),
NONEMPTY([Zakazka].[Cislo Zakazky].MEMBERS) ON AXIS(1),
[Measures].[Castka] ON AXIS(2)

FROM [Ukazatele_doklady];

-- nelze  více než 2 osy

SELECT 
[Measures].[Castka] ON COLUMNS,
NON EMPTY( [Zakazka].[Cislo Zakazky].MEMBERS,
           [Ukazatel].[Nazev Ukazatele].MEMBERS,
		   [Obdobi].[Rok].MEMBERS) ON ROWS

FROM [Ukazatele_doklady];

SELECT 
[Measures].[Castka] ON ROWS,
NON EMPTY( [Stredisko].[Cislo Strediska].MEMBERS,
          [Zakazka].[Cislo Zakazky].MEMBERS) ON COLUMNS

FROM [Ukazatele_doklady]