SQL BI

My Experience - Troubleshooting SQL BI Stack

Browse by Tags

Tagged Content List
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: 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...
  • Blog Post: MDX: EXISTING

      By default, sets are evaluated within the context of the cube that contains the members of the set. The Existing keyword forces a specified set to be evaluated within the current context instead.   with member [Measures].[k] as ([Product].[Category].currentmember, [Measures].[Measures].[Reseller...
  • Blog Post: YTD Based on Current System Date

    with member [Date].[Calendar].[currentyear] as aggregate(ytd((strtomember("[Date].[Calendar].[Date].&["+format(now(),"yyyyMMdd")+"]")))) member [Date].[Calendar].[prevyear] as aggregate(ytd(parallelperiod([Date].[Calendar].[Calendar Year] ,1,(strtomember("[Date].[Calendar].[Date].&["+format...
Page 1 of 1 (6 items)