So something like below (pseudo-mdx) as a calc'd measure might work?

if ( [TimeDim].CurrentMember.Level = TimeDim.Levels.Month, 

  Sum(

   PeriodsToDate([TimeDim].[Month], [TimeDim].CURRENTMEMBER)

  , [Measures].[Commision]) / [measures].[AUM]

)

With a little more detail of your current cube structure and the current MDX we could possibly add more, but as a first port of call, I would suggest looking...

Just throwing in a couple of cents....  there seems to be a slew of products available (ranging from ~$150USD to $4k USD), try here, here, here and...

Did you work this out Matt?

You might want to review what George Spofford has posted previously on this issue.  He gives three options for including the nulls in your cube.

Not quite sure what you're asking for here....  if you're looking to use the Analysis Services Stored Procedures (in AS2005) then take a run through some of these -->

http://msdn2.microsoft.com/en-us/library/ms176113.aspx ...

As I understand it, (the) SQL Browser (Service) is installed with a default of 'off' if the install is a new one (this is a surface area reduction initiative).  If...

Is there fact/measure data for all of the 103 doctors?  If not, then your front end tool (e.g. SQL Management Studio cube browser, which is Pivot Tables 11.0) may be...

Matt (hope the UK weather is not getting you down) 'Kenno' is right, the role playing dims in AS2K5 should be what you use to sort this out.  In case...

Hi,

I'm assuming that you're using AS2000.  Have you (or someone else) recently upgraded the server service pack level, especially to SP3 for Analysis Services?  If so there was a documented...

I think one of the guys from ProClarity wrote up a doc on migrating from AS2K to AS2K5, it should be accessible from the msft site for AS.  Some (a...

Here here to what Bill said.  TO follow up a little on the tech side, if you're using SQL2005 the partitioning of tables is now even easier to implement (again...

Is there any rerason why you can't create a view to retrieve only the relevant records (from time and fact) and set these views as the source/s for the fact...

Hi Jules,

Can you PM me with an email address that I can send it to?

Cheers,

Hey Jules,

I completely overlooked the 'using RS2005' bit.

As far as I can tell it's a *really* convoluted process to get this to go.  The key piece is to make sure...