Hitachi Vantara Pentaho Community Forums
Results 1 to 6 of 6

Thread: Can we show a Pivot view in pentaho dashboard

  1. #1

    Default Can we show a Pivot view in pentaho dashboard

    I have made a cube in cube designer and able to view the drill down report of that cube, I want to show that "Drill Down Report " in Pentaho dashboard, Please tell me is it possible,if yes how can I do this.
    thanks
    Yatan

  2. #2

    Default

    yes it is possible
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: chat.freenode.net Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(http://analytical-labs.com)

    http://mattlittle.files.wordpress.co...-bananaman.jpg

  3. #3

    Default

    Thanks for reply, I am not sure how to do this,
    Actually I am also making meter and bar charts from the cube and I also want to show the drill down report in same dashboard.
    Please tell me how to create drill down in dashboard or Pentaho.



    thanks
    Yatan

  4. #4

    Default

    Not to be blunt but there very little chance of you getting help unless you show some sort of willingness yourself, I mean there's no explanation of how far you have got, have you even tried dashboards before, do you use JSP or the CDF, have you install the samples so you can look at the example dashboards, have you got the hang of basic reporting before you move on to dashboards?? I'm sure there's plenty more questions.
    This is a signature.... everyone gets it.

    Join the Unofficial Pentaho IRC channel on freenode.
    Server: chat.freenode.net Channel: ##pentaho

    Please try and make an effort and search the wiki and forums before posting!
    Checkout the Saiku, the future of Open Source Interactive OLAP(http://analytical-labs.com)

    http://mattlittle.files.wordpress.co...-bananaman.jpg

  5. #5

    Default

    I am new to Pentaho altogether but have Idea of Java and have been working on Pentaho for 2 months, I am using JSP, and have installed the samples and using them to change according to my requirement.

    I am using the sampledashboard.jsp (pentaho-demo\jboss\server\default\deploy\pentaho.war\jsp) and changing the page according to my requirement, I am able to show the charts/meters by "ChartHelper.doChart( "samples", "dashboard", "departments.widget.xml", parameters, content, userSession, messages, null );
    " but when it comes to showing the Pivot I dont know what to do.



    // Make a bar chart showing the department
    // create the parameres for the bar chart
    parameters = new SimpleParameterProvider();
    // define the click url template
    parameters.setParameter( "drill-url", "SampleDashboard?region="+region+"&department={SERIES}" );
    parameters.setParameter( "REGION", region );
    parameters.setParameter( "outer-params", "REGION" );
    // define the category axis of the bar chart
    parameters.setParameter( "inner-param", "DEPARTMENT"); //$NON-NLS-1$ //$NON-NLS-2$
    // set the width and the height
    parameters.setParameter( "image-width", "600"); //$NON-NLS-1$ //$NON-NLS-2$
    parameters.setParameter( "image-height", "400"); //$NON-NLS-1$ //$NON-NLS-2$
    content = new StringBuffer();
    messages = new ArrayList();
    // call the chart helper to generate the pie chart image and to get the HTML content
    // use the chart definition in 'samples/dashboard/regions.widget.xml'
    ChartHelper.doChart( "samples", "dashboard", "departments.widget.xml", parameters, content, userSession, messages, null );


    Thanks
    yatan
    Last edited by YatanveerSingh; 08-19-2008 at 06:37 AM.

  6. #6

    Default

    OK, I am using ".doChart" for displaying charts , what should I use to display pivot(drill down report generated by cube designer)

    ChartHelper.doChart( "samples", "dashboard", "cube5.mondrian.xml", parameters, content, userSession, messages, null );

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.