My goal is to

1. Refresh a cube every night (add that days facts using a scheduled job which runs a stored procedure )

2. Deploy that cube (I know how to deploy the cube from the SSAS IDE., It creates a xx.adatabase in the bin folder. on the dev server but I cannot figure out where to look on the deployment server)

3. Open the cube in SSRS and create reports from the cube. This is a sub-question : Until now I only know how to access the cube from SSRS by opening the xx.cube file on my dev server, I don't know how to "deploy" the xx.cube file to the deployment server. I am not sure if the xx.cube file can be deployed to the deployment server. What is the proper way of creating SSRS reports from cubes? 

I am able to do all three steps manually.

I need to know how to do all three steps automatically. (currently I only know how to automate step 1)

Processing Cubes

There are a couple of ways to process a cube or dimension automatically.

1 Use SSIS.

    There are two choices here ; Use the Analysis Services Processing Task to specify the Cube or Dimensions you want to process or

    Alternatively - Add the XMLA Script to an Analysis Services Execute DDL task

   Either way you can use SQL Agent to schedule the Package

2. Use an XMLA script and add to sqlAgent Job as an Analysis Services Command. The schedule using SQL Agent.

You may also want to add a proxy account for the sql agent jobs to run under else they will run with the same priveleges as the sql agent service account.

To Generate the XMLA script fo into SSMS and connect to your analysis services instance.

Right click on the cube (or dimension) you want to process.

Choose your options but don't click on the ok button but click the script button at the top.

Then cancel the dialog box and paste into a query window. You will now have the XMLA required to either enter in the sql Agent Job or the SSIS Analysis Services DDL task.

It should look something like this.

Batch xmlns="http://schemas.microsoft.com/analysisservices/2003/engine">Parallel>Process xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:ddl2="http://schemas.microsoft.com/analysisservices/2003/engine/2" xmlns:ddl2_2="http://schemas.microsoft.com/analysisservices/2003/engine/2/2" xmlns:ddl100_100="http://schemas.microsoft.com/analysisservices/2008/engine/100/100">Object>DatabaseID>Adventure Works DW 2008</DatabaseID>Object>Type>ProcessFull</Type>WriteBackTableCreation>UseExisting</WriteBackTableCreation>Process>Parallel>Batch>

Automated Reports in SSRS

You need to create a schedule to run the report. Schedules can either be specific to the report or be shared between a group of reports. The following prerequiites must be met before you can configure a schedule.

Sql Server agent must be running.

You must configure the report server to support scheduling and delivery options. eg email, fileshare etc

 You must store credentials to run the report on the report server.  This needs to be configured with the following privilege - Read Access to the Reportserverdb, Read Access to MSDB and Read access to all objects in the database(s) included in the report.  

In addition subscriptions & data driven subscriptions can be configured to allow access to the reports on a pull rather than push basis. Data driven subscriptions take a little more configuring but they allow different content to be delivered to each subscriber. eg regional sales managers would only see sales for their region. However, data driven subscriptions are only available with the enterprise edition.

 There is a video on the microsoft site with more details.  http://technet.microsoft.com/en-us/sqlserver/dd420576.aspx