InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 15:53:37 GMT20http://www.sqlservercentral.com/Forums/Topic446959-17-1.aspxalready found it my self.thxFri, 01 Feb 2008 05:41:29 GMTjvElecenterhttp://www.sqlservercentral.com/Forums/Topic446959-17-1.aspxHiMy regular query (relational database) is :select year(CLE.[Due Date]) as Jaar, month(CLE.[Due Date]) as Maand, DATEPART(week, CLE.[Due Date]) as Week, sum(GLE.[Remaining Amount]) as Saldo from dbo.[FIN SEPIA$Cust_ Ledger Entry] as CLEjoin dbo.[FIN SEPIA$G_L Entry] as GLE on GLE.[Document No_] = CLE.[Document No_]where CLE.[Document Type] = '2' and CLE.[Open] = '1' and GLE.[G_L Account No_] = '400000'and DATEPART(week, CLE.[Due Date]) in (@parWeek)and year(CLE.[Due Date]) in ('2007','2008')group by year(CLE.[Due Date]), month(CLE.[Due Date]), DATEPART(week, CLE.[Due Date])I guess the dateparts are coming from a time dimension, but my amounts are in fact a join between two tables and a where clause.How should I build up my dimension or is this a fact table ?Many thanks in advance El JefeThu, 24 Jan 2008 08:30:45 GMTjvElecenter