US and Worldwide: +1 (866) 660-7555
Results 1 to 2 of 2

Thread: How to return caption in DRILLTHROUGH?

  1. #1
    Join Date
    Jul 2013
    Posts
    1

    Question How to return caption in DRILLTHROUGH?

    Hello, I would like to return the content of a level's captionColumn, localized, as the result of an MDX DRILLTHROUGH query. By default only the column (and, if set, the nameColumn) contents are returned as a result column. and I have tried various ways unsuccessfully. It this achievable?

  2. #2
    Join Date
    Sep 2009
    Posts
    4

    Default

    I don't know if got your point.
    Is that about Drill through in time dimensions ?
    I mean :
    looking at YEAR level :
    -----------------| 2013 |
    |Measure Name|--99--|

    Drill through time dimension ( QUARTER level) :
    -----------------| --------------------2013-----------------------|
    -----------------| 2013 - Q1 | 2013 - Q2 | 2013 - Q3 | 2013 - Q4 |

    |Measure Name|----10-----|-----20----|------50----|-----29----|


    If I'm not mistaken, in MS SSAS, you can see the name of the member's parent hierarchy in the caption of the level when you perform a drill through.
    I would like to do the same in mondrian / pentaho.
    In mondrian I can only display the quarter name (Q1, Q2, Q3, Q4).


    Is that your question?

    Regards,
    Brian.
    Last edited by Brian_OD; 08-16-2013 at 05:09 PM. Reason: Formating issue

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •