it is NOT time consuiming process.

for what is it taking too much time for u?

is the data in the report from database which is located on network server. if this is the case then it might be possible that database might get refreshed over...

For example-- below is a piece of code which make use of [Small Vs Big] dimension which is hidden within cube (i.e. not listed in dim lists) and I want...

Steve,

Yes that is the case. it is not listed in any dimensions/measures list.

I am viewing it from SSMS (once the cube has been deployed to the server). And I...

Go to Config Manager->Databases,

Set credentials to : Service Account

Login: Local System

and now restart your SSRS service.

--VT

Try changing credentials from Configuration Manager->Databases

and test again.

-VT