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: 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…

0

MDX Descendant Function

This example shows how to use Descendant function with Desc_Flag as self_before_after which means this will show all members at level – Subcategory_Category_Product. and to prove that we are getting correct result I am using Member Property – Level which shows Level Name to which Member Belongs With Member Measures.ProductStatus As [Product].[Status].Member_Key Member Measures.Levela as…

0

Connecting Project Server with SQL Analysis Services from External Domain.

  Environment Domain A Server A – Project server and Web Server Server B- SQL Analysis Services server Domain B Clients  / Users Users accessing Project Server via. HTTP Domain Relationship Both the domains (Domain A & B) are on Intranet but don’t have any trust. Solution In this Scenario where IIS Server and Project…

0