I definitely agree with what StevefromOz says...aggregations are the way to go so that you can get good performance with little effort.

Underneath the rapper, Analysis Services pre-calculates various sub-totals for the different dimensions you have in your cube.

It does this so then when you ask for the value of...

Yes - just install Visual Studio (same version as used by BIDS - this changes depending on the version of SQL Server you are using) and include C# as part...

I think that something like the following might do what you are after...

with member measures.AllSalesAmountOfWholeCompany AS

(SUM

( { ( [Company].[All Company].[COMET],

[Stores].[Stores].[Stores]

)

}

...

Your issue may be the same but the resolution is potentially not the best. You should be able to add the new article to the existing publication.

Unfortunately, I...

How about having a look at the info published by Microsoft on how replication works. There is stacks of info available in Book Online, Technet and MSDN. Perhaps...

You need to add the new article to the existing subscription (or create a new subscription if you prefer). Just creating a new article in an existing publication will...

An expression something like

="Report_Name for " & JOIN (Parameters!month.value, ",")

might be what you need

I would not be attempting to execute an external program from within a transaction - there are many potential problems including security (which I suspect may be your current problem)...

For a table to be used in transactional replication it must have a primary key (a unique constraint is not enough). This is, most likely, the cause of your...

try changing the name of the image to

images/logo.png

I think that reporting services is probably attempting to use a path relative to the location of the report and is...

You can do this by adding a custom renderer to reporting services based on the existing CSV renderer.

To do this you need to edit the reporting services config...

Whilst I gaven't had a need to do this, I kinda expect that you could check what values you have for Globals!RenderFormat.Name and base the initial state of these drilldowns...

I think that you would be OK to simply restart SQL Server.

However, to be safe, take a backup of the files on drive E: and F: first (with SQL Server...

To me, Active and Residential seem to be dimensions. Defining them as dimensions means you can easily find info about active residential records etc. If they are a...