June 27, 2020

The Show Hidden Cubes SSAS Connection String Property

If you need to write queries in SQL Server Management Studio against an SSAS cube that has its Visible property set to false, you have a problem because when you connect to your database you can’t see the cube or its metadata! Luckily you can override this and make the cube visible by setting the following connection string property when you connect: To get in depth knowledge on Microsoft business intelligence, enrich your skills on msbi online training

Show Hidden Cubes=true

Connection string properties can be set in the Additional Connection Parameters tab of the connection dialog that appears when you open a new MDX query window.

Unfortunately this doesn’t make any objects in the cube that are not visible, like measures or dimensions, visible again – it just makes the cube itself visible.

I hope you to reach a conclusion about SSIS and SSRS services. You can learn more through Msbi online training Hyderabad