SELECT
 NON EMPTY {[Measures]} ON COLUMNS,
 NON EMPTY {[Lekar]} ON ROWS
FROM [Tretman]

Axis #0:
{}
Axis #1:
{[Measures].[Iznos]}
Axis #2:
{[Lekar.New Hierarchy 0].[All Lekar.New Hierarchy 0s]}
Row #0: 17,500

----------------------------------------------------------

SELECT
 NON EMPTY {[Measures]} ON COLUMNS,
 NON EMPTY {[Lekar].AllMembers} ON ROWS
FROM [Tretman]
WHERE [Usluga]

Axis #0:
{[Usluga.New Hierarchy 0].[All Usluga.New Hierarchy 0s]}
Axis #1:
{[Measures].[Iznos]}
Axis #2:
{[Lekar.New Hierarchy 0].[All Lekar.New Hierarchy 0s]}
Row #0: 17,500

----------------------------------------------------------

SELECT
 NON EMPTY {[Measures]} ON COLUMNS,
 NON EMPTY {[Pacijent].AllMembers} ON ROWS
FROM [Termin]

Axis #0:
{}
Axis #1:
{[Measures].[Iznos]}
Axis #2:
{[Pacijent.New Hierarchy 0].[All Pacijent.New Hierarchy 0s]}
Row #0: 8,050

----------------------------------------------------------

SELECT
 NON EMPTY {[Measures]} ON COLUMNS,
 NON EMPTY {[Pacijent].AllMembers} ON ROWS
FROM [Termin]
WHERE [Ostvarenost]

Axis #0:
{[Ostvarenost.New Hierarchy 0].[All Ostvarenost.New Hierarchy 0s]}
Axis #1:
{[Measures].[Iznos]}
Axis #2:
{[Pacijent.New Hierarchy 0].[All Pacijent.New Hierarchy 0s]}
Row #0: 8,050

----------------------------------------------------------

select
non empty {[Measures]} on columns,
non empty {[Lekar]} on rows
from Tretman
where Pacijent.Pol.[zensko]

Axis #0:
{[Pacijent.New Hierarchy 0].[zensko]}
Axis #1:
{[Measures].[Iznos]}
Axis #2:
{[Lekar.New Hierarchy 0].[All Lekar.New Hierarchy 0s]}
Row #0: 6,500

----------------------------------------------------------

select
{[Measures].Iznos} on columns,
filter({[Lekar].Children}, [Measures].Iznos >= 0) on rows
from Tretman

Axis #0:
{}
Axis #1:
{[Measures].[Iznos]}
Axis #2:
{[Lekar.New Hierarchy 0].[Ana Misic]}
{[Lekar.New Hierarchy 0].[Goga Sekulic]}
{[Lekar.New Hierarchy 0].[Marija Despotovic]}
{[Lekar.New Hierarchy 0].[Marko Milicevic]}
{[Lekar.New Hierarchy 0].[Marko Pavlovic]}
{[Lekar.New Hierarchy 0].[Risto Nesic]}
Row #0: 3,000
Row #1: 2,500
Row #2: 2,500
Row #3: 3,500
Row #4: 2,500
Row #5: 3,500

----------------------------------------------------------

select
{[Measures].Iznos} on columns,
filter({[Lekar].Children}, [Measures].Iznos >= 2501) on rows
from Tretman

Axis #0:
{}
Axis #1:
{[Measures].[Iznos]}
Axis #2:
{[Lekar.New Hierarchy 0].[Ana Misic]}
{[Lekar.New Hierarchy 0].[Marko Milicevic]}
{[Lekar.New Hierarchy 0].[Risto Nesic]}
Row #0: 3,000
Row #1: 3,500
Row #2: 3,500

----------------------------------------------------------

select
{[Measures].Iznos} on columns,
[Lekar].Children on rows
from Tretman

Axis #0:
{}
Axis #1:
{[Measures].[Iznos]}
Axis #2:
{[Lekar.New Hierarchy 0].[Ana Misic]}
{[Lekar.New Hierarchy 0].[Goga Sekulic]}
{[Lekar.New Hierarchy 0].[Marija Despotovic]}
{[Lekar.New Hierarchy 0].[Marko Milicevic]}
{[Lekar.New Hierarchy 0].[Marko Pavlovic]}
{[Lekar.New Hierarchy 0].[Nemanja Rasic]}
{[Lekar.New Hierarchy 0].[Nina Saponjic]}
{[Lekar.New Hierarchy 0].[Risto Nesic]}
Row #0: 3,000
Row #1: 2,500
Row #2: 2,500
Row #3: 3,500
Row #4: 2,500
Row #5: 
Row #6: 
Row #7: 3,500


----------------------------------------------------------

select
{[Measures].Iznos} on columns,
non empty [Lekar].Children on rows
from Tretman

Axis #0:
{}
Axis #1:
{[Measures].[Iznos]}
Axis #2:
{[Lekar.New Hierarchy 0].[Ana Misic]}
{[Lekar.New Hierarchy 0].[Goga Sekulic]}
{[Lekar.New Hierarchy 0].[Marija Despotovic]}
{[Lekar.New Hierarchy 0].[Marko Milicevic]}
{[Lekar.New Hierarchy 0].[Marko Pavlovic]}
{[Lekar.New Hierarchy 0].[Risto Nesic]}
Row #0: 3,000
Row #1: 2,500
Row #2: 2,500
Row #3: 3,500
Row #4: 2,500
Row #5: 3,500

----------------------------------------------------------

select
{[Measures].Iznos} on columns,
non empty filter({[Lekar].Children}, [Lekar].Ime.CurrentMember NOT IN {[Ana Misic], [Marija Despotovic]}) on rows
from Tretman

Axis #0:
{}
Axis #1:
{[Measures].[Iznos]}
Axis #2:
{[Lekar.New Hierarchy 0].[Goga Sekulic]}
{[Lekar.New Hierarchy 0].[Marko Milicevic]}
{[Lekar.New Hierarchy 0].[Marko Pavlovic]}
{[Lekar.New Hierarchy 0].[Risto Nesic]}
Row #0: 2,500
Row #1: 3,500
Row #2: 2,500
Row #3: 3,500

----------------------------------------------------------

select
{[Measures].Iznos} on columns,
non empty order(filter({[Lekar].Children}, [Lekar].Ime.CurrentMember NOT IN {[Ana Misic], [Marija Despotovic]}), [Measures].Iznos, asc) on rows
from Tretman

Axis #0:
{}
Axis #1:
{[Measures].[Iznos]}
Axis #2:
{[Lekar.New Hierarchy 0].[Goga Sekulic]}
{[Lekar.New Hierarchy 0].[Marko Pavlovic]}
{[Lekar.New Hierarchy 0].[Marko Milicevic]}
{[Lekar.New Hierarchy 0].[Risto Nesic]}
Row #0: 2,500
Row #1: 2,500
Row #2: 3,500
Row #3: 3,500

----------------------------------------------------------

select
{[Measures].Iznos} on columns,
order(filter({[Lekar].Children}, [Lekar].Ime.CurrentMember NOT IN {[Ana Misic], [Marija Despotovic]}), [Measures].Iznos, asc) on rows
from Tretman

Axis #0:
{}
Axis #1:
{[Measures].[Iznos]}
Axis #2:
{[Lekar.New Hierarchy 0].[Nemanja Rasic]}
{[Lekar.New Hierarchy 0].[Nina Saponjic]}
{[Lekar.New Hierarchy 0].[Goga Sekulic]}
{[Lekar.New Hierarchy 0].[Marko Pavlovic]}
{[Lekar.New Hierarchy 0].[Marko Milicevic]}
{[Lekar.New Hierarchy 0].[Risto Nesic]}
Row #0: 
Row #1: 
Row #2: 2,500
Row #3: 2,500
Row #4: 3,500
Row #5: 3,500


----------------------------------------------------------

select
{[Measures].Iznos} on columns,
head(order(filter({[Lekar].Children}, [Lekar].Ime.CurrentMember NOT IN {[Ana Misic], [Marija Despotovic]}), [Measures].Iznos, asc), 5) on rows
from Tretman

Axis #0:
{}
Axis #1:
{[Measures].[Iznos]}
Axis #2:
{[Lekar.New Hierarchy 0].[Nemanja Rasic]}
{[Lekar.New Hierarchy 0].[Nina Saponjic]}
{[Lekar.New Hierarchy 0].[Goga Sekulic]}
{[Lekar.New Hierarchy 0].[Marko Pavlovic]}
{[Lekar.New Hierarchy 0].[Marko Milicevic]}
Row #0: 
Row #1: 
Row #2: 2,500
Row #3: 2,500
Row #4: 3,500

----------------------------------------------------------

select [Measures].Iznos on columns,
non empty crossjoin({[Lekar].Children}, {Dan.Children}) on rows
from Tretman

Axis #0:
{}
Axis #1:
{[Measures].[Iznos]}
Axis #2:
{[Lekar.New Hierarchy 0].[Ana Misic], [Dan.New Hierarchy 0].[2009-07-26]}
{[Lekar.New Hierarchy 0].[Goga Sekulic], [Dan.New Hierarchy 0].[2009-03-12]}
{[Lekar.New Hierarchy 0].[Marija Despotovic], [Dan.New Hierarchy 0].[2009-05-11]}
{[Lekar.New Hierarchy 0].[Marko Milicevic], [Dan.New Hierarchy 0].[2009-03-23]}
{[Lekar.New Hierarchy 0].[Marko Pavlovic], [Dan.New Hierarchy 0].[2009-02-23]}
{[Lekar.New Hierarchy 0].[Marko Pavlovic], [Dan.New Hierarchy 0].[2009-07-12]}
{[Lekar.New Hierarchy 0].[Risto Nesic], [Dan.New Hierarchy 0].[2009-01-02]}
{[Lekar.New Hierarchy 0].[Risto Nesic], [Dan.New Hierarchy 0].[2009-09-12]}
Row #0: 3,000
Row #1: 2,500
Row #2: 2,500
Row #3: 3,500
Row #4: 1,500
Row #5: 1,000
Row #6: 2,000
Row #7: 1,500

----------------------------------------------------------

select [Measures].Iznos on columns,
filter(crossjoin({[Lekar].Children}, {Dan.Children}), not isempty([Measures].Iznos)) on rows
from Tretman

Axis #0:
{}
Axis #1:
{[Measures].[Iznos]}
Axis #2:
{[Lekar.New Hierarchy 0].[Ana Misic], [Dan.New Hierarchy 0].[2009-07-26]}
{[Lekar.New Hierarchy 0].[Goga Sekulic], [Dan.New Hierarchy 0].[2009-03-12]}
{[Lekar.New Hierarchy 0].[Marija Despotovic], [Dan.New Hierarchy 0].[2009-05-11]}
{[Lekar.New Hierarchy 0].[Marko Milicevic], [Dan.New Hierarchy 0].[2009-03-23]}
{[Lekar.New Hierarchy 0].[Marko Pavlovic], [Dan.New Hierarchy 0].[2009-02-23]}
{[Lekar.New Hierarchy 0].[Marko Pavlovic], [Dan.New Hierarchy 0].[2009-07-12]}
{[Lekar.New Hierarchy 0].[Risto Nesic], [Dan.New Hierarchy 0].[2009-01-02]}
{[Lekar.New Hierarchy 0].[Risto Nesic], [Dan.New Hierarchy 0].[2009-09-12]}
Row #0: 3,000
Row #1: 2,500
Row #2: 2,500
Row #3: 3,500
Row #4: 1,500
Row #5: 1,000
Row #6: 2,000
Row #7: 1,500