By default there are the FlightRecorderTrace files that you can reference unless you have turned these off which are stored in the Log directory. These are only available for...

You can setup the file connection managers connection dynamically using expressions. You can also use variables to help you out if needed if you need to loop through the...

Do you possibly have the unattended execution setup in the Reporting Services Configuration Manager? If so trying disabling or removing this and restarting the service to see if that...

Lots of new features that you can take advantage of with database encryption, backup compression, auditing, change data capture, policy based management, ssis thread management, ssis data profiling task, ssis...

I did a quick example using the same concepts that you are trying to apply with boxes against the Adventure Works DW database. Granted I didn't have anything to...

If the report works locally within BIDS, but not once it is deployed to Report Server then it most likely with the connection string settings. Are you specifying the...

Yeah, Project Real is an excellent source of reference in regards to implementing best practices. This was the big case study that was done with SQL Server 2005 with...

There are lots of filter and sorting capabilities within Excel that you can leverage to control what is being displayed. In this scenario you are wanting to implement a...

You can build the cube on top of the transactional system or from multiple systems like is stated in the book. I would not recommend placing the cube directly...

As far as Data Warehousing goes anything by Ralph Kimball or the Kimball Group is great content. There is the Data Warehouse Toolkit, ETL Toolkit, Webhouse Toolkit, Lifecycle Toolkit,...

Sounds good. In my example I didn't actually reference a named set, but it is a set of members from the hierarchy at different levels. Guess I am...

I believe you are just going to want to create a named set or at least a set of dimension members that you would like to reference from your dimension...

As far as Data Warehousing goes anything by Ralph Kimball or the Kimball Group is great content. There is the Data Warehouse Toolkit, ETL Toolkit, Webhouse Toolkit, Lifecycle Toolkit,...

I would definitely verify the account that is running the job to verify that the credentials have the necessary permissions to the data source and to process the cube. ...

For a great list of client tools that can be used against SQL Server Analysis Services refer to this link:

http://www.ssas-info.com/analysis-services-client-tools-frontend