I don't know if it is possible to create a subscription on run time and remove ? Will do this job for me.

But looks i am pogoing. Thanks you...

I am looking for the solution in the MDX Construct.

I don't want to restrict null at the time of cube processing.

thanks and regards

VD

Thanks Lowell , but I am getting below error while executing the query.

"Ad Hoc queries are not allowed to be execute directly".

I don't know weather SQL Server provides any...

Here did you mean this needed a row for each date in the new fact table ?

Vineet D.

Link is a nice exhibition of M-To-M complexities but my points of challenge - what should be my fact table the employee start date and end date are stored in...

1) The employee can be on more then one project.

2) The StartDate and EndDate of ProjectTeam table are dates , when an employee is active on the project.(Not the project...

I glade and thanks to all members for giving solution and suggestion. This is working pretty nicely.

Vineet D

--for case#1 and for the date range KRISS AND VDNTI is active for only 7 days but applying parameters to where clause result is giving 31 and 30

--e.g.

declare @FromDt...

Hi pietlinden,

I am greatful to see answer for case #4. But I am really finding ,how do I construct WHERE clause to pass the Fromdt and Todt Parameters

for...

in sql server 2012 I am able to create the synoname also I am able to select the rows from the table.

so this means this is only true in the...

Can anybody suggest me on this ?

drop in a loop makes the table inaccessible to external user? Can you share some e.g. how we can apply the loop that should i iterate through.

Thanks for the help...

I initially thought of this solution but on production database , SQL Server won't allow me to drop the Origanal table as this might be accessed by some user at...

Thnx !

Some people argued this feature supported in Oracle ..SQL Server also have that.

I have gone through the link above for to create the indexed views and materialized...

Thanx a lot ! Let me try this on the Production DB Set.