locked
modify the returned column names? RRS feed

  • Question

  • hi all,

    when defining a drillthrough action, how can i change the returned column names?

    they are by default in the form of [$dimension_name].[atribute_name].

    thanks


    Andrew
    BI, Data Mining, Analytical CRM
    Friday, January 20, 2012 6:33 AM

Answers

  • Hi Andrew,

    I do not think you can modify Column name in drillthrough action.
    But you can use Report action to resolve this issue.

    Regards,
    Pushkar Bhushan

    • Proposed as answer by Challen Fu Tuesday, January 24, 2012 1:58 AM
    • Marked as answer by Andrew Goodnight Monday, January 30, 2012 1:15 AM
    Friday, January 20, 2012 7:42 AM
  • Pushkar is correct - You can't do this with the default functionality.

    But you might be interested in the project at http://asstoredprocedures.codeplex.com which has a function which can achieve this through report actions and the use of a .net assembly


    http://darren.gosbell.com - please mark correct answers
    Monday, January 23, 2012 1:04 AM

All replies

  • Hi Andrew,

    I do not think you can modify Column name in drillthrough action.
    But you can use Report action to resolve this issue.

    Regards,
    Pushkar Bhushan

    • Proposed as answer by Challen Fu Tuesday, January 24, 2012 1:58 AM
    • Marked as answer by Andrew Goodnight Monday, January 30, 2012 1:15 AM
    Friday, January 20, 2012 7:42 AM
  • Pushkar is correct - You can't do this with the default functionality.

    But you might be interested in the project at http://asstoredprocedures.codeplex.com which has a function which can achieve this through report actions and the use of a .net assembly


    http://darren.gosbell.com - please mark correct answers
    Monday, January 23, 2012 1:04 AM
  • Hi Andrew

    Orginal Query

    drillthrough
    select
    from [Adventure Works]
    


    Updated Query

    DRILLTHROUGH
    SELECT
       ([Date].[Calendar].[Month].[July 2003])
    ON 0 
    FROM [Adventure Works]
    WHERE [Geography].[Country].[Australia]
    RETURN 
      [$Date].[Date] as [Date]
      ,KEY([$Product].[Model Name]) as [Model Name]
      ,NAME([$Employee].[Employee]) as [Employee Name]
    

     


    Please vote as helpful or mark as answer, if it helps
    Cheers, Raunak | t: @raunakjhawar | My Blog
    • Edited by Raunak J Monday, January 23, 2012 7:44 AM
    Monday, January 23, 2012 7:43 AM
  • @Raunak - you cannot specify the "as" clause in an action. You can only do this if you had write the drillthrough query.
    http://darren.gosbell.com - please mark correct answers
    Monday, January 23, 2012 8:26 AM