Just wanted to share how i had burnt my hands a while ago!

I've opted to deploy...

You are correct. This is introduced only in R2.

Simply Put:

MOLAP must be used when query performance is important. Cubes data and aggregations are stored on SSAS server in this mode. But, data changes in the source doesn't automatically...

I'm sure there will be more efficient ways, but something like this can get the job done.

CREATE TABLE #Customers

(

LastName VARCHAR(30)

) ;

INSERT #Customers

VALUES ('Vanga') ;

INSERT #Customers

VALUES ('Va12gf3') ;

SELECTLastName AS LastNameWithNumbers

FROM#Customers

WHERELastName...

I will be happy to tackle this, if no one has yet!

Following is an article that might help you. It's using SSIS 2005, but clearly explains all the concepts.

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/62063/

It doesn't sound like you're missing something.

I would make sure that cube has been processed,if not processed already, and that calculation is not erroring out.

MaBear (11/17/2011)

---

I found if I remove the report data file from my local folder, then reopen the report, it runs without problem. Could someone tell me the reason behinds this...

Turns out it doesn't. I just learned this

Earlier...

Staging data into a table is the best and cleanest way as suggested above.

But if for some reason you dont want to use this approach, you could try...

Thats correct. There are too many to list.

Step by Step books from microsoft press are also good places to start.

Check out SSAS tutorials on msdn, stairway to integration services[/url], and...