Hi Maria, While you have users nested within the months, i don't think you'll be able to get the ordering the way you want it. I'm not sure how you...
I think the problem is that you'r enot actualling calling a set or member, you're referencing a level. Try changing the mdx to something like...
I think the ops guide (see links posted earlier by Raulie) indicates that using integers /numbers for keys is better than varchars/chars, which is a...
Hey Aviel, us Aussies are quick on the up-take, and you're obviously quicker than me! HTH, Steve
Could it be a job that was passed from a Master server to your server? if so it may require deletion from the master prior to being able to remove...
The links you should look up on are: Parallel Processing Utility:...
As far as I know there is no way to view execution plans. The setting for 'process buffer size' affects the size of data 'blocks' (using quotes as...
You should look towards replication or log shipping. There are advantages and disadvantages to both, and in a textbook view of what ypu've...
forgot to mention -> are you monitoring your own machines performasnce too? This will definitely have an impact as PTS is affected by what your...
To get multi cpu performance from AS you will need to have i) partitioned your cubes; and ii) be running queries that access data from the multiple...
There is a 'tool' from MSft for SQL2K and AS called SSABI (usually said 's-ah-be' and stands for Sql Server Accellerator for BI - business...
is the cube processed? Right-click it and select Process and follow the steps in the 'wizard'. Are you able to Edit the cube? (Right click and...
It may sound obvious, but have you checked your Event Log for messages? ie run out of disk on the drive holding the temp/building files that AS uses...
A couple of things to alwys check re:connectivity. Ensure that you have provided users access to the cubes either via roles (preferred method) or by...
quote:Originally posted by Irfan Najmi I don't have msolaprepository$ in my C:Program FilesMicrosoft Analysis ServicesBin directory. What can I do...
We've had cubes 'corrupt' on occassion, which has led to similar behaviour. Normally this occurs when the Repository hasn't been migrated to MSSQL...
Hi Aviel, Have you recently put Sp3a on the AS server? If so, you might want to look at the readme for it again, as it makes a direct reference to...
Hey Revi, When yuo say that grouping doesn't meet your needs, what did you mean? Do you not like the way it is implemented? Steve
Separate names with a comma.
