Darren,

The correct (and easiest) way to go about this is to create the necessary roles within the MSAS cube. You probably "could" implement cell level security (join in you data,...

I'm assuming you're referencing a SSIS package (not a DTS package, which is SQL 2000).

Create a new SSIS solution via BIDS.

On the project, Right-Click, Add/Existing Package.

Then you should be...

Chris is always a fantasitic source of information. I used this approach myself a couple of years ago, but ran into some additional limitations. (For example, I have many calculated...

Actually, you can abstract it to the cube. This'll just take a little ingenuity:

First, you'll need a "Slicer" or "Expressions" attribute. This can exists in either an existing dimension, or...

This query is being executed against the [Dim Konto] dimension (German for account). Ok, we're on our way.

I'm not exactly sure, but it looks like you may have defined the...

Analysis Services has a built in function to log queries (OLAPQueryLog). You turn it on via the properties of the server. It collects the database, the cube, user, query mask,...

From the message, it appears you have a problem with your query, not your dimension. The message indicates that you're attempting to call the Children function against a Level. (Invalid...

Of course, good catch!

Try instead replacing the "*" with a CRLF.

P.S. What was the target object by the way?

You're actually deploying from the VS project, not from the Report Server. That's why the project is copied to the QA file server, to maintain tight control over what happens...

Default values are supported for report services reports:

In Visual Studio go to Report/Report Parameters..

(Make sure you click on the report, to make this menu option appear).

As well, you can...

Yes, you can dynamically set the path, but it still needs to be referenced (i.e. client side) to render.

Where is the image, in relation to the report?

I copied out your sample, and got single quotes (') around the *. Try removing that.

Can you give a little more detail? I'm not sure what you're asking for.

First, I'm not sure you're aware, but in Reporting Services, by default you don't overwrite your data source when you repromote a report. Therefore, your production data sources remain fixed...

happycat59 got it eactly right, but I thought I'd add a couple of quick recommendations:

- Consider sorting the list as well, so that the most recent date appears at the...