//zad1
//a)
//SELECT  
//   [Measures].[Liczba transakcji] on COLUMNS
//FROM [Salon]  
// 
//b)
//SELECT  
//   [Measures].[Liczba transakcji] on COLUMNS,
//   [Klienci].[Miasto].MEMBERS  ON Rows  
//FROM [Salon]  
// 
////c)
//SELECT  
//   [Towary].[Producent].Children on COLUMNS,
//   [Klienci].[Wojewodztwo].Children  ON Rows  
//FROM [Salon]  
// 
////zad2
//SELECT  
//   [Towary].[Hierarchy].MEMBERS on COLUMNS,
//   [Klienci].[Hierarchy].MEMBERS  ON Rows
//FROM [Salon]  
// 
////zad3
//SELECT  
//   {[Measures].[Koszt], [Measures].[Liczba transakcji]} on COLUMNS,
//   {Crossjoin([Klienci].[Hierarchy].[Wojewodztwo].&[pomorskie].&[Sopot], [Towary].[Hierarchy].[Producent].&[Fiat]),Crossjoin([Klienci].[Hierarchy].[Wojewodztwo].&[pomorskie].&[Sopot], [Towary].[Hierarchy].[Producent].&[Ford]),Crossjoin([Klienci].[Hierarchy].[Wojewodztwo].&[wielkopolskie].&[Gniezno], [Towary].[Hierarchy].[Producent].&[Ford].&[Escord])}  ON Rows
//FROM [Salon]  
// 
////zad4
SELECT 
[Measures].[Koszt] on Columns,
[Dni].[Rok].Members on Rows from [Salon]

//zad 4
SELECT  
   [Measures].[Zysk] on COLUMNS,
   [Klienci].[Hierarchy].MEMBERS  ON Rows  
FROM [Salon]  

//zad 5
SELECT 
{CrossJoin([Towary].[Producent].Members, [Dni].[Rok].Members)} on rows,
{[Measures].[Zysk],[Measures].[LiczbaTransakcji] , [Measures].[DataOstSprzedazy]} on columns
From [Salon]

//zad 6
SELECT 
{CrossJoin({[Towary].[Marka].&[Escord],[Towary].[Marka].&[Focus]}, [Dni].[Rok].children)} on rows,
{CrossJoin([Klienci].[Wojewodztwo].Members,{[Measures].[Przychod],[Measures].[LiczbaKlientow]})} on columns
From [Salon]

//zad 7
SELECT 
[Klienci].[Hierarchy].Members on rows,
[Towary].[Marka].Members on columns
From [Salon]
WHERE ([Dni].[Rok].[2011],[Measures].[LiczbaKlientow])

//zad 8

WITH MEMBER [Measures].[Proc] AS 
[Measures].[Przychod]/[Measures].[Koszt]
SELECT 
[Klienci].[Hierarchy].Members on rows,
{[Measures].[Przychod],[Measures].[Koszt],[Measures].[Proc] }on columns
From [Salon]