Problem solved.

Processing in the cube from the BIDS solution (without any roles defined), dropped the existing roles which were originally defined in SSMS .

Solution : Process the cube from the...

Hi Steve,

In the meantime I found another syntactical solution on the web.

Here's an example.

WITH

SET [TCat] AS

TopCount([Product].[Subcategory].[Subcategory],10,[Measures].[Sales Amount])

...

Hi Steve,

Thanks for the inputs.

A nice article indeed on the topcount() function.

This helps me to solve the first part of my question.

Any tips on the 2nd part.

How do I...

My colleague found the solution.

It was actually the BIDSHelper tool that caused the BIDS SSIS solution to respond so slow on a large SSIS package.

After uninstalling BIDSHelper, the SSIS...

Hi again JT,

Thanks for your further sharings.

Unfortunately, these changes do not improve the responsiveness of the BIDS UI in this particular package.

Regards,

Franky

Hi again JT,

Yes, I had put DelayValidation=True for the ConnectionManagers, but that didn't improve the response of BIDS for that package.

Thanks,

Franky

Hi JT,

Thx for the update.

I put all

DelayValidation properties on True, and

ValidateExternalMetadata properties on False.

It still takes 30 seconds (not much a difference) to switch between the control flow...

Hi Jack,

Thx for the update.

"How much memory do you have?" - 3,37 GB

"Is the package solution stored in a network location or on the PC itself? ...

Hi Matt,

Thanks for the inputs. In the mean time, the issue is solved and was caused by another situation.

Apparently, in the SSIS Project Properties ( Debugging Properties ) the StartObjectID...

Thx!

Thx for the inputs RBaryy !

Thanks for the replies.

Apologies, but I forget to mention that I'm working on SQL Server 2000.

ATTACH_REBUILD_LOG is not working in that version,

and the sp_attach_single_file_db does not work in this...

Dear,

In the mean time, I found the solution.

It is mentioned here :

http://www.microsoft.com/dynamics/crm/using/customizing/reporttutorial.mspx

Carefull, you should use an unshared datasource in your report definition. This can be defined at the report's...

Hi Steve,

Interesting topic, indeed.

To me streaming databases will become very succesfull, especially in the domain of robotics.

If there is 1 area where online processing of mass data streams will be...