Hey Mark,

I've been working on an extremely similar problem. The issue with simply adding additional Parent_Keys is that each dimension in SSAS will allow only a single P-C hierarchy...

Also just noticed, and this may be a copy|paste issue introduced in your post, but...

strtomember('[Date].[Month]' + Strtoset([@DateSet]).item(0) + ']')

*assuming* StrToSet([@DateSet]).item(0) actually produced a string, and it was 'foo'

then you would...

I would be guessing that the StrToSet(x).Item(0) is not returning a string (ie it's returning a member from a set), so tryign to concat a string together with this is...

In the Dimension Usage tab, for the intersection (ie relationship) between the Customer Measure Group and the Date dimension, set the relationship to be Many-To-Many, via the Sales fact table.

So,...

Are the charts contained in Reporting Services reports or are they PPS charts? If the latter, have you connected to the UAT using PPS designer and fired up the...

Yep,...

Just out of interest, are you running this package (packages) in Visual Studio (ie debug) or pushing them to the SSIS service and executing them via say SSMS or dtsrun/dtsrunui?

If...

The row count would/should be ok, i'm just anal about the difference between

and "always 10 rows" 😀

Just FYI, this link may offer some insight on using...

I know it sounds like an obvious question, but any way to get your supplier of the file to mod their output? Let's assume that you work through OPENQUERY...

Um, isn't this what the client is paying *you* to produce?

I know on the flat file source you can specify to ignore/skip n lines, where you get to set n. Is this on the Excel source as an option?...

sooo glad i asked.... :hehe:

ok, on the date dim, you *could* get AS to create you a server based time dimension, where you provide some info thru the...

Am not saying I *like* this (due to having to 'hook' the IsNaN function to the equation, doesn't appear to allow it to stand alone) but it works....

=Iif((Fields!field1.Value / Fields!field2.Value).IsNaN(Fields!field1.Value...

Yep, i think i get what you're saying the intraweek cycles when compared with other temporal analysis.

Am wondering if you almost need to put in another hierarchy, like a 4-4-5...

d'uh, skipped that bit too quickly, sorry.

Maybe i'm going the wrong way here, but am not sure it makes sense to try and force this for use within the existing...