Fix documentation for GetCustomDrillthroughMDX

Documentation doesn't account for all the new signatures of this function including: GetCustomDrillthroughMDX(string sReturnColumns, Tuple tuple, int iMaxRows, bool skipDefaultMembers) And test al...

Id #43318 | Release: None | Updated: Dec 21, 2015 at 9:46 PM by dgosbell | Created: Dec 21, 2015 at 3:10 PM by furmangg

ASSP.GetCustomDrillthroughMDX error: The function expects a tuple expression for the argument. A string or numeric expression was used

I am attempting to use the method ASSP.GetCustomDrillthroughMDX, calling using the following signature: ASSP.GetCustomDrillthroughMDX( <string of return columns>,<int as maxrows>) and I am getting...

Id #43317 | Release: None | Updated: Dec 21, 2015 at 3:08 PM by furmangg | Created: Dec 18, 2015 at 2:14 PM by michael_lawson

See if AS2016 supports multiselect invocation of rowset actions

http://blog.crossjoin.co.uk/2015/10/05/drillthrough-on-multiselect-now-works-in-excel-2016-and-ssas-2016/?utm_source=feedburner&utm_medium=feed&utm_campaign=Feed%3A+wordpress%2FCpjz+%28Chris+Webb%2...

Id #43288 | Release: None | Updated: Nov 6, 2015 at 5:45 AM by furmangg | Created: Nov 6, 2015 at 5:45 AM by furmangg

Custom DrillThrough Error - Truncating MDX Query?

I've tried implementing this in our cube and have run into an issue. The action expression is very simple: ASSP.GetCustomDrillthroughMDX(" NAME([$Paid Date].[Date]) as [PaidDate]") When I try to...

Id #35365 | Release: None | Updated: Nov 16, 2015 at 7:36 PM by dgosbell | Created: Jul 9, 2014 at 3:40 PM by furmangg

add replacement for Excel.NORMSINV

Could borrow C# code for inverse function from: http://www.c-sharpcorner.com/Forums/Thread/251944/normsinv-in-C-Sharp-datatable.aspx Generally, it would be nice to rewrite all Excel functions in ....

Id #35332 | Release: None | Updated: Jun 27, 2014 at 5:48 PM by furmangg | Created: Jun 27, 2014 at 5:48 PM by furmangg

ASSP.Parallel crashes SSAS

SanjoySa Today at 1:29 AM HI, When I am using the MDX (ASSP.ParallelUnion) at https://asstoredprocedures.codeplex.com/wikipage?title=Parallel , it is stopping the AS Service (AS2012). Any help on t...

Id #34929 | Release: None | Updated: Jan 24, 2014 at 10:46 PM by dgosbell | Created: Jan 24, 2014 at 4:26 PM by furmangg

error on discoverXmlMetaData with optional property specified after |

CALL ASSP.discoverXmlMetaData("\Database\Cubes\Cube\MeasureGroups\MeasureGroup|Name\Measures\Measure|Name,DisplayFolder\Source\Source"); That throws an error probably because not every measure has...

Id #34365 | Release: None | Updated: Aug 13, 2013 at 10:44 PM by furmangg | Created: Aug 13, 2013 at 10:44 PM by furmangg

ExecuteDrillthroughAndFixColumns fails for money fields

I am trying to use ExecuteDrillthroughAndFixColumns for an Action against an Adventureworks cube. As soon as a Money measure is included in the result set of the Drillthrough command, it fails a me...

Id #34247 | Release: None | Updated: Mar 1, 2014 at 11:42 PM by mssqlgirl | Created: Jul 10, 2013 at 3:11 PM by gottfriededer

BottomCountWithTies returns wrong values

Set to sort: 6 6 6 12 6 6 14.99 2.99 6 2.99 6 6 17.94 The returned result for bottom 5 vaules with BottomCountWithTies: 2.99 2.99 6 6 6 6 6 6 6 6 17.94 Expected result: 2.99 2.99 6 6 6 6 6 6 6 6...

Id #33998 | Release: None | Updated: Apr 24, 2013 at 6:06 AM by dtroyz | Created: Apr 24, 2013 at 1:12 AM by dtroyz

incorporate Percentile patch provided by Richard Mintz

Incorporate Richard's percentile function into ASSP.   See http://asstoredprocedures.codeplex.com/SourceControl/list/patches

Id #32876 | Release: None | Updated: Feb 22, 2013 at 12:28 AM by GeorgeQiao | Created: Jun 21, 2012 at 3:16 PM by furmangg