Perfect, with a DISTINCT thrown in there I now have a unique set of records. Just what I'm after.

Thanks heaps.

Hi Peter,

Thanks for the response. I've just rebuilt the SSIS package from scratch and the process dimensions/process cube tasks now work when run through BIDS. Waiting to see...

Hi Michael and Dave, thanks for the responses. I've designed the hierarchies to flow all the way to customer ship-to - a customer may have ship-tos in different states...

You might like to add a named calculation to your data source view. This calculation will be something like "SELECT companyname FROM othertable WHERE thistable.companyid = othertable.companyid'. Then...

Fantastic, I'll give that a fly. Thanks Matt.

It sounds like the post changes method isn't working properly for some reason. If you can retrieve data then your connector must be working OK. I have no...

Thanks for the fantastic response Dave. In the meantime I've stumbled upon Chris Webb's take on this:

http://cwebbbi.spaces.live.com/blog/cns!7B84B0F2C239489A!412.entry

I implemented this way (it's excruciatingly close to what I had,...

Thanks Rakesh. I see where you're coming from, but to me it has a couple of inefficiencies:

1. It means I have to return all those values in the data...

Hi Sanju,

You might be able to use the LastPeriods() function to get this information out - or something close to it. Try something along the lines of LastPeriods(60, STRTOMEMBER(@DateParam)),...

Hi Dave,

Thanks for the tip. I've added a named calculation to the DSV and am using that instead. What are the performance considerations in doing this? I...

I nutted it out using the LinkMember function:

[Measures].[Line Qty] * LinkMember([Current Items].[Product Category].CurrentMember, [Packing Group]).Parent.Parent.Properties("Bottles Per Wrap")

That works, but I've read that the Properties() function is taboo now and another...

Debasish,

You've probably worked this out already, but here's a couple of answers.

1. Your use of the PeriodsToDate function is incorrect. You need to specify a level from the start...

Great, thanks for that.

Thanks for the help people. I tried using Nasir's solution (and it still seems the most elegant) but I kept getting a type mismatch.

I ended up creating a DateTime...

Hi All,

Thanks for your suggestions. I ended up putting a Requery command in the AfterInsert event. I didn't reference it to the form name (which caused all sorts...