CODEWITHSUNDEEP
databasessasdaxtabularssas-tabular
Leif
Leif

Reputation: 125

SSAS Tabular table always shows in Excel

In my SSAS tabular model I have a calendar dimension, and a wave dimension for half-year data only. The data flows to these tables as such:

Fact Table ---> Wave Dim <---> Calendar

No matter what I do I cannot hide the wave table from Excel users. The table shows hidden in Visual Studio, but in Excel it shows the table with no fields in it. I have tried deleting the table and reloading it with no avail. My assumption is that it has to do with the way it's connected to the Calendar dimension, but I can't seem to find anything on my issue. Any help would be much appreciated.

Upvotes: 1

Views: 484

Answers (1)

dybzon
dybzon

Reputation: 1594

This is a tough one to answer without viewing your model.bim file. Based on your information I have two guesses on what could be the issue, although this may very well not be it: 1) It sounds like you've marked all fields in the Wave table as hidden, but not the Wave table itself. Could this be the reason? 2) Perhaps you are using perspectives, and only hid the Wave table in a perspective rather than in the Model (default perspective)?

The relationships in your model should have no impact on whether a table is displayed in client tools or not.

Feel free to upload your model.bim file if the above does not help.

Upvotes: 1

Related Questions