Forum Discussion
SSAS tabular cube dimension/measure friendly names
Anonymous personally, I'd use the View method. This method allows any backend developer to determine mappings with ease and implement any changes to fields without impacting the model. (ex. the wrong column was mapped to "Name1", you can swap out the column and "Name1" remains intact from the model perspective.
Also, developers wouldn't need to figure out how to navigate the Tabular model to determine where any mapping/name change occured.
The list goes on, but suffice to say, I agree with you.
Anonymous Unless I'm mistaken because of the mode... you should be able to just either double click the column name or right click and change the column name in your tabular model?
Thanks for your reply. You're correct. I think I was just hoping for a way of decoupling underlying database table naming conventions from the naming convention exposed to users..
It seems I have three main options:
Rename columns in the tabular model
Create views that include used a friendly naming convention (possibly including spaces [!!!]) or
Create a hack in the .bim to translate English to English
Ideally I'd like developers to see the same columns in the cube as are in the database and cube users/power BI to see 'friendly names' so I might go down the View route unless there is an alternative?
Thanks
Pbix
Anonymous personally, I'd use the View method. This method allows any backend developer to determine mappings with ease and implement any changes to fields without impacting the model. (ex. the wrong column was mapped to "Name1", you can swap out the column and "Name1" remains intact from the model perspective.
Also, developers wouldn't need to figure out how to navigate the Tabular model to determine where any mapping/name change occured.
The list goes on, but suffice to say, I agree with you.
Thanks Eno,
Great to get your perspective on this.
Pbix.