Yeah, they didn't make this very obvious in AS2K5.

When you look at the dimension in the dimension editor, by default, all of the attributes will have their relationships...

You have created the attribute but not the User Hierarchy You need both.

The attribute (whose values will be 1 or 0) and then a user hierarchy (again...

the good folks @ msdn already did this for you. Check out BOL here, there's a full sample.

Not sure i'm following the problem here :hehe:

Your cube has raw data? So it's truly summing up actual sales, which means in your example, the actual sales made was...

Do you have *any* column names? ie is Col1 a cloumn name that exists in the data, or more a way t convey to use it's the first column?

If...

Another approach would be to use a for-each loop over the files. Within this you have a dataflow, and within the dataflow you have an excel connection (source) and...

Have you kept running through the wizard? From memory the P/C 'question' screen is at least 5-7 screens in to the wizard.

Yes, you can create packages programatically (see here)

Depending on your requirements, you *may* be able to make the package dynamic enough that it can be build and then modify itself...

I would guess it's not working the way you have it currently as the target datatype for the parm is a varchar, so SSRS is likely stringing the selected parm...

Hi Robert,

Quick qn - when you do an Explore Data on the source table for the dimension, does it return the data as you'd expect? everything looks ok there?

@dk -did you read the blog post? It contains a concise example (2 actually) of where one might use checkpoints and also includes implementation details.

@pradeep-2, different type of checkpoint (another case of MS re-using names :hehe:)

@dk - It's a little dated now but Jamie Thompson gives a nice overview of usage here.

Hey Bob,

Just to confirm, in the datalayer (ie table or view) do you have a seperate column for each name you want to assign to a key?

So where you have...

Hey Robert,

Everyones a newbie sometime & at something 🙂 (is that a song?)

ok, glad you posted the image, makes it a lot easier to talk around.

First thing, let's get the...

Hey Robert,

I think we've got a nomenclature disconnect 😉 It sounds like you don't have any custom rollups, just standard 'sum' for everything, where Territory rolls in to District...