Believe it or not, I will actually be updating my blog more frequently in the future. I’ve gotten 3 articles each half written and will be finishing them soon (I hope)! Two of them are on Formatted columns and an undocumented change to Smart view behavior. look for them soon.
But in the meantime, just to prove I’m not dead, Here is a little tidbit that I have been asked too many times. In Smart View connecting to Essbase, you have the options for member display of “Member Name Only” and “Member Name and Alias” (For now I’m going to ignore qualified member names)
This confuses people as when they select Member Name Only, they see the Alias. What this setting really means is “Member Name OR Alias depending what is selected in Alias”. If you select None, you get the member name if you select an Alias table you get an Alias. Simple isn’t it.
During the beta long ago, I tried to get them to change the wording, but Oracle could not come up with anything meaningful that fit into the selection box so we are stuck with what it is.
3 comments:
Is there any way we can create a global setting to display member names only when users open up spreadsheets. They have to click on Change Alias setting to 'None' everytime they open a SV template.
Is there any way we can create a global setting to display member names only when users open up spreadsheets. They have to click on Change Alias setting to 'None' everytime they open a SV template.
If you use a private connection you can specify which alias table to use ( or use member names) and the spreadsheet will use that when opening
Post a Comment