palo analyzer with mondrian olap

    This site uses cookies. By continuing to browse this site, you are agreeing to our Cookie Policy.

    • palo analyzer with mondrian olap

      Hi,all

      I want to use the palo analyzer connect to the mondrian olap,I download the software and deploy it refer to the installation

      ,then input "http://localhost:8080/Palo-Analyzer" in ie,but I can't log in by admin/admin

      and to connect to the mondrian olap,how should I do,it whether has some documentation, thanks!

      best regards
      dragon
    • Oops I am wrong, you can use jpalo's analyzer and deploy the war file into webapp folder of tomcat.
      Restart the tomcat . Navigate to palo analyzer url.

      Under connections you can configure apart from Palo - Mondrian,SAP-BW,MSAS olap databases.
      And yes you can use mondrian as source They have given example connection.

      Best regards,
      Noel.

      The post was edited 2 times, last by noelgaur ().

    • Have you downloaded the installation files from Jpalo website - Jpalo.com ?

      When you login your url should be similar to below:
      - IP:Your tomcat port/Palo-Analyzer.
      localhost:8080/Palo-Analyzer/c…ty.wpalo.WPalo/WPalo.html

      - In past have you tried to install other version of Palo-Analyzer if so then you would need to cleanup your relavent tomcat directories.

      when you try to login as admin/admin - what error message you get?

      Best regards,
      Noel.
    • This is a HACK!

      The Palo Analyzer maintains its metadata in HSQLDB metadata database.
      Login using a JDBC SQL cilent software or a custom java code.

      jdbcDriver = org.hsqldb.jdbcDriver
      jdbcURL = jdbc:hsqldb:file:C:/paloSQLMetaData_wpalo/MetaData
      user =sa
      password field is empty

      You can find the HSQLDB jdbc library under tomcat\webapps\Palo-Analyzer\WEB-INF\lib\hsqldb_1.8.1.1.jar

      update users set password='ISMvKXpXpadDiUoOSoAfww==' where login='admin';
      commit;

      This will reset the password for 'admin' user as 'admin'
      Restart the Tomcat server;

      Now you can use admin user to login with admin as password.

      Hope it helps!

      Best regards,
      Noel.
    • Well connection to Mondrian could be done but its single hierarchy support, also Palo Analyzer is not free.
      Palo Analyzer's advantage is the writeback support on Palo Cubes.
      I would prefer Saiku analytics(it has a writeback-even distribution, through query scenario for palo) any day over palo-analyzer, but that's me;


      Best regards,
      Noel.
      Images
      • mondrian_connection.jpg

        47.71 kB, 672×343, viewed 410 times