Hitachi Vantara Pentaho Community Forums
Results 1 to 5 of 5

Thread: How to add more details to drilldown?

  1. #1

    Question How to add more details to drilldown?

    Hello,
    I`m making cube for Partners balance checking.
    In cube view there is Partner code, Balance and Balance in other currency. I would like to get more information after drilldown. Now I get: Partner Group, Partner and Balance.
    Is it possible to add there columns: Date, Invoice Title or others? (from the same table as facts or other)

    Attached screenshoots.
    Attached Images Attached Images    

  2. #2
    Join Date
    Jan 2006
    Posts
    205

    Default

    You can do this by adding a Property to a level. Then select the "Show Properties" button in jpivot.

    Read all about it here
    http://mondrian.pentaho.org/document...ber_properties

    regards,

    Mike

  3. #3
    Join Date
    Oct 2007
    Posts
    25

    Default

    Well... I just implemented an "extDrillThroughCols" property to my Cube in the schema, that adds the listed columns when doing a drillthrough.. It that what you're looking for? Implemented on 3.0.4, but should be portable...
    Last edited by rosselet; 07-18-2010 at 08:36 PM.

  4. #4
    Join Date
    Jan 2007
    Posts
    485

    Default

    Hi rosselet..

    Can you provide an example / screen shot of that what you added to your Cube Schema? Just to to see how that works? Many Thanks, DMurray3

  5. #5
    Join Date
    Oct 2007
    Posts
    25

    Talking implementation

    Mondrian.xml
    Added to definition of Cube:
    Code:
     <Attribute name="extDrillThroughCols" type="String" required="false">
                <Doc>
                    Specify additional columns to be added from fact table at drillthrough
                    format "colname:alias,colname:alias"
                </Doc>
            </Attribute>
    also needs small change to DrillThroughQuerySpec.java
    and RolapCube.. and maybe a couple other small deltas.

    Basically means you have a fact table for your table, and in the
    cube definition, you can add
    Code:
     <Cube ... extDrillThroughCols="text1:My special field, specialcode:my code" ... >
    and so on, and these fields (with the specified aliases (heading) will be added when performing a drillthrough. There's probably a better way to do it, but it works for me )
    If you need more details or the rest of the code.. let me know.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.