PowerShell: Getting Cube XMLA

Problem Description: Automate the steps of 1. Connecting to SSMS 2. Select Cube 3. Right click and generate XMLA “Create Cube” 4. Schedule from SQL Job agent For last few days I was playing around with PowerShell so thought of achieving this using PS. Code which I wrote for getting cube Create XMLA is: [System.Reflection.Assembly]::LoadWithPartialName("Microsoft.AnalysisServices")…

0

SSAS Cluster: Issue with Mount Points while Performing Administrative Tasks

  Issue: Environment consists of 2 nodes, SQL and SSAS 2008 can failover between the 2 nodes, and accessible for queries. All the drives and mount points come online on the nodes after failover. SQL Server Fails over perfectly. The Windows Cluster has been validated and no errors in the log. When failover from Node…

0

MDX:Handling division by zero errors

WITH MEMBER [Date].[Calendar Year].[2006VS2007] AS [Date].[Calendar].[Calendar Year].&[2007] / [Date].[Calendar].[Calendar Year].&[2006], FORMAT_STRING = ‘Percent’ SELECT { [Date].[Calendar Year].[Calendar Year].&[2006], [Date].[Calendar Year].[Calendar Year].&[2007], [Date].[Calendar Year].[2006VS2007]  } * [Measures].[Internet Sales Amount] ON 0, non empty {([Product].[Product Categories].children ) } ON 1 FROM [Adventure Works]   If you notice where Value of Internet Sales is Null for Base Year…

0

MDX: Nonempty v/s NonEmpty

Nonempty Returns the set of tuples that are not empty from a specified set, based on the cross product of the specified set with a second set. NONEMPTY(set_expression1 [,set_expression2]) set_expression1 A valid Multidimensional Expressions (MDX) expression that returns a set. set_expression2 A valid Multidimensional Expressions (MDX) expression that returns a set. In this example, getting…

4

Top 10 products with Lowest Reseller Order count of at least 400.

  This shows how to use Head, Order, Filter & TopCount Function.   Reseller Order Count Classic Vest, S 514 Short-Sleeve Classic Jersey, XL 495 Hitch Rack – 4-Bike 468 AWC Logo Cap 460 Long-Sleeve Logo Jersey, L 451 Water Bottle – 30 oz. 444 AWC Logo Cap 442 Women’s Tights, L 437 Long-Sleeve Logo…

1