How to Trim Aliases of Different Lengths?
Is it possible to trim Aliases of different lengths in Reporting? We have to add member names to our Aliases to make them unique across all dimensions. Unfortunately, our member names within a dimension can be of varying lengths. Is there a way to trim the Alias using a formula so that is shows the values in the "Report to show" column? For example in excel you'd write a formula to tell it to ignore all characters up to and including the first space.