//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]
{"html5":"htmlmixed","css":"css","javascript":"javascript","php":"php","python":"python","ruby":"ruby","lua":"text\/x-lua","bash":"text\/x-sh","go":"go","c":"text\/x-csrc","cpp":"text\/x-c++src","diff":"diff","latex":"stex","sql":"sql","xml":"xml","apl":"apl","asterisk":"asterisk","c_loadrunner":"text\/x-csrc","c_mac":"text\/x-csrc","coffeescript":"text\/x-coffeescript","csharp":"text\/x-csharp","d":"d","ecmascript":"javascript","erlang":"erlang","groovy":"text\/x-groovy","haskell":"text\/x-haskell","haxe":"text\/x-haxe","html4strict":"htmlmixed","java":"text\/x-java","java5":"text\/x-java","jquery":"javascript","mirc":"mirc","mysql":"sql","ocaml":"text\/x-ocaml","pascal":"text\/x-pascal","perl":"perl","perl6":"perl","plsql":"sql","properties":"text\/x-properties","q":"text\/x-q","scala":"scala","scheme":"text\/x-scheme","tcl":"text\/x-tcl","vb":"text\/x-vb","verilog":"text\/x-verilog","yaml":"text\/x-yaml","z80":"text\/x-z80"}