Lookup NoMatch output not recognised

Hi, I'm using VS2013 and SQL2014 and seem to be having an issue with the lookup. My pattern is for a fact lookup to dimension. When there is no match I pass this to a derived to update the key to...

Id #35489 | Release: None | Updated: Aug 22 at 10:30 PM by jbb352 | Created: Aug 22 at 10:30 PM by jbb352

Different suffix for drillthrough action name

I have created drillthrough actions in a cube for measures in a measure group. When I right click on the different measures > Additional actions - a different number gets suffixed to the action nam...

Id #35434 | Release: None | Updated: Aug 3 at 1:33 PM by gssahasr | Created: Jul 31 at 9:31 AM by gssahasr

BIDS 'hidememberif' 'NoName' causing SSAS to hang

I have used BIDS many times to create hierarchies and set the 'hidememberif' value to 'NoName' in more than one SSAS model. However, I have an issue with one SSAS model and one dimension in which ...

Id #35428 | Release: None | Updated: Jul 29 at 3:38 PM by mkirby | Created: Jul 29 at 11:34 AM by mkirby

Sort aggregations based upon size

http://blog.oraylis.de/2014/07/ssas-optimization-the-order-of-aggregations/

Id #35423 | Release: None | Updated: Jul 30 at 8:13 AM by muk242 | Created: Jul 28 at 11:39 AM by furmangg

Project Connection Manager in 2014

Hi guys it seems that using a Project Connection manager (CreateInProject="true") does not produce any effect in Visual Studio 2013. Can anyone confirm this, or I'm the only one have this problem...

Id #35400 | Release: None | Updated: Aug 11 at 5:08 PM by manowar | Created: Jul 21 at 1:37 PM by manowar

SSIS project properties doesn’t show Deploy (BIDS Helper) option when it’s under a folder

I can see the Deploy (BIDS Helper) option on properties of a SSIS project when it’s under a Solution, but this option is not shown when it is under a folder (see attached). I’m using SQL Server 200...

Id #35218 | Release: None | Updated: Jul 12 at 1:03 PM by SweetSirena | Created: May 14 at 4:52 PM by MonicaMolina

SSIS: Unused Connections in Connection Manager

As an enhancement, I would really like a way to find out which connections in the connection manager are not being used by any project component. This could either be a list, or maybe an icon updat...

Id #35175 | Release: None | Updated: Apr 30 at 9:29 AM by icowden | Created: Apr 30 at 9:26 AM by icowden

SSIS:Performance test fail when having Project parameters

When trying to run the Performance test (VS2012) it fails during validating the package. In the output window I read "Failed to lock variable "$Project::SomeVariable" for read access with error 0xC...

Id #34974 | Release: None | Updated: Aug 12 at 5:14 PM by feemurk | Created: Feb 12 at 3:20 PM by PelleSunkan

BIML: Execute SQL Parameter DataType Mismatch

Given the following BIML: <ExecuteSQL Name="SQL Log Row Count" ConnectionName="MyDb"> <PrecedenceConstraints> <Inputs> <Input OutputPathName="DFT Stage Incoming File.Output"...

Id #34962 | Release: None | Updated: Feb 6 at 7:29 PM by lotsahelp | Created: Feb 6 at 2:38 PM by lotsahelp

SSRS: Copy and Paste a Parameter (new feature idea)

I have an idea for a new BIDS Helper feature. Using the SSRS Report Designer, I wish I had $1 for every time I have had to "copy and paste" a parameter definition - typically from one report to an...

Id #34896 | Release: None | Updated: Jan 16 at 2:57 AM by MikeHoney | Created: Jan 16 at 2:57 AM by MikeHoney