What does setting Available in MDX to False do for a column?

What does setting Available in MDX to False do for a column?

• A. Makes column unavailable to MDX queries
• B. Hides column from every UI
• C. Forces column to be ignored by DAX
• D. Removes column from model

Answer: (A)

Setting Available in MDX to False restricts MDX access to that column. MDX is the query language used for multidimensional models, so turning this off means MDX clients can’t reference or retrieve data from that column in their queries. The column can still be used in the UI and by DAX-based tools, and it remains part of the model; it’s just not available to MDX queries.

Setting Available in MDX to False restricts MDX access to that column. MDX is the query language used for multidimensional models, so turning this off means MDX clients can’t reference or retrieve data from that column in their queries. The column can still be used in the UI and by DAX-based tools, and it remains part of the model; it’s just not available to MDX queries.