none
adding a STRING field to a measure group??? RRS feed

  • Question

  •  

    hi all,
         I have a fact table in associated with bunch of dimension. i have a description field in this fact table. first of all i dont know if this description should go in the fact table or anyother table. anyway im trying to bring this field into my SSAS cube as NON AGGREGATE attribute. but my cube is not allowing me to put this field in my measure group as the data type is STRING.
        Actually i dont even need this field in measure group. but i need it for a drill through operation. i want to create an ACTION and show this field as drill through. how can i do that without putting this field in the measure group??
       any ideas or any suggestions for redesign?? appreciate your time

    thanks

    Thursday, August 14, 2008 12:21 AM

Answers

  • I don't think SSAS allows you to add string fields as measures.  You might want to try adding the field as a dimension.  Then you can access it from the drilldown query as:

     

    RETURN ([DIMENSION].[$DIMENSION.FIELD] AS [ALIAS])

     

    In the Dimension structure, you can also set the AttributeHierarchyVisible field to 'False' if you don't want users to see this field in the list.

     

    Hope this helps,

    Manny

     

    Thursday, August 14, 2008 7:38 PM