If you take a look at the AdventureWorks cube with Reseller Sales Amount this is what you would do to get the previous years sales for each period and get...

You can do a lookup on this within the SQL Server BOL "MDSCHEMA_MEASURES Rowset" - http://msdn.microsoft.com/en-us/library/ms126250.aspx

An enumeration that identifies how a measure was derived. Can be one of the following...

Within the Dimension Designer you will see a new tab labeled 'Attribute Relationships' click on this tab. From here you can either click on the relationship link (arrow)...

Have you tried to install the SQL Server 2005 client tools at all? I would re-install the Client Tools from the SQL Server 2005 install and apply any service...

Assuming you are doing this with SSRS and going against an SSAS source since you are talking about MDX. You can do this with SSRS by using the Analysis...

There is lots of content all over the Internet in regards to SSAS tutorials and overviews. Here are a few for you to checkout - http://www.accelebrate.com/sql_training/ssas_tutorial.htm or you...

So do you actually want to use the SSIS package as the source of the SSRS report? If you are looking for information about that you can look at...

Really depends on your data and how you are controlling the load. You might need a surrogate key on the fact for ETL purposes for a loading point-of-view or...

It looks like this is the Excel 2000 or 2003 edition (not that it matters). The naming of the items is coming directly from what is defined in your...

Yeah, nothing has changed as far as being able to use an expression to control this property value. If you are doing something different that does not permit this...

Have you tried a different report and exporting to Excel? If it is something specific to a particular report then you must be running into a limitation with the...

What are you trying to return exactly? You want to TopCount based on a date? Or based on a particular value? Trying to figure out what you...

I would definitely look at and utilize the caching options available in the lookups so that you save on re-querying the database to perform the lookup value. Just remember...

Is this just for an initial load or are you loading 2M rows on a daily basis? Are you using SSIS 2005 or 2008? Here is a posting...

So you don't receive the error every time correct? Just on certain days? What is the difference in the output? Is there more data where you would...