Jul 5, 2011 · I am trying to figure out how to move the filter from the sub-select into a calculated member. I need to query a couple of metrics and each have a different filtering criteria.

Oct 5, 2010 · The above query returns around 4 years of data, but I need the data from first day of the current month.

Aug 26, 2013 · I'm trying to write MDX to import data from SSAS into SQL database.

Aug 1, 2011 · a friend from the team offered i define the IsAggreagtable property for the year to false. i did that and the scope for the year showed correctly. still, i searched the web and i found a different …

Jan 27, 2009 · This means that he can see the MDX for the dataset but for me it doe snot happen being in design model. Now when I try to switch off design mode, the MDX is cleared out. When he tries to …

Apr 14, 2011 · I need to use an MDX report parameter to filter the report so it returns the sales amount for the current month. Currently, we have reports that return data for the current day and also the last …

Sep 26, 2016 · Excel Pivot Table do allow you to create new measures. If you are in the Pivot Table connected to an Analysis service database, go to the Analyze Menu Choice and in the Calculations …

Aug 18, 2010 · I have an MDX query which takes approx 8 mins to execute. Then Further i want the result of this MDX query into SQL table, hence i used OpenQuery but this is taking huge amount of …

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 ?

Nov 23, 2009 · Not sure on the best way to do filter those values in MDX -- the Filter function is one alternative, although perhaps not the most performant or elegant. You may want to post that portion …