This project has moved. For the latest updates, please go here.

GetCustomDrillthroughMDX seems to work differently in 2016

I have an SSAS database in SQL 2012 that I have used GetCustomDrillthroughMDX for a very long time to drill through on calculated measures. I have moved it to a SQL 2016 server and installed the 20...

Id #43611 | Release: None | Updated: Apr 20 at 2:47 PM by davemartz506 | Created: Apr 17 at 6:40 PM by davemartz506

DiscoverXmlMetadataFull throws exception due to null values

Query a server where some DB have a description, some not. Query with Database|Description - if that's the bottom level, it works. Now query the cube level - crashes. Remove the |Description - work...

Id #43606 | Release: None | Updated: Apr 10 at 11:01 AM by Bob3141592653 | Created: Apr 10 at 11:01 AM by Bob3141592653

ExecuteDrillthroughAndFixColumns Enhancement for MDX queries

Furmangg, I did Used the ExecuteDrillThroughAndFixColumns too. Here is my Rowset Action Expression . 'call ASSP.ExecuteDrillthroughAndFixColumns("'+ "select {[Measures].CurrentMember} On 0, Non...

Id #43592 | Release: None | Updated: Mar 16 at 9:43 PM by furmangg | Created: Mar 16 at 9:43 PM by furmangg

AdomdServer.Context.CheckCancelled throws exception after upgrading to SQL 2014

Recently we upgraded SQL 2008 R2 to SQL 2014, and also updated ASSP 1.3.7 to 2014 version. But we ran into issues with ASSP.CreatePartitions stored proc where SSIS package (script task) fails with ...

Id #43556 | Release: None | Updated: Jan 9 at 2:51 PM by mhedman | Created: Jan 9 at 11:17 AM by AvinashRaja

Google is reporting files as unsafe

Hi I use Chrome on this computer (not my choice). Google has somehow decided that your downloads (or site) are "malicious". Might be worth poking them to get them to give their "intelligent" sys...

Id #43551 | Release: None | Updated: Jan 5 at 11:53 AM by dgosbell | Created: Jan 5 at 8:58 AM by SebT27

Installation issue

I have downloaded the dll but when I register it I am getting the "Clr Assembly must have main file specified." error. I have unblocked the dll and I'm using SSAS2016 and SSMS2016. This is my fir...

Id #43513 | Release: None | Updated: Mar 25 at 6:35 PM by furmangg | Created: Oct 28, 2016 at 8:49 AM by simonhr

GetCustomDrillthrougMDX truncation error in 1.3.9

Hi, I'm testing the beta 1.3.9 to solve some issues at my company to deliver some specific actions that are not possible in standard SSAS. The functions GetDefaultDrillthroughMDX does work for me...

Id #43412 | Release: None | Updated: May 5, 2016 at 12:17 AM by dgosbell | Created: May 3, 2016 at 10:30 AM by kooikerj

CALL ASSP.DiscoverXmlMetadataFull()

CALL ASSP.DiscoverXmlMetadataFull("Database\Cubes\Cube|Name,State,LastProcessed","") the above call to ASSP is giving following error Failed to parse the cube name from the query. (Microsoft.Repor...

Id #43377 | Release: None | Updated: Mar 29, 2016 at 11:26 PM by dgosbell | Created: Mar 25, 2016 at 6:59 PM by varundevraj

Drillthrough and Filters

Hi, I am using ExecuteDrillthroughAndTranslateColumns for translated column name but when I apply some filter on my data, this function returns all the data ,in drillthrough , not filtered one. Sa...

Id #43367 | Release: None | Updated: Mar 11, 2016 at 5:18 AM by muhammadali330 | Created: Mar 7, 2016 at 6:20 AM by muhammadali330

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