Display # 5 10 15 20 25 30 50 100 All

How can I get a list of Analysis Services databases on the server using XMLA?

Written by Vidas Matelis on 22 May 2007.

How can I get a list of cubes in one Analysis Services 2005 database using XMLA?

Written by Vidas Matelis on 22 May 2007.

How can I hide dimension attributes/hierarchy in one cube, but leave them visible in other

Written by Vidas Matelis on 13 June 2007.

How can I prevent client submitting MDX queries to the Analysis Server 2005 that run too long

Written by Vidas Matelis on 29 April 2007.

How do I check for division by zero and null to avoid -1.#INF in cells

Written by Thomas Ivarsson on 26 May 2008.

How do I check for the top level in a dimension to avoid division by an nonexsting parent(-1.#INF)

Written by Thomas Ivarsson on 26 May 2008.

How do I create a Rolling 12 Months Accumulated Sum that can show a trend without seasonal variations

Written by Thomas Ivarsson on 30 May 2008.

How do I find the bottom 10 customers with the lowest sales in 2003 that were not null?

Written by Thomas Ivarsson on 30 May 2008.

How do I group dimension members dynamically in MDX?

Written by Thomas Ivarsson on 29 May 2008.

How do I impersonate another user to test the MDX query in SSMS?

Written by Microsoft on 13 April 2011.

How do I move Analysis Services 2005/2008 databases to a different folder

Written by Vidas Matelis on 18 June 2007.

How do you change Analysis Services 2005 measure group ID property value

Written by Vidas Matelis on 24 April 2007.

How do you create distinct count measure in the separate measure group from the same fact table

Written by Vidas Matelis on 04 May 2007.

How do you design KPI goal that is dimension dependant

Written by Vidas Matelis on 29 March 2007.

How do you generate Report Model for Reporting Services Report Builder based on SSAS database

Written by Vidas Matelis on 04 June 2007.

How do you increase timeout for queries executed during Analysis Services cube processing

Written by Vidas Matelis on 23 April 2007.

How do you make Pivot table to show calculated members from Analysis Services 2005

Written by Vidas Matelis on 23 April 2007.

How do you set Analysis Services 2005 drillthrough security on the cube?

Written by Vidas Matelis on 11 September 2007.

How do you setup dynamic security to SSAS 2005 database based on current user

Written by Vidas Matelis on 19 April 2007.

How do you test Analysis Services 2005 role settings impact on browsing / querying behavior?

Written by Vidas Matelis on 11 September 2007.

• 1
• 2
• 3
• 4
• 5