Hi All,

I have the following question:

If I make an aggregated member in an MDX statements and use the subqueries=2 connection parameter, I get the correct result in SSAS 2008 but in 2008 R2 and 2012 just an empty result.

Do you have any explanation for that? hat is the difference between the subqueries=2 connection parameter in the different SSAS versions?

Thanks in advance!

Here is an example query:

with
  member [Dim].[Id].[NowCreatedMember] as
    Aggregate({[Dim].[Id].&[1], [Dim].[Id].&[2], [Dim].[Id].&[3], [Dim].[Id].&[4]})
  member [Measures].[Sales] as
    ([Measures].[EuropeanSales])
select
  non empty ({[Dim].[Id].[NowCreatedMember]}) on columns,
  {[Measures].[Sales]} on rows
from [Cube]

• Edited by Istvan_Szabo Thursday, January 03, 2013 1:01 PM

according to Technet the value "2" for the subqueries connection string parameter was not available for 2008 but was introduced with 2008R2

2008: http://technet.microsoft.com/en-us/library/microsoft.analysisservices.adomdclient.adomdconnection.connectionstring(v=sql.100).aspx

2008R2: http://technet.microsoft.com/en-us/library/microsoft.analysisservices.adomdclient.adomdconnection.connectionstring(v=sql.105).aspx

some more informatian may be found here:
http://technet.microsoft.com/en-us/library/ff487137(v=sql.105).aspx

hth,
gerhard

Thanks Gerhard for the answer.

Interestingly I can use this connection string parameter when connecting to SSAS 2008.

I will read through the links and let you know what I have figured out.

Cheers

I tried Subqueries=1 adding it in Additional parameters, however, seems not working for calculated member when used in filter while pulling in some measure. 

Is there anything you suspect, which I am missing here?

Thanks.