Hi,

I have done Cognos 10 integration with SSAS cubes. Once you have created the framework package you can then make changes to the cube and it will refresh ok once...

Thanks for the solution Artem!

Financial Year

IF OBJECT_ID('tempdb..#t') IS NOT NULL DROP TABLE #t

SELECT

[accountcode], [rep], [BudgetValue], REPLACE([Period], 'Period', '')

as [Period]

INTO #t

FROM

(SELECT

...

Hi,

I have tried really hard to understand this question but I can not understand.

Do you have an identity column in either table?

This is how you copy data from one table...