Got the answer

It should be as below

SUM (

{ [Cell].[ABC].&[Control] , [Cell].[ABC].&[Core] }*{[Data].[PQR].&[Yes])}

,[Measures].[A]

)

Even I am intrested to know answer for above

keyser soze-308506 (3/19/2013)

I need to send distinct report to distinct persons

I have a dataset of people, with their names, email, etc

including the parameters to run the report

Could I accomplish this...

david.gugg (12/17/2014)

This should probably say "Dropping an index on the table that is not used...

well agree with...

couldnt understand your question

do you want user login who have access to sharepoint site as well as SQL server or do you want the login detail for sharepoint site to...

as sqlbuddy said

If you are using an custom dot net assembly try removing it from script task and upgarde and once done add it back

did you check if the credentials have access to create a job in that server

cdc normally creates multiple job and some system table

did you check if anything has been...

well not posting for book but to value SSC to show courage to accept and apologize publicly

small query to get row number in different way

select row_no =...

Hi

I am not able to use SQL agent as this job has to be called be unix box and so cannot log in as windows user or proxy user

So I...

now I have even tried putting stored procedure in ssisdb to avoid multi database clash but still the issue

The job is called correctly but when it comes to access shared...

this worked for Me but didnt understand what was the problem

Was anyone able to find it to avoid this again

rajborntodare (8/8/2013)

Hi Ashish,

I...

Yes it does that sometimes but as per microsoft it used to do it til SQL server 2005

http://support.microsoft.com/kb/238254/en-us#appliesto

does...

but I am executing a normal update query on one column

For insert and delete the values are correct

problem is only with the update

The setup was done as per msdn documentation...