Microsoft® SQL Server® 2008 Analysis Services Step by Step (Step By Step (Microsoft))

Microsoft SQL Server 2008 Analysis Services Unleashed

Delivering Business Intelligence with Microsoft SQL Server 2008

If you have it running in integrated mode then you can go ahead and create a report library and deploy reports, data sources, models, etc. to SharePoint and run and...

What is the Protection Level set to on the SSIS package? I would make sure that you have not left it at the default and that you setup the...

I understood the question and provided an alternative if Excel is not cutting it for them, but the best alternative if you are sticking within the SQL stack for end-users...

On the Report you can set the Language Property which is in the Localization section. You will place the language code like en-GB in this property. You can...

MDX is not like T-SQL, so not sure what you are looking to accomplish here. You could setup a linked server in SQL Server and utilize OPENQUERY and setup...

Can you provide the MDX statement and the calculation or expression that you are trying to add to the cube? I am assuming you have created a calculation and...

Did you have a question in regards to using KPI with something? SSRS, Excel, PerformancePoint, etc.?

I do have a posting and video here in regards to using KPIs with...

Are you sure the data is sorted properly? If you are using an OLE DB source and are sorting the data when it is coming in then set the...

You would just change the number of periods that you want to go back from 1 to 2 or 3.

So this would go back three years for what ever member...

Yeah, if you want to do this on your own you can utilize the AMO and take a look at the samples out on CodePlex that are setup. There...

Have you tried SqlSpec?

http://www.elsasoft.org/[/url]

Great tool and very affordable. Try it out and you can also look at the samples.

http://www.elsasoft.org/samples.htm

If you have the data stored in a table and want to do some predictions then the quickest and easiest way for you to do this (assuming you have an...

Yeah, as I stated, if you are using text for the key column also then you are going to have issues referencing the key or name column for your calculation...

Looks like you have an extra period (after Payroll) in the first item you listed and in regards to the other item you are going to need to evaluate your...