-- Obdobje teden
CREATE STATIC SET CURRENTCUBE.[Teden - Tekoči dan]
AS {Filter([Teden].[Hierarchy].[Datum].members, [Teden].Currentmember.Properties("Tekoči dan") = "1")};

CREATE STATIC SET CURRENTCUBE.[Teden - Tekoči teden]
AS {Ancestor([Teden - Tekoči dan].Item(0), [Teden].[Hierarchy].[Teden])};

CREATE STATIC SET CURRENTCUBE.[Teden -1]
AS {[Teden - Tekoči teden].Item(0).Lag(1)};

CREATE STATIC SET CURRENTCUBE.[Teden -2]
AS {[Teden - Tekoči teden].Item(0).Lag(2)};

CREATE STATIC SET CURRENTCUBE.[Teden -3]
AS {[Teden - Tekoči teden].Item(0).Lag(3)};

CREATE STATIC SET CURRENTCUBE.[Teden -4]
AS {[Teden - Tekoči teden].Item(0).Lag(4)};