Hi,

I'm starting to move around into Tabular Mode and I have some questions:

1 - I am hiding surrogate keys using "Hide from client tools" option. Does this hide columns consume memory?

2 - Suposing I have a dimensions with 2 fields, code and description. If I want to have a field that concatenates code and descriptions, does it perform worse creating it on SSAS? What is the recommendation?

Thank you

Hidden columns still consume memory and can be queried with custom queries. You just don't see them in the field list in client tools like Excel. As far as concatenating fields they will compress a little better if you do the concatenation in SQL but it likely doesn't matter much.

Ok thank you.

But if I dont bring the surrogate keys for instance, I wont be able to establish the relation between tables, right?

Yes you need to include the surrogate keys in the model for relationships and making them hidden is correct.