4 Replies Latest reply: Dec 5, 2017 1:53 PM by Margaret Martin RSS

    GetObjectField() works in Expression Label but not in Dimension Label

    Margaret Martin

      I have Qualified my tables: the fieldnames look like 'TableName.FieldName', so they don't join with other tables with fields with the same name.

       

      But I want to take out the TableName when I display the field and it's value in a chart. And I don't want to re-type a label for every single field name. I am using the fields as Dimensions. But I'm having trouble removing the 'TableName.' in the Label. The first step that doesn't work is GetObjectField(). I put this as the Label for the Dimension and it doesn't work. I put the exact same thing in the Label field for an Expression with the exact same field in it, and it works.


      Is there something else I should be using for a dimension label?


      Thx!!