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: Jul 9 at 11:40 PM by dgosbell | Created: Jul 9 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 at 5:48 PM by furmangg | Created: Jun 27 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 at 10:46 PM by dgosbell | Created: Jan 24 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 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

Add new method: FindCurrentTupleFilter

We are currently using the FindCurrentTuple as a means to get the where clause of an MDX query that we send to SSRS as an SSAS Action of Type URL. This is done so that we can create detailed SSRS "...

Id #32662 | Release: None | Updated: Feb 22, 2013 at 12:28 AM by furmangg | Created: May 4, 2012 at 3:43 AM by furmangg

Error retrieving Meta data - invocation.Object reference not set to an instance of an object

I was trying to get some Meta data information like SQL Column, DisplayFolder, and Translations of attributes and getting an error. Looks like for some places where we did not set DisplayFolder / T...

Id #32383 | Release: None | Updated: Feb 22, 2013 at 12:29 AM by palashaich | Created: Mar 8, 2012 at 3:40 PM by palashaich

Action not visible in AS 2008 with perspectives

from fpatou: Just to give me feedback we have resolved this by a modification of the FindCurrentTuple() method by adding AMOHelpers.GetCurrentCubeName():   public static string FindCurrentTuple() ...

Id #32325 | Release: None | Updated: Feb 22, 2013 at 12:29 AM by furmangg | Created: Feb 27, 2012 at 8:42 PM by furmangg