GED

-- zad 6 --
WITH MEMBER Klient.[Zagregowane] AS
	'AGGREGATE ({[Klienci].[Klient].[Klient].[Avans], [Klienci].[Klient].[Klient].[Media Markt]})'
SELECT {[Measures].[Wartosc]} ON COLUMNS,
{[Klienci].[Klient].[Klient].[Avans],[Klienci].[Klient].[Klient].[Media Markt], Klient.[Zagregowane] } ON ROWS
FROM [FraniaDSV]

-- zad 7 --
WITH MEMBER [Measures].Ilosc2 AS
'MAX({[Towary].[Podgrupa].[Podgrupa].[zmywarki] * [Regiony].[Region].[Region].AllMembers}, [Measures].[Ilosc])'
SELECT [Measures].Ilosc ON COLUMNS,
{([Towary].[Grupa].[Grupa], FILTER({([Regiony].[Region].[Region])}, [Measures].[Ilosc]=[Measures].[Ilosc2]) )} ON ROWS
FROM [FraniaDSV]
WHERE ( [Towary].[Podgrupa].[Podgrupa].[zmywarki], [Czas].[Rok].[Rok].[2007] )

-- zad 8 --
WITH
	MEMBER [Measures].Razem
	AS 'SUM([Towary].[Podgrupa].[Podgrupa].AllMembers,[Measures].Obrot)'
	Member [Measures].Procent
	AS '[Measures].Obrot/[Measures].Razem' , format = '#.00%'
SELECT {[Measures].Procent} ON COLUMNS,
[Towary].[Podgrupa].[Podgrupa] ON ROWS
FROM [FraniaDSV]

-- zad 9 --
WITH Member [podgrupa_] AS
'[Towary].[Hierarchy 1].Parent.Name'
MEMBER [grupa_] AS
'[Towary].[Hierarchy 1].Parent.Parent.Name'
SELECT {[podgrupa_], [grupa_]} ON COLUMNS,
{[Towary].[Towar Hierarchia].[Towar Hierarchia]} ON ROWS
FROM [FraniaDSV]


-- zad 10 --
WITH
	MEMBER [Measures].RazemRynek
	AS 'SUM([Towary].[Towar Hierarchia].[Towar Hierarchia].AllMembers,[Measures].Obrot)'
	Member [Measures].ProcentRynek
	AS '[Measures].Obrot/[Measures].RazemRynek' , format = '#.00%'

	MEMBER [Measures].RazemPodgrupa
	AS 'SUM([Towary].[Hierarchy 1].Parent,[Measures].Obrot)'
	Member [Measures].ProcentPodgrupa
	AS '[Measures].Obrot/[Measures].RazemPodgrupa' , format = '#.00%'

	MEMBER [Measures].RazemGrupa
	AS 'SUM([Towary].[Hierarchy 1].Parent.Parent,[Measures].Obrot)'
	Member [Measures].ProcentGrupa
	AS '[Measures].Obrot/[Measures].RazemGrupa' , format = '#.00%'

SELECT {[Measures].ProcentPodgrupa, [Measures].ProcentGrupa, [Measures].ProcentRynek} ON COLUMNS,
{[Towary].[Towar Hierarchia].[Towar Hierarchia]} ON ROWS
FROM [FraniaDSV]

--- zad 11 --
WITH MEMBER Region.[Najlepsi-Suma] AS
'AGGREGATE(TOPCOUNT([Regiony].[Region].[Region].Members, 3, [Measures].Ilosc))'
MEMBER Region.[Reszta-Suma] AS
'AGGREGATE(EXCEPT(TOPCOUNT([Regiony].[Region].[Region].Members, 9, [Measures].Ilosc), TOPCOUNT([Regiony].[Region].[Region].Members, 3, [Measures].Ilosc)))'
SELECT {[Measures].Ilosc} ON COLUMNS,
{[Regiony].Region.Region, Region.[Najlepsi-Suma], Region.[Reszta-Suma]} ON ROWS
FROM [FraniaDSV]