Is your EndDate always the same as the PeriodEndingDate? If not, when is it different and what should the value be?

Drew

A big part of your problem is that your data is not normalized. Having normalized data will greatly reduce the need for CASE statements. I was able to...

I find the EXCEPT clause works well in these situations, particularly as the number of columns you want to compare increases.

SELECT *

FROM db1..tbl1

EXCEPT

SELECT *

FROM db2..tbl1

Drew

When running it manually, you are using your...

SSIS bases its datatypes on a sampling of the records (8 rows by default) from the Excel file. If none of the records in the sample are longer than...

First, the parent package CONTAINS the child package. The success/failure of the parent package is not determined until it finishes executing and it cannot finish executing until each of...

You're going to have to use ParallelPeriod(). If you have the week level in your hierarchy, that will probably work best. ParallelPeriod([week], 52, [FromDate]):ParallelPeriod([week],52,[ToDate]). Something like that...

The "Available Values" for your parameter is set to "From a Query". It is this query that you need to change.

Drew

It depends on whether you're querying a dimension or a hierarchy. With a dimension it's easy, just change [Dimension].members to [Dimension].children. For the hierarchy, it depends on how...

It's really hard to say for sure, because so much depends on the actual structure of your cube.

I think that you're probably going to need to reference the .currentmember of...

You need to use StrToMember() to convert your parameter value to a member.

Drew

I think that this is one of the cases where a CTE is much, much clearer. First, it makes it obvious that you are joining the same query to...

You could also use a CTE.

WITH CTE AS (

SELECT

orderlineid

, date

...

mm (9/15/2009)

---

I tried your suggestion Drew and it's what I'm looking for!

Except... I'm getting a 'Incorrect syntax near 'END'.' I'm sure it's something dumb I'm overlooking.

-Michelle ...

Since you haven't posted DDL, sample data, and expected results, I can't test this. Try the following:

SELECT DISTINCT CRM_Orders.TRANSACTION_ID, CRM_StatusCodes.USER_STATUS, CRM_OrganizationalUnits.STEXT

FROM ...