Hi All,

I am getting below error when I am selecting all members of
the dimension. It is the largest dimension among others. My query is
very simple. An example is given below :

With Member [MyDimension].[SelectedDimension] as
'AGGREGATE({[MyDimension].[Dimension].MEMBERS })'
Select NON EMPTY ( {[MEASURES].[Sales Value]} ) ON COLUMNS ,
NON EMPTY { Distinct( { [Customer].[Customer].Members

This query is throwing below exceptions:

Source: Microsoft® OLE DB Provider for Analysis Services
Message: The operation requested failed due to timeout
Stack Trace:
at
System.Data.OleDb.OleDbCommand.ExecuteCommandTextE rrorHandling(Int32
hr)
at
System.Data.OleDb.OleDbCommand.ExecuteCommandTextF orMultpleResults(tagDBPARAMS
dbParams, Object& executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommandText( Object&
executeResult)
at System.Data.OleDb.OleDbCommand.ExecuteCommand(Comm andBehavior
behavior, Object& executeResult)
at
System.Data.OleDb.OleDbCommand.ExecuteReaderIntern al(CommandBehavior
behavior, String method)
at System.Data.OleDb.OleDbCommand.ExecuteReader(Comma ndBehavior
behavior)
at System.Data.OleDb.OleDbCommand.ExecuteReader()

1. What will be the reason for this exception?
2. This is not connection time out issue. I wanted confirm that since
there is lot of data being fetched from olap database the system is not
able to complete the operation. Hence the exception thrown.
3. This is dynamic query. Meaning query will be generated at runtime
with selected measures and dimension and applying filters selected. Is
there any other way of writing query so that performance is improved?

Raghu