Home Forums Data Warehousing Analysis Services SSAS with a few thousand calculations. How to reduce time-to-connect? RE: SSAS with a few thousand calculations. How to reduce time-to-connect?

  • March 19, 2015 at 9:35 am

    #1785109

    VALEK (3/18/2015)

    It freezes on DBSCHEMA_TABLES command.

    Yes we have dimension and cube security.

    Do you think this is do to with the custom security?>

    Could be. According to TechNet that command "Identifies the measure groups and dimensions exposed as tables within Microsoft SQL Server Analysis Services"

    Run this on your SSAS instance and see what it comes back with:

    SELECT * FROM $SYSTEM.DBSCHEMA_TABLES

    I am sure that the results have to be based on your permissions, so if you have a lot of custom permissions it could take some time. To test this, create a role with no custom permissions and see if the behavior is the same.