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 at 10:26 PM by dgosbell | Created: Mar 25 at 5: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 at 4:18 AM by muhammadali330 | Created: Mar 7 at 5: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 8:46 PM by dgosbell | Created: Dec 21, 2015 at 2: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 2:08 PM by furmangg | Created: Dec 18, 2015 at 1: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 4:45 AM by furmangg | Created: Nov 6, 2015 at 4: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 6:36 PM by dgosbell | Created: Jul 9, 2014 at 2: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 4:48 PM by furmangg | Created: Jun 27, 2014 at 4: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 9:46 PM by dgosbell | Created: Jan 24, 2014 at 3: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 9:44 PM by furmangg | Created: Aug 13, 2013 at 9: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 10:42 PM by mssqlgirl | Created: Jul 10, 2013 at 2:11 PM by gottfriededer