Jul 6, 2015 · I am hoping this is a simple one. I have a Calculated Member in SSAS that I need to adjust based what the current member is. The code is below

Feb 14, 2013 · I wanna put "1" for all duplicate values and for rest of them it should be Zero.

Jul 10, 2009 · I came accross a problem recently. I would like to extract the value of the key [KeyColumns] property. I done this without any problem when the collection just contains one field. I …

Jan 18, 2013 · MAX () and TOPCOUNT () function both needs 'Numeric_Expression' argument but I need to pull latest date without using any measure.

Dec 16, 2014 · I have dimension with 5 hierarchies as shown in the attached screen-grab. Is there a way to get all the hierarchy name for a given dimension (in the below example WDI_Ctry) using MDX …

Jan 23, 2018 · The "30 Jun" parameter value says the YTD ends on the 30th of June. how do i do this using the YTD function in MDX. i think it only calculates year to date values from January ?

Feb 28, 2012 · I’m trying to rank a measure between Levels in the SSAS-cube. I’m using SQL Server 2008 R2. I have a Hierarchy Sales Market with two Levels Area and Location Code. I want to Rank …

Jan 25, 2012 · The client only wants to select one week, and the 4 previous weeks must display "automaticaly". My Calender dimension is [TIME]. [Calendar]. [WEEK]. How do I calculate sales of …

Oct 10, 2016 · Do you mean writing MDX queries to get data from SSAS multidimension mode cube into Power Pivot data model? Power Pivot engine itself supports DAX queries but not MDX.

Mar 24, 2015 · Then I start SQL Server Profiler in background and press ``preview`` to get the query result.