Ola amigos,
Criei uma view na base dados e que é chamada do datasourceview do Analysis Services.
SELECT ID,Dia AS DiaTmp, ISNULL(sumGAPValue,0) AS SumGAP
FROM dbo.CashFlowTeste FULL JOIN dbo.Time ON dbo.CashFlowTeste.Date=dbo.Time.Dia
WHERE (Dia>=(select min(Date) from dbo.CashFlowTeste)
AND Dia<=(select max(Date) from dbo.CashFlowTeste)) AND (WeekDay<>7 AND WeekDay<>1)
AND Holiday<>1 AND ForcedHoliday<>1
Resultado View
9039 2007-06-08 00:00:00.000 1000,00
9042 2007-06-11 00:00:00.000 0,00
9043 2007-06-12 00:00:00.000 25,00
9043 2007-06-12 00:00:00.000 400,00
9044 2007-06-13 00:00:00.000 0,00
9045 2007-06-14 00:00:00.000 700,00
criei no SQL:
SELECT [Measures].[Sum GAP] ON COLUMNS,
([Time].[Dia].&[2007-06-08T00:00:00]:[Time].[Dia].&[2007-06-14T00:00:00]) ON ROWS
FROM [cbRentabilidade]
Ou seja, como eu consigo para cada linha, subtrair o valor da linha actual à linha anterior?
SumGAPDif = SumGAP (CurrentRow) - SUMGAP (PreviousRow)
Alguem me consegue ajudar!?
