Display # 5 10 15 20 25 30 50 100 All

Q: How can I get a list of measures in one measure group from SSAS DMVs?

Written by Vidas Matelis on 21 January 2009.

Q: How can I identify version/build of Microsoft SSAS 2005/2008 on my server?

Written by Vidas Matelis on 05 May 2009.

Q: How can I start Analysis Services service from the command line?

Written by Vidas Matelis on 26 November 2008.

Q: How in DMV can I convert data_type field from integer to string representation?

Written by Vidas Matelis on 20 January 2009.

Q: How in MDX can I override formating for all calculated measures in one measure group?

Written by Vidas Matelis on 03 December 2009.

Q: How to fix error "Error loading metadata: Parser: The end of the input was reached."

Written by Vidas Matelis on 02 December 2008.

Q: How to setup SSAS anonymous authentication - to access data from internet or another domain?

Written by Vidas Matelis on 01 February 2011.

Q: I have measure in my cube that shows duration on some event in seconds. How can I convert numeric result to string in the format hh:mm:ss?

Written by Vidas Matelis on 10 March 2010.

Q: In SSAS 2008 I am getting an error message when generating usage based aggregations: "Internal error: The parameter is not valid."

Written by Vidas Matelis on 08 June 2009.

Q: When I am browsing Real-time ROLAP cube, I am getting error message: OLE DB Error: OLE DB or ODBC error: You do not have permission to run 'SP_TRACE_CREATE'.; 42000.

Written by Vidas Matelis on 13 March 2010.

Q: Which string functions can be used in the queries on SSAS DMVs?

Written by Vidas Matelis on 08 December 2008.

Q: Why on SSAS 2005 after restoring database backup I am getting corruption error?

Written by Vidas Matelis on 23 September 2010.

Q: Why SQL function: ObjIDUpdate() takes long time to execute when ROLAP SSAS cubes are used?

Written by Akshai Mirchandani on 29 April 2010.

Q:How do you map MEASURE_AGGREGATOR field int value in the MDSCHEMA_MEASURES DMV to text representation?

Written by Vidas Matelis on 26 January 2009.

Questions and Answers about SSAS Tabular Models #ssas #tabular

Written by Marco Russo on 07 October 2014.

SSAS error during deployment - "The connection either timed out or was lost"

Written by Vidas Matelis on 06 October 2009.

SSAS FAQ by Microsoft

Written by Microsoft on 29 June 2010.

What are Analysis Services 2000/2005 connection string properties

Written by Vidas Matelis on 26 April 2007.

What are recommended values for the InstanceSelection property in Analysis Services

Written by Vidas Matelis on 08 April 2007.

What TCP port SQL Server Analysis Services 2005 uses

Written by Vidas Matelis on 14 April 2007.

• 3
• 4
• 5
• 6
• 7