All objects (eg cost center) within our system have their own ID, which is basically an alphanumeric string. We can filter the various fact tables in our data warehouse using these IDs.
This ID is NOT user-friendly and this is causing an issue.Once a user has chosen their cost centers, it is the ID which is displayed in the parameters box. We would like to display the CC Number or Name instead of the ID but continue to use the ID to filter our fact table. How to do this in LOV.
ie . i want display value as CC Name but filter value is ID.
Do you have a lookup table which maps Cost Center ID to Cost Center Number/Cost Center Name?
If so you can add this table to the universe, join it properly and create a prompt based on that lookup table.