Are you talking about an MSAS database or the SQL database (the data source).

Assuming you're talking about the SQL database, no, just change / update your SQL connection string. This...

Check your project properties. Make sure it's pointing to a valid AS 2005 server and that you have the necessary rights on that server. It must also be part of...

Try the following:

[Code]

Select DataStreamID, DataStream, DepartmentName, JobRole, Week1, Week2, Week3, Week4, Week5

FROM t_data

Union

Select 99, 'Leaver %', DepartmentName, JobRole, L.Week1/A.Week1, L.Week2/A.Week2, L.Week3/A.Week3, L.Week4/A.Week4, L.Week5/A.Week5

From t_data L

...

You're in the right ball park. As always, how much you buy depends on user expectations, design, size, etc, etc, etc.

Some comments:

- I'm surprised your MSAS database is so small,...

Again, devil in the details. Is this part of a well structured DMZ or part of a firewall senario into your general network? Is you ISA server part of your...

I see this type of problem multiple times, so I thought a bit of an explanaton would help.

You have to remember that Visual Studio and MSAS are separate processes and...

Just add a field to your data source. Assuming SQL (there's a similiar approach for MDX):

newField as Case Type

when 'Owners' Then 'Housing'

when 'Renters' Then 'Housing'

when 'Mediam Price' Then 'Housing'

when...

If you're using SQL Server 2005 (and I highly recommend it), then you're looking for SSIS (the DTS replacement). There's tasks inside it to do exactly what you're looking for.

Alternatively,...

Have you tried a cross tab report, then just turned off the detail rows?

You need to let us know the machine topology you're using as well as the authentication scheme you're implementing (particularly in your "external" case). If you're talking about an internet...

Actually, it's easier than that. Once you have a working report, you can add a parameter to the report, and use it in the connection string to switch environments. (This...

How much data are we talking about here? I guess we'd need to understand more about your specific senario.

Fundamentally, trying to manage your data where MSAS is the primary...

You might be able to accomplish wha you're trying to do, but don't bother. There's way to many senarios where you'll need to do a full process and you'll need...

Ok, I believe you're looking in the wrong area. MDX statements are for cubes, where the basic cube structure is known and fixed.

You're into ASSL development, which is going to...

Jeff is very right of course.

Some comments that might help to wrap your head around SSIS and get going:

- From a design perspective, expect to create lot's of steps and...