WITH

MEMBER [Measures].[PrevPeriodBalance] AS

Sum

(

NULL : [Period Dim].[Month Name].&[100022]

,[Measures].[Amount]

...

Is your date "[Period Dim].[Month Name].&[100022]" a hierarchy?

This may be a good starting point to troubleshoot your issues:

http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/b5f7c367-1b72-4255-acc5-57d3953c90b7

Seems you have done all the things I would have done already... 😉

I would probably next try to create the resultset in SSMS (Analysis Services) by browsing the cube

Or

Use the...

Have you tried replacing the .Children with .Members (or .AllMembers) via your OLE DB data connection?

You may have to specify an additional scope level like this:

[Questionnaire].[Questionnaire Question Order].[Questionnaire Question Order].MEMBERS

SELECT

{[Measures].[Survey Count]} ON COLUMNS

,NON EMPTY

{

[Customer].[First Name].[First Name].MEMBERS*

...

SELECT

NON EMPTY

{[Measures].[Survey Count]} ON COLUMNS

,NON EMPTY

{

[Customer].[First Name].[First Name].MEMBERS*

...

So if you review your dimension usage in the cube, there should be a relationship type between your Measure group [Questionnaires] and [Customer] dimension.

This should be a regular relationship.

The information...

Your fact tables relating to Questionnaires - do they contain IDs or references to other dimensions?

[[Sorry - of course they do :discuss: - they should have...

If you...

DECLARE @countnotification INT

SELECT @countnotification = COUNT(*)

FROM [SR]

PRINT @countnotification

Change the print part to your netsend command.

Without more information, cant really comment on whether you need a...

Very elegant solution!

I "played around" with the positions but couldnt remove the leading space without this:

Country = LTRIM(SUBSTRING(Col1, Pos1+1, Pos2-Pos1-1))

Does it work if you remove the Questionnaire details from the "On Columns":

SELECT

{[Measures].[Survey Count]} ON COLUMNS

,NON EMPTY

{

...

I have run out of time today but here is a start:

CREATE TABLE CountryFull

(

ItemDescription VARCHAR(99)

)

INSERT ...

Create a role group with read-only permissions and assign users to that role group.

Do you have RedGate's Multi-Script?

If not you may need to create a script which uses EXECUTE sp_msforeachdb

This...

My first piece of advice would be to start off small and add to it until you get the desired results

Also, your assumption is correct regarding dimensionality.

I found this tool...