@VegasL, 

this is a simple requirement, you yourself can write the query for this..
anyway, Mr.PietLinden has tried to help you with a sample query.. 

what...

Hi PC Reddy, 

here is the query you asked for

Question 1
(Need to czategorize the column as positive and negative and sum it as below.)

Hi Eirikur, 

Thanks a lot for the reply with valued informations..

I saw the post you suggested.. looks there is a bunch of information where I can...

Hi Kevin,

Initially I created the Staging table in a file group ([MyPartitionValueCurrentfg]) where the data which I want to move...

Hi,

Though this is an Old thread, my answer might help someone.(I believe you might have found the solution sometime later you posted this thread).

to be precise to...

Hi All,

the problem was on converting the value into float as micheal and gail said, the code given by gail works for me.

Thanks gail and everyone for your quick...

Hi Anjali,

whatever you tried (that is what suggested by phil as well) is the shortest way to achieve this requirement.

Thanks,

Prabhu

Hi Luis,

Yes, your answer is approximately correct, I already tried this idea as well, what happened you know, it is getting successfully executed with raw value I mean hardcoded value.....

Hi Jack,

thanks for the information. But it doesn't help me to fix the issue, because I already tried those ideas which were not working..

But I like your intension...

Hi Dave,

yes, the point you have explained in the first paragraph is correct. that was my approach. Now I have modified the "Execute Package Task" to call the package from...

there are two way to get a fix

Try using the Shared Datasource instead of embedded Datasource and deploy the datasource in the server where the reports has been deployed

may help.

-Prabhu

I found the reason, though there are several reasons for this error from MDX query through SSRS report, what I found is, the functionality of STRTOMEMBER / STRTOSET is getting...

Hi Suthan

I believe I am looking into this post very late. but it is very very useful for me.. thanks to you..

and Thanks to SQLSERVERCETRAL, because nowhere I got...

Freinds,

Finally the confusion has got endup and based on the advice from you guys (bit from each of you) have achieved the query to run faster and completed in...