I am designing a cube for a database that allows custom captions for various field / tables. I was wondering if it is possible to have the name of the dimension dynamically assigned based on a query?
For example a DIMENSION is called CUSTOM1 but there is a caption table that has the user assigned name to this. Therefore would actually like this DIMENSION to have the caption name.
Using SQL 2008 OLAP.
Any other ideas?