3 Replies Latest reply on Mar 11, 2011 9:27 PM by 809363

    Change Column Names in SnapShot Table?

      Currently when creating a snapshot - a table is created using column names such as C_PRODUCT_MEMBER_CAPTION or C_MEASURES_MEASURE_NAME

      Is there a way to format these column names during the creation of the table?
      Such that a measure named "Shipments" would create a column name of "Shipments" and not "C_MEASURES_SHIPMENTS".

      I am aware that MDX can alias member names such as:

      WITH MEMBER [Measures].[New Name] AS [Measures].[Really long measure name that I want to change]

      But this would still not remove the "C_MEASURES_" prefix.

      Thank you,