Cracked it

Here is an example of the code used. It is for a different query to the original although it does pretty much the same. The original query is on...

Finally cracked it; used LastPeriods(@LagMonths,StrToMember(@FirstDate))

Thank you for your help

Brian hi, edited the query as follows

With Member [Measures].[Measure1] As [Measures].[PI002 Rent Collection Ratio RAT (%)]

Member [Measures].[Measure2] As [Measures].[Value Rent Period Debit]

Member [Measures].[Measure3] As [Measures].[Value Rent Period Receipts]

Member [Measures].[Measure4] As...

Brian hi, thanks for getting back to me I appreciate your help. I edited the code but without success; did I do it right?

The view returned is to show the...

Hi, I'm using 2008 r2 which only supports the use of the order by clause in ranking functions

Bah humbug!

Hi, thanks for the response, it's not quite what I had in mind as I was hoping to use SSRS functions to present the data on the face of the...

Sorted

I have edited the stored procedure used by the detailed, relational report to strip out the values needed instead of relying on SSRS functions

Now the complete list of fully qualified...

Mack, thanks for taking the time to respond

In essence what I am trying to do is pass the parameter values from one report to another

The first report queries an OLAP...

Cracked it

The level name was identical to a member name consequently the MDX was getting itself mixed-up

Changed the hierarchy and level labels and loo and behold, it all works

Hi, thanks for the response

The error only occurs when browsing in the dimension editor of BIDS

I did use the profiler and carriedout the query is MSSMS and Excel.

In these environments...

Nicholas and MysteryJimbo, thanks you for your responses, just what I needed.

Lutz hi, thanks for the response.

It has to be an SP, so I'm going to research your suggestion of WAITFOR DELAY and see what transpires.

Thanks.

Frank hi, thanks for the response.

The service account is a domain account that runs the various services; SQL Server and Analysis Services included. This is enabled 24/7.

The account that is...

Hi, thanks for your input.

Unfortunately I do not have control over the calendar as this is the option chosen by the client.

The function is being used to calculate a cumulative...

Hi, is the Report Model you are running your reports against generated from Analysis Services or SQL Service database?

Also, can you give an example of the filters you wish to...