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: Tue at 3:38 PM by mkirby | Created: Tue 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: Today at 8:13 AM by muk242 | Created: Mon 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: Jul 21 at 1:37 PM by manowar | Created: Jul 21 at 1:37 PM by manowar

Use MeasureGroupMeasures for tabular actions other than drillthrough

Actually, I spoke too soon. I still can't limit the action to a specific measure group. Here's what I'm seeing on the BIDS Helper Tabular Actions Editor: select Action Type = Drilldown select Ta...

Id #35292 | Release: None | Updated: Jun 13 at 5:00 PM by furmangg | Created: Jun 13 at 4:58 PM by furmangg

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: Feb 12 at 3:21 PM by PelleSunkan | 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

SSAS: detect mismatch in other datatype bindings besides dimension

There are a few scenarios BIDS Helper can't detect: http://social.msdn.microsoft.com/Forums/sqlserver/en-US/1e432b5d-aea5-4840-a4a4-ef863f9c213b/errors-in-the-backend-database-access-module-the-siz...

Id #34765 | Release: None | Updated: Jan 16 at 2:48 AM by MikeHoney | Created: Dec 22, 2013 at 1:56 AM by furmangg