Hey Marianne,

Hope i'm not overly simplifying the problem, but could you just set the visibility (hidden) for the source measures to not visible (hidden == true)?

This won't make them inaccessible...

Check the job log (assuming it's actually erroring), also check to ensure SQL Agent is actually running.

You could possibly utilize the Except function [EXCEPT( )]. You'd probably want to create a named set for the top 10 initially, then use that as the excluded set...

I know it's not a prescription per se for sizing (and it's a little dated now, has nothing newer has come through?) but could give you some food for thought...

You might find some useful examples in the walkthroughs from Bill P (here), look for articles 31 & 32.

HTH,

Most of the major hardware vendors have sizing tools (Dell here, HP's here [apparently needing registration :S hmm]). For the devils advocate-side of using the sizing tools,...

Hey Ben,

The problem i see here is that this case doesn't require a role playing dimension - it's really not going to do what you want it to (or think...

Hey Ben,

I think the problem is not so much with your implementation as your data. You mention that you have two fields (dimFilterProgramID and dimProgramID). Now, i'm not...

Chris Webb (an authority on MDX, definitely try to get a hold of one of his co-authored books!) has an example here. If you're using AS2K5, then you can...

Could you possibly have two parts to your statement - use IF statements to determine the current level for that dimension and then direct the execution down the correct statement...

Not sure if you've looked at these but following are a few suggestions as to how to fix the issue.

one here

and another here

One recurring them appears to be this is...

I think a combination of script task and also setting the file (at least for an initial pass) to be ragged right.

One way to do this might be:

use...

Hey Chris,

I have a copy of the BI Samples files in a zip, PM me and i will mail them to you directly.

Cheers,

Hey Chris,

A not for free approach -> BI Documenter

This is an absolutely huge download, but it does include the metadata samples you referenced. Not sure if it has the...

Hey Rick,

I was going to write and suggest that perhaps these really belong in two separate dims which reminded me of the many-to-many paper that Marco Russo wrote. It's...