Thanks for ur replies,

My syntax in MDX query is fine . I have tested the same query after Printing the statement in Analysis Services Application..It returns me a resultset.

The...

Thanks for the reply ,

But unfortunately it still not working i tried following execute statement :

exec ('SELECT a.* FROM OpenRowset(''MSOLAP'',''DATASOURCE="RAPID-CHRISTUS"; Initial Catalog="MRS";'',' + @mdxqry + ') as a')

I get error...

Finally after a lot of R&D i found one solution here it is :

with member

[Measures].[CloseBal] as '([Measures].[Savings Portfolio],

   ClosingPeriod ( [SavingsBalanceDate].[Day], [SavingsBalanceDate].CurrentMember))'

member

[Measures].[Savings Balance] as ' CoalesceEmpty(

([Measures].[CloseBal], [SavingsBalanceDate].CurrentMember),

([Measures].[Savings...

am facing the same problem, has anyone been able to find a solution to the same.

is it a known bug with SRS ?

Hi Steve,

Can you please let me know how can we actually apply the second method i.e drag the measures that you have suggested. That is exactly what we want to...

Thanks Steve for the prompt reply . Rewriting the query using filters and Descendants functions solved my problem.

shuchi.