OK, then your problem looks a lot like a many-2-many issue.

So you could try to model your dimension as a many2many dimension in SSAS.

Yes ... that was totally my intention ...

😀

Richard Warr (9/16/2013)

---

This isn't a "nice and simple" or "easy one" at all. Although the explanation is wrong the question illustrates a very subtle nuance with the way scripts are...

Here's a video on how to implement the OLE DB Command:

SSIS OLE DB Command Transformation

Basically you are issuing an UPDATE statement for every row. In the editor, you map columns...

Why don't you use the ID field of the groups-account dimension as a surrogate key in your fact table?

I bet they are still laughing...

😀

At what rate is the data refreshed?

If it's only daily, you can run a snapshot early in the morning the generate the report.

It will take some time to transfer the...

The question itself is great, however the explanation is lacking.

There's no reference, and the explanation itself is incorrect.

There's no variable that is "reset".

The DECLARE is not ignored, it is interpreted...

If...

The article I linked to...

WITH AuditData AS (

SELECT *,

RN = ROW_NUMBER() OVER(PARTITION BY ID ORDER BY [Modified On] DESC),

max([Modified on]) OVER(PARTITION BY ID) AS [Max Modified On]

FROM @Audit

)

SELECT [ID], [Owner], [Modified on], [Value], [Max...

Duplicate post. Original post with replies can be found here:

http://www.sqlservercentral.com/Forums/Topic1494482-145-1.aspx

Tom Brown (9/13/2013)

---

DECLARE @StartDate DATETIME;

SELECT @StartDate = DATEADD(year, DATEDIFF(year,0,GETDATE()), 0);

-- This clause is just to get some numbers: a Tally table, for joining to get a range of dates

WITH...

Here you go:

-- Set the first day of the week to Monday

SET DATEFIRST 1;

-- create the current year

DECLARE @YearStartDATE = CONVERT(DATE,CONVERT(CHAR(4),YEAR(GETDATE())) + '-01-01');

DECLARE @YearEndDATE = CONVERT(DATE,CONVERT(CHAR(4),YEAR(GETDATE())) + '-12-31');

WITH CTE_FullYear AS

(

SELECT...

Are you asking which will be faster: the view or the table?

A view is basically just a stored SELECT statement on one or more tables.

To get the data out of...