| Author |
 Topic  |
|
|
fdranguet
France
81 Posts |
 Posted - 09/10/2010 : 10:54:41
|
Hello,
When you create an ODBC link to an SSAS instance, you can set numerous properties to the connection, like "Compression Level", or "Real Time OLAP", "Packet Size"... (http://www.ssas-info.com/analysis-services-articles/63-connectivity/102-analysis-services-2000-and-2005-connection-string-properties).
I am unsure is this is faisable or not, but I would like to set up one of my XMLA URL connection (or XMLA virtual directory if this could be set there) with some of those parameters set (the one I am interested in actually is "Real Time OLAP"). How could I achieve this ?
Thanks !
Regards,
François Dranguet
Scott Bader SA
Ingénieur Système
Développeur BI |
|
|
admin
1637 Posts |
Posted - 09/10/2010 : 22:13:12
|
When using SSAS 2000 and XMLA SDK you can put the above mentioned connection attributes directly into the connections string in datasources.xml (C:\Program Files\Microsoft XML For Analysis SDK\Config):
<DataSourceInfo>Provider=MSOLAP.2;Data Source=Local; Locale Identifier=3082; Compression Level=0;</DataSourceInfo>
When using SSAS 2005+, please take a look at the msmdpump.ini XMLA config file. It provides the following attributes:
<ConfigurationSettings>
<ServerName>localhost</ServerName>
<SessionTimeout>3600</SessionTimeout>
<ConnectionPoolSize>100</ConnectionPoolSize>
<MinThreadPoolSize>0</MinThreadPoolSize>
<MaxThreadPoolSize>0</MaxThreadPoolSize>
<MaxThreadsPerClient>4</MaxThreadsPerClient>
</ConfigurationSettings>
http://msdn.microsoft.com/en-us/library/cc917712.aspx
|
 |
|
|
fdranguet
France
81 Posts |
Posted - 09/13/2010 : 05:59:35
|
Hello,
thanks for your answer, but unfortunately I am using SSAS 2008, and as such I do not have any datasources.xml file to modify. I also searched a bit on "msmdpump.ini" file but I could not find any parameter that would permit to have the same behavior than "Real Time OLAP" set on an ODBC connection to SSAS. Do you have any other idea on where to investigate to solve this ? Many thanks.
Regards,
François |
|
|
|
admin
1637 Posts |
Posted - 09/16/2010 : 06:33:11
|
The Properties element of the Discover and Execute methods allows these properties:
RealTimeOlap
SspropInitPacketsize
http://msdn.microsoft.com/en-us/library/ms186627.aspx
Admin > Connection (XMLA type ) page should be changed to accept these properties. |
|
|
| |
Topic |
|
Report Portal
XMLA connection, how to use AS parameters
