Zip file attached with the project / solution.

This is provided as is and I would strongly advise testing in isolation first. Not that there should be any problems.

Fitz

Comes down to whether you want the ratio of the current_AR to total_AR at all levels or the ratio of the detail level averaged at each level. The values...

It looks like you are using a matrix and want to dynamically merge columns. I don't believe this can be done (would love to know how if it can)....

You will need to combine the two calculations : (parellelperiod and current member to make the set within the AVG function).

WITH MEMBER [Measures].[Last 6 Members Average] AS

...

The answer will probably be along the lines of writing MDX within the cube design to add a set to the cube to show only the members of the dimension...

How about :

=IIF(IsNothing(Parameters!CUST_CODE.Value), "All" , "Report : Parameter value is " + Parameters!CUST_CODE.Value )

Fitz

Assuming the data driven subscription is based on something like below.

CREATE TABLE dbo.Subscribers(

EmailRecipient varchar(100),

Format varchar(20),

ParameterValueX varchar(30)

)

1. Keep the...

You do not state the context of the query (SSAS cube design calculations tab, SSMS query or SSRS report dataset)

----- SSAS Scoped assignment

DECLARE MEMBER CURRENTCUBE.[Measures].[PercentRoot-Scoped]

AS "N/A",...

Using the chart you have at present (with the filter / dataset parameter removed).

Set the following SSRS expressions : (guessing the column names but you will get the gist)

Group on...

Quick and dirty solution which would not scale that well but works as below. You may want to investigate

CLR concatenate aggregate[/url]

declare @a table (Linenumber int, ErrorText...

Taking the original query as below the TerritoryID is numeric. The workaround you suggested with convert(varchar(xx),TerritoryID) would work but may cause issues with sorting the 'ALL' into the correct...

When using the matrix (pivot) style the row and column groups automatically set the group by and the sorting by properties for the group.

To retain the sort order...

Please refer to the connect entry listed below. It is still Active.

http://connect.microsoft.com/SQLServer/feedback/details/428595/keep-together-property-not-working-in-ssrs-2008

fitz

----------

Without distinct the result is:

311793 3:12

312184 3:13

312184 3:13

312373 3:04

Total: 12:42

.. but I want only values for distinct ID's to be added:

311793 3:12

312184 3:13

312373 3:04...

If you want to produce a join like structure between the two datasets then either:

- create a join within a single dataset if the sources are compatible (i.e. both from...