You need to hide the tables and columns

You are developing a SQL Server Analysis Services (SSAS) tabular project.
A model contains tables and columns that must not be visible to the user.
The columns and tables cannot be removed because they are used in calculations.
The calculations are used to calculate the budget and forecast for the current quarter.
You need to hide the tables and columns.
What should you do?

You are developing a SQL Server Analysis Services (SSAS) tabular project.
A model contains tables and columns that must not be visible to the user.
The columns and tables cannot be removed because they are used in calculations.
The calculations are used to calculate the budget and forecast for the current quarter.
You need to hide the tables and columns.
What should you do?

A.
Before adding the forecast calculations to the model, right-click the applicable tables and columns and
select the Hide option.

B.
Before adding the forecast calculations to the model, right-click the applicable tables and columns and
select the Hide from Client Tools option.

C.
After adding the budget calculations to the model, in the Properties window for the applicable tables and
columns, set the Enabled property to False.

D.
After adding the budget calculations to the model, in the Properties window for the applicable tables and
columns, set the Visible property to True.



Leave a Reply 0

Your email address will not be published. Required fields are marked *