Peter,

Not sure if this will do exctly what you are after (I ran out of time trying to work up a sample cube similar to yours), but I'm hoping it...

Hi Pete,

I have a suggestion, that is not actually a direct answer to your question.

A quick solution to this issue would be to add a flag field to...

Just on the calc member, what error where you getting? I just took what I created as a session calc member (ie what i posted last time) and put...

Hey Al,

Keith is spot on, I know the reasoning behind your project, but one of the most important things I've ever learnt in doing BI consulting is horses for courses....

Have you thought about using the firstchild and lastchild functions?

Excuse the gumby names on calc members, but the following is equivalent to x <= 1997.July and y >= 1997.april

WITH

MEMBER...

Steve,

One way (not necessarily the best way) is to add the msmdsrv.exe process to your perf view (ie it's under the "process" counter type). Then add the Private Bytes...

Hi Michael,

I can't think of any. Possibly a requirement for a few more indexes on the table to make it perform in all of it's roles? Other than...

Michael,

We have recently had a similar problem. In short, we had dimensional data that relied on a Business Unit for unique identification. So for e.g. we had a...

Michael,

Keep in mind that those customer attributes were introduced by me (evil steve ), they may not actually exist!

Steve.

I'm not sure if you want all of the customer groupings in one dimension. If a customer can belong to more than one group, and the dimension is a...

Calculated cells shouldn't increase the size of the cube at all, they're calculated at run time, so only the formula is stored. I would suggest looking into BOL for...

We had a similar issue when trying to warehouse and then report on data from Casiosoft's MobileLink software. We basically created a cube per job. In some ways,...

If you're using "old"/classic asp to produce reports, why not use adomd directly to query the AS server?

Depending on the requirement, if you're into using beta s/w, the beta for ADOMD.Net is out, which would remove any interop issues.

The whole pass through query thing works a bit...

Alan,

Not sure if this helps but you could try something along the lines of

WITH

SET

[Good AND Pearl Stores]

AS

'FILTER(

...