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 at 5:06 AM by dtroyz | Created: Apr 24 at 12: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 21 at 11:28 PM by GeorgeQiao | Created: Jun 21, 2012 at 2: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 21 at 11:28 PM by furmangg | Created: May 4, 2012 at 2: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 21 at 11:29 PM by palashaich | Created: Mar 8, 2012 at 2: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 21 at 11:29 PM by furmangg | Created: Feb 27, 2012 at 7:42 PM by furmangg

windows 7, sql server 2008 R2 enterprise, cannot see any of your methods

i have some very strange behaviour.   running windows 7 with sql server 2008 r2 enterprise.   when i deploy an assembly (one that i have built) to the as instance i can only use methods that have e...

Id #31203 | Release: None | Updated: Feb 21 at 11:29 PM by bigdave1971 | Created: Aug 7, 2011 at 6:47 PM by bigdave1971

Error running ASSP.ClearFileSystemCache()

I have installed and registered the latest version of ASSP on a 2008R2 Enterprise Edition   I am able to run ASSP.GetFileSystemCacheBytes() but when I try running ASSP.ClearFileSystemCache() I am r...

Id #30180 | Release: None | Updated: Feb 21 at 11:29 PM by furmangg | Created: Feb 16, 2011 at 11:00 PM by Nadreck

ExecMdx function

Hi guys, any chance of writing an ExecMdx function (or something similar) that works like an sql exec function that executes a string of mdx and returns the results. This would compliment the drill...

Id #29988 | Release: None | Updated: Feb 21 at 11:29 PM by furmangg | Created: Jan 18, 2011 at 4:19 PM by 00

Will this work on SQL server 2008 r2?

Hi, I am intrested in Memory usage stored procedure. SO far i dont have sucess in running it against SQL server 2008 R2. Is there a plan to release a new version compatible with SQL server 2008 r2

Id #29177 | Release: None | Updated: Feb 21 at 11:29 PM by furmangg | Created: Oct 15, 2010 at 6:13 PM by sambath

GetCustomDrillthroughMDX is not working for invisible dimensions and/or dimension attributes

GetCustomDrillthroughMDX is a wonderful function, to provide drillthrough actions in any cube context (especially in combination with calculated items). Therefore it allows overruling the current ...

Id #27965 | Release: None | Updated: Feb 21 at 11:29 PM by michael_ibax | Created: Jul 5, 2010 at 8:50 AM by michael_ibax