Hello Vineet,

That was simple...Did you try the SCD and the CDC approach.

Also...was my response conclusive.

Please let me know.

Hi,

I'm not sure about the security issue but have you tried creating Perspetive in SSAS Cubes...

Perspective meet your requirements....

hi...

Approach 1:

If your warehouse is not a scaled out approach you might try implementing the Lookup Values Task

thus only getting the non-matched values and manipulating/updating the same to your warehouse...

Apart from being limited to Type 1,2 and 3 The SSIS SCD component does not support Type 4 and 6...which I believe If the need arises The BI developer has...

Sachin,

Please avoid cross posts.

;-);-);-)

IT is surely rsing at magnificent pace....

Got to get my boots geared up.....

Sanket,

What SQL Server version are you using...

Hi,

You can use the Cube as a data source for your reporting needs and implement the same using the Report Builder or any conventional tool.

Hello Nitin,

Why do you want to use the Time Dimension Key for such purpose....

Why not get the relevant in the ETL phase itself....

It would be lot easier to handle.

Kindly let...

is the report generated by these parameters related

Hi Malavika,

I would suggest you to introduce multi parameter report and optimize your underlying dataset SQL query on the basis of parameter selection using the IF/WHERE or CASE clause.

Sachin,

http://msdn.microsoft.com/en-us/library/ms155998.aspx

This is really interesting....deleting the old .rdl....

:alien:

Sachin,

Please follow here

:satisfied::satisfied::satisfied: