Are you able to preview the SQL Server Report items in Dashboard Designer when you configure them? When you deploy to Preview can you view the report items properly?...

As an example then since you have your date key setup in the yyyymmdd format you could then setup a calculation referencing that information by doing the following:

with member Measures.[Last...

I would make sure that you have installed the latest service pack for SQL Server 2005 and BIDS which would be SP3. Install this and then see if you...

You can utilize multiple data sources and use both relational and multi-dimensional sources for these. Just remember that you will need to format the parameter values properly when passing...

You might want to take a quick peek at this discussion in getting the same day of week for previous year here - Get date for last year for same...

You can setup the date/time parameter and put a default value of something along the lines of: =CDate(Now().AddDays(-1).ToShortDateString())

Then you can setup the command text for your query with the logic...

create the project in the following order: data source, data source view, dimensions, and then cubes.

All of the dimensions in an SSAS project are setup to be shared dimensions and you can select which ones you include in each cube, so you are able to...

You might want to take a look at this other posting in the forums and view the best practice articles that I included along with the video for reference for...

You will want to utilize configurations and you can do this by storing them in a database or by using configuration files. Take a look at this other posting...

Take a look at the KB article here:

Error message when you try to print a SQL Server 2005 Reporting Services report on a client computer: "Unable to load client print...

You need to include the reference to the parameter you have created in your dataset if you are using embedded T-SQL. Take a look at one of the Tutorials...

You can expose the cube by allowing users to connect with items like SSRS or Excel. Perspectives are used to create views of the data and create simplified views...

Here is some configuration information for you to take a look at:

SSIS Configurations

Best Practices for Integration Services Configurations

Reusing Connections with Data Sources and Configurations

Understanding Integration Services Package Configurations

I would also look at your database and make sure the statistics are updated and that you have proper indexes setup. Perform the heavy lifting in the database and...