A couple of additional items to look at re: memory et al (from the *new* distinct Count doc on Msft web site).

Other analysis services settings: Under the Analysis Server Properties...

Hi Michael,

We've experienced similar 'issues' in build times/speed. There's a few settings that you can mod wrt registry memory settings, I'll have to talk with our guys and re-read...

Hi Michael,

A quick guess on your data : Are you trying to get a count of "visits" where a visit is defined to have occured only on the first episode?...

Marco,

I haven't had a chance to dial-in and look yet, but from memory, for one of our clients we have gone the separate cube per distinct coutn measure way. ...

Mike,

You'll definitely want to add the Time dimension that Mark suggested, without this, any students that repeat a grade(incl exams) will skew results when looked at from a summary level....

Further to last post, Richards thinslicer is at http://www.thinslicer.com/ .

And just a generally useful site is Mosha Posumansky's (one of the MSft AS/Yukon AS guys), has some interesting...

I heard Richard has moved to the West Island and is now living in Syndey (Aus)?

steve.

Hi Hirek,

We're hoping to sell into the US shortly, we're just working through the logistics.

Not quite sure I'm following your question. Are you having performance issues on the client side...

Hi Marco,

Apologies for the mix up in locations. Thanks for your comments on our product, very much appreciated.

Regarding Distinct Counts, in our calculated measures (in reports Versus in cubes)...

I know it's probably a typo, but you did checkthat the user was a member of the 'OLAP Administrators' (ie not 'Administrators') group?

Assuming the answer is yes, then the other...

Hey B,

In order of your questions/statements...

Yes, the set of tables (that can be arranged i a star-schema) are your data-mart ( a philosophical of DM Vs DW isn't warranted here...

[Warning! Warning! Shameless Plug Ahead!]

Hi Marco,

We have produced a Microsoft Analysis Services anlaytical & reporting application. It's a .Net web application, yet to be sold into the US but...

In most cases, people want to have a data mart (or warehouse) because of the flexability it offers them when looing to report on and transform their data. If...

Hi to anyone still reading this thread. Received (very important) information from MSft late last week regarding the "Execution Location=3" setting. If you *do not* have SP3 on...

Hi Ryan,

A couple of things to take a look at....

1. If you *are* trying to set the MDX compatability property, ensure oyu're setting it to a valid option ([0, 1]...