I am using slicer to extract data into report. In columns I want to use custom names instead of standard names from hierarchy. How can I do this?
I do this using Custom Calculations. If you have complex selection in your structure selection, choose a dimention that you have statically selected in your Data Area, move it to your Columns section, create a calculation based on that dimension, use the Unique Name for the custom, give it your desired friendly display name, then when you add your slice to the canvas, hide the row that the Unique Key shows in and only show your custom calculation row.
The best solution is to add a text attribute and store the 'translation' i.e. new description there. The attribute value can be displayed in the slice output.
Like John suggests...Depending on the type of Application you're using (e.g. Business Applications B+P or FinCon, FSM, or a Custom EPM Platform OLAP model), other methods are possible possible too:
John, will that work if youre using the same member multiple times in a slice? Best example is a financial report with Current Period, Prior Period, Current Period YTD and Prior Period YTD. All would use the same Scenario (Actual) but they each require a different header.
Matthew - If using the standard business application then you can't add new attributes to the tome dimension unfortunately.
More generally There is a one to one relationship between element ID and attribute value but nothing stopping you creating more than one attribute. Obviously it's easier and more performant when there are clear repeating patterns in reports.
