Hitachi Vantara Pentaho Community Forums
Results 1 to 13 of 13

Thread: Reporting tools in Pentaho Community Edition

  1. #1

    Default Reporting tools in Pentaho Community Edition

    Hello Everyone,

    I am new to pentaho Community Edition.
    I have installed Pentaho Community Edition.
    The user console works fine!!!
    However, now I wanted to know how can we start basic Adhoc Reporting in Pentaho Community Edition (CE) version.
    How are the objects developed/created and how do we make it available for users?
    My backend Database is Oracle 11gR2 and wanted to connect the HR Database to do reporting in Pentaho Community Edition.
    Any help/suggestion given is highly appreciated.
    Thanks in advance.
    Thank you

    Cheers
    Ronak Shah

  2. #2

    Default Can users create new reports in Pentaho Community Edition

    Hello Everyone,

    I have installed Pentaho Community Edition and want to know if my users can create new reports in Pentaho Community Edition.
    If Yes, then how do i make the measures and dimension objects (column mappings) available.
    Request to please help as this is on an urgent basis.
    Thanks in advance!!!
    Thank you

    Cheers
    Ronak Shah

  3. #3

    Default Reporting in Pentaho Community Edition

    Hello Everyone,

    I am new to Pentaho Community Edition.
    I have installed Pentaho Community Edition (BI Server 5.4.0.1-130).
    Now I wanted start creating Grid, Charts,etc. reporting through Pentaho User Console.
    Also, how to give users the power of AdHoc reporting (grids, cross tabbing and charts with drill down and other capabilities).
    Request all you experts to let me know how can I achieve this.
    Any help is highly appreciated!!!
    Thank you

    Cheers
    Ronak Shah

  4. #4

    Default

    No you can't.
    That's an EE feature.

    Check this: http://forums.pentaho.com/showthread...Reporting-quot

  5. #5

    Default

    Thanks Emicarnicero for replying!!!
    So Saiku is the way for reporting in Pentaho Community Edition (I have biserver-ce-5.4.0.1-130).
    I did see the plug-in for Saiku, but how do I get the measures and dimension available for my users.
    I mean where do I design and publish the same, so through Saiku my users can do basic reporting.
    Your response is much appreciated...
    Thank you

    Cheers
    Ronak Shah

  6. #6

    Default

    Hello everyone...Please do respond...It would be much appreciated!!!
    Thank you

    Cheers
    Ronak Shah

  7. #7

    Default

    There's a tool called Pentaho Schema Workbench

  8. #8

    Default

    Hi Emicarnicero,

    So through Pentaho Schema Workbench, we can create cubes or measures and dimensions.
    Also is there a Pentaho Schema Workbench Community Edition that is available for download?
    Will Saiku plugin pick up the cube so created?
    Thanks!!!
    Thank you

    Cheers
    Ronak Shah

  9. #9
    Join Date
    Nov 2009
    Posts
    688

    Default

    You can download the Schema Workbench here: http://sourceforge.net/projects/mond...kbench/3.10.0/
    When you create a cube with the Schema Workbench and you publish it to the BI server you can run that cube with Saiku plugin

  10. #10

    Default

    Thank you Johanhammink and Emicarnicero!!!
    Will try my hands on with PSW and hopefully this should solve my queries.
    Thank you as this encourages newbies like us to explore more and more!!!
    Thank you very much!!!
    Thank you

    Cheers
    Ronak Shah

  11. #11

    Default

    Hello Johanhammink and Emicarnicero,

    I did download the PSW (psw-ce-3.10.0.1-130) and was trying to create a basic cube.
    As I create a ODBC connection and click on new Schema/MDX/JDBC, PSW freezes and stops completely.
    Is there something that I am missing?
    Please help!!!
    Thanks...
    Thank you

    Cheers
    Ronak Shah

  12. #12

    Default

    Hey folks,

    I was wondering why my cube aren't showing up in Saiku window.
    Also when I publish the cube it just simply exports and doesnt ask me for any folder path.
    There were some posts I read that it requires only JNDI or JDBC connection, is it true?
    Why am I unable to locate the datasources.xml file anywhere in the BI Server folder?
    The OLAP folder is also available?

    Also can we have a single report from multiple data sources? (Like Data Federation)

    Please do help!!! I have got multiple issues
    Thank you

    Cheers
    Ronak Shah

  13. #13

    Question pb

    Bonjour

    prière de m'aider r
    a propos pentaho je me demande est-il possible de crée un réseau utilisateur avec des clients léger qui s'execute sur navigateur et un admin sur serveur !!!


    merci

Tags for this Thread

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.