you could always post it to sqlwish (i think its sqlwish@microsoft.com).  Possible probs with this are that whoever is administering your sql may not have admin rights on your...

If the data isn't going to change (ie you can warm the cache with the intention of every user accessing the same data from within it) thinking about this, you'd...

I've not tried this but I'm assuming you could try to warm the cache - ie schedule a run of the report/s at (say) 6am so that the data is...

It looks like the sqlagent job name is the guid actually used for the schedule stored within the database.  Since the app (i.e. RS itself) will be relying on this,...

Not sure if it will help but I think the guys at ssw had some instructions/ideas for setting up a public and private (admin) sites for managing the RS server. ...

Hey megan,

From what I can tell, if your parms don't have some one-way dependancies (like Country to State, State to City; Category to Sub Category etc etc) then you'll prob...

What you've said here changes things a little. 

If you want a copy of the cube but want it to have a subset of the data available within the fact...

I am pretty certain it's from your report server.  For me, the cab file (downloaded to the clients) is found at C:\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\bin\RSClientPrint.cab

Cheers,

Hey Megan,

If you go to the parameters dialog box (right click the black square at top left of/in design view and select parameters) you'll see your report parms.  There should...

You still have to process the cube (same as with copy|paste). 

Noelia, I think the short answer to your question was no, there isn't any other way in AS2000

The archive and restore is at the database (catalog) level, so if you wanted to restore just a single cube, you'd end up over-writing all cubes in the catalog.

Hi Steve,

You have quoted the entire statement? e.g. ="SELECT {[Gender].Members} ON 0 FROM [Sales]"

Then when you want to us the parameters you end quote, use the ampersand to put the...

Hey Steve,

You should (in theory) be able to do this (dynamic query) with any datasource.  I'm guessing that the area requiring a mod is not the datasource but the dataset...

You could tyr the DSO-XML converter but I think it's still an unsupported tool.  Basically it extracts all objects using DSO to XML, you then modify the XML and then...

If it's meant to be a static type report, could you try setting the mdx through VBA?