Okay, now I get what you are looking for. That is a little tricky, but it is doable as long as you have some additional information in your date...

For a typical year comparison at any level you would simply using the following:

[MEASURES].[GC GSV Finance LY]

AS (

ParallelPeriod

(

...

Here is how you can get at the RDL for the report in the Content column. Once you have done this you can query this information to look for...

Very nice article and great job on the reports. Wasn't sure if you were aware of it at all, but with the SSRS Samples on CodePlex there is an...

So you installed SQL Server 2005 Standard on your PC? Do you see that in your list of Services running on your PC? When you did the install...

Not sure how you have this setup or what tool you are using to return these results, but if you are just querying the database you could do something like...

Yeah, starting with SSRS 2008, SSRS is no longer leveraging and dependant on IIS. It leverages http.sys. You still access it the same way as you did before...

PerformancePoint Server (PPS) 2007 stopped being a standalone product back in April 2009 with the January 2009 announcement that Microsoft made last year (http://blogs.msdn.com/bi/archive/2009/01/23/microsoft-bi-strategy-update.aspx). Customers that have SharePoint 2007...

You are using BIDS 2008 to create SSIS 2008 packages to deploy to a SQL Server 2005 SSIS server and that will not work. The only product in BIDS...

I wouldn't say that SSAS is an alternative to a relational data warehouse. SSAS compliments it and would be a natural progression. It does require a different skillset...

The typical basic steps would be:

1) Gather Requirements

2) Dimensional Modeling

3) ETL

4) OLAP Design

5) Front-end BI Delivery

With SSRS you are going to have to build your own drilldown functionality unless you...

Depending on how your data warehouse is setup this could really compliment what you have and provide a very robust analytical platform. SSAS provides a way to centralize all...

You need to change the format of the value coming into SSAS, so you would do this either in a database view or in the data source view.

Are you trying...

You could also use a CASE statement and evaluate the PostalCode field like the following:

CASE WHEN LEFT(postalcode,2) like '[A-Za-z][A-Za-z]'

THEN LEFT(postalcode,2)

WHEN LEFT(postalcode,1) like '[A-Za-z]'

THEN LEFT(postalcode,1)

ELSE NULL

END

If you have a FK relationship between the two tables then it sounds like you have what I would consider a snowflake design possibly. You can pull the table...