Did you restart the AS service after changing the querylog frequency setting?  It only gets read from the registry on startup of the service.

Hi Mark,

Two things I would suggest initially, download the SSABI (SQL SErver Accellerator for BI) and fire up the Partition Aggregation utility, it will show you what level in what...

How are you determining that there are no aggs being created against the p-c dimension?

The small number of aggregations for the test cube is likely to be a product of...

You would think so, the difficulty (as always) will be extracting it.  The closest I can get is the following script which will let you change the server that each...

Off-the-wall-question, what size is your 'Large Level set to? The default is 1000 and if a level has greater than 1k members, then not all the members (meta-data) are downloaded to...

A few quick tests on my local (dev Edn, using HR cube, focusing on P-C dim for Employees) showed me the following:

1. Set P-C dim to leaf members only, AS...

The datasource string is kept in an *.oqy file.  They're usually found in your Application Data directory under your documents and settings e.g. C:\Documents and Settings\steven\Application Data\Microsoft\Queries

You should be able...

There are two go-forward options, one that could help you now, one that could help you in the future.

If you use the DSO-XML conversion utility, you can extract the DSO...

You can archive the catalogs (into cab files) and then back these up (this archive can be done manually or via a commandline tool), or alternatively backup the data files...

You could always turn the logging on whilse you build your report.  Find the *.oqy file and set the log file property.

The oqy's are normally found in your documents and...

Although most of my testing in the beta's was focused on the Excel OLAP accelerator, I've not put it into production anywhere yet. 

Lately I've been looking at the Business...

Adrian, obscure question time, you havent by any chance got IBM Office Connect installed on your machine?  If you have, you could go to http://www-306.ibm.com/software/data/informix/pubs/library/notes/relnotes/relnotes-ocae4.html and try the suggested fix.

I will try to find it again but there is an article/whitepaper/preso from MSft (i think) that details when/why calculated members resolve on the client rather than the server.

Getting to...

I would check the query next (ie get the mdx and test it in the sample app).  Is the query using extensive calculated members, or anything else likely to draw...

Can't honestly say what the values should be, but I would have thought the property name used should be 'Safety Options', so included in the conxn string like 'safety options=<value>;',...