Hey Jules,

NOt sure I'm following 100% but onthe cascading params side, normally this would be done within RS.  That is, you the order in which the parms are shown on...

As per Jay, I would definitely be looking at using partitions (probably many, many partitions) to load this up.

Hey Jay,

Haven't fully digested what you've written yet but it did remind me of something I read once where I think the AS processsing log goes into the DTS log...

You should be able to do this via DSO (Decision Support Objects) whih is a COM interface (ie a bit easier with VB6 than .net unforunately).  You would want to...

Hey Fintan,

I just ran a v.quick test against foodmart and it looks like your filter can be from a dimensional table.  One thing to watch out for here though is...

Hi all,

Are you truly trying to create new cubes on the fly or are you more interested in writing queries against existing cubes but with strict filters against the dimensions? ...

^bumped^

Hey Jay,

What does the processing log tell you (ie if there isn't an error raised, does it actually indicate that it ran through...

Hi Troy,

Could you try rephrasing what you're trying to do because I can't see the relationship between the acct dim and the 'defined_number'?? 

Cheers,

Sounds v.weird.  The msmdarch was never a great piece of software though it's always worked for us.  If you're not planning on moving to AS2K5 anytime soon, you may be...

Have you added the log file parameter and reviewed it's contents?

We recently implemented something similar but used a standard 'if' statement to make the switch.  I am looking to mod this to use a case statement (rather than nested "if's")...

I didn't think you could open it within the same (IE) window as it's a .net client-side (i.e. thick client) application?

Hi Yaniv,

Nice intro article.  It is quite similar in parts to the Project REAL doco but offers some good advice on how to avoid issues when trying to manage your...

Assuming the error is not 'in error', what this means is that a parent within a dimension has two children with different key values but the same name.  As an...

Hi Ben,

Yeah, not a nice feature reduction, but I musta dmit it is more in line with an academic approach to building your cube/datamart (ie you shouldn't be building the...