Work at SourceForge, help us to make it a better place! We have an immediate need for a Support Technician in our San Francisco or Denver office.

Close

postgres, mondrian' cube and jRubik

Garulfo
2006-05-11
2013-04-15
  • Garulfo
    Garulfo
    2006-05-11

    Hi,
    I recently discovered jRubik. I was able to run the foodmart demo fine.
    However, I'm having trouble testing jRubik with my mondrian' cubes.
    I made a cube_cv.xml file like this :
    <?xml version="1.0" encoding="ISO_8859_1"?>
    <RubikMdx>
    select {[Measures].[dureeMis]} on columns,
    {([Logiciels].[All Logiciels], [Collaborateurs].[All Collaborateurs],
      [Missions].[All Missions]) } on rows
      from [Niveau_competence]
    <Alias>cube_cv</Alias>

    <RubikConnection
    driver="org.postgresql.Driver" 
    url="jdbc:postgresql://localhost:5432/dw_ressource" 
    jdbcUser="mylogin"
    jdbcPassword="mypwd"
    catalog="file:./data/resources/catalogs/dw_ressource.xml"
    </RubikMdx>

    I added this file in the
    {jrubik}\data\resources\mdxmenu\postgresQL\cube_cv.xml directory.
    I then added my dw_ressource.xml file which is my cube definition in the {jrubik}\data\resources\catalogs\dw_ressource.xml.

    When I start jRubik, I don't see any table under my postgresQL directory.
    Did I put the dw_ressource.xml and cube_cv.xml files in the right places ?

    Also, should I add the postgres jdbc driver somewhere in the jRubik directory ?

    Thanks in advance,

    Regards,
    Fabien

     
    • Felix Saz
      Felix Saz
      2006-05-12

      Try:
      Change: 'jdbcUser' by 'userName'
      and 'jdbcPassWord' by 'password'
      For add the postgres jdbc driver use:
      Menu->Window->Focus View-> Focus Wizard Drivers
      and reboot the application.

      Felix

       
      • Garulfo
        Garulfo
        2006-05-12

        Thanks a lot Felix, it now works :)

         
    • Leo Moreira
      Leo Moreira
      2006-12-13

      Hi All,

      I've recently discovered jRubik, I'd like to know if there is a full aplication that I could use as an exemple, so that I could learn fast this great tool
      Thanks in advance