re: the sample not having quotes - it's the same for the rowset sample, copy and paste it exactly and it doesn't work, quote it (ie dbl quotes) and it...

I think you definitely need the statement in quotes.  Are you testing using Analysis Manager? If so, it looks like it may not support the dataset action return type.  change...

Hi Matej,

What syntax are you using for the dataset query?  I did a quick test and it looks like it won't accept an MDX statement unless its in a string(ie...

Hi Tiago,

It's not really a direct answer to your question, but you could try using the Excel Add In (Microsoft Excel Acellerator for OLAP or something similar).  A new version...

Paul,

You could do the following to check your MMC, see if any errors are thrown on trying to add the AS maangement console.

Go to Start|Run, type mmc, hit enter.  MMC...

Unless you run Kerberos you will need to do this.  The main issue encountered is the 'double-hop' where your credentials are OK'd by the IIS server but then (ssuming AS...

You should turn processing logging on (i think it's in the server properties).  This will then let you get the SQL that's being passed to your data source.  Assuming the...

Some other neat/cool features to consider:

• SSIS (ie the new dts) can let you load directly to a partition, ie no need to 'process' the cube
• SSAS (ie analysis services) now has...

At a guess I would say it's the unprintable characters that are causing you issues (see the 'boxes' in the string).  It's hard to tell from the error message plus the...

Hi Bruce,

If you look at the cube object in the repository (so Class = 9), right near the end of the XML will be some Command elements, within these will...

You could write something to extract it from the repository (it's in xml, not too hard to do).

Alternatively, you could use the cube documenting Word template (olapscribe). This documents entire...

Not saying this is the best way but it is 'a' way...

Make the two subsequent parameters queries that look like the following (BTW, can't remember whether dynamic queries use IIF...

I just followed their quick walk-through, works a treat.

The simplified steps are:

1. create a new datasource, set it to XML type

2. in the conxn string section, set to web service...

Did you install the 2005 documentation with your local install?  I did a search for (without the quotes) 'web service data source' filtering only to Reporting Services and it returned...

Graham,

I would have thought that the time dimensions would be a very small part of your processing overhead?  Even with 10 or 20 years in the dimension, holding data at...