Sign In






All Tags » Oracle (RSS)

Browse by Tags

  • How to give outer joins in the Elasticube?

    Hi , I am working on getting a report based on the DW (ORACLE Based) available and there are already built queries which we are using to retrieve the data. 1) I am trying to use the same logic of the query but I am facing problems in giving outer joins in the Elasticube manager GUI. How to make a simple...
    Posted to Prism Issues (Forum) by Raghav on 11-25-2011

  • Re: Error when trying to connect to Oracle 9i database

    Has this been fixed in Prism Cubed? I Just downloaded a demo and am not able to connect to my 10g database. I have the 11g client installed on my machine if that matters (I don't know if SiSense relies on the client software already installed on my PC or uses its own) Thanks
    Posted to Prism Issues (Forum) by jhpark on 08-24-2009

  • Problem with reading from certain Oracle Tables

    Good day, I'm trying out Prism version 1.0.1171 on an Oracle XE database and am getting the error message 'Error reading from table' when select certain tables to add as a data source. This might be an issue with the Prism Oracle client that seems to have certain problems at present. Are...
    Posted to Prism Issues (Forum) by Vis on 12-23-2008

  • Re: Oracle

    Hi, In order to connect to Oracle, you need to write the full connect description to the database server location. for example: (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP) (HOST = 25.1.1.161) (PORT = 1541)) (CONNECT_DATA = (SID = PROD)) ) (The connect descriptor can be found in the tnsnames.ora file....
    Posted to Prism Issues (Forum) by Aviad on 11-19-2008

  • Prism Oracle support

    Question: What Versions of Oracle does Prism support? Answer: Prism Supports Oracle v.9.2 and higher.
    Posted to Known Issues & Workarounds (Forum) by Adi on 09-24-2008

  • Re: Error when trying to connect to Oracle 9i database

    Mike, I have confirmed with our development team that there is a severe issue with Prism Oracle Client (which is a stripped down version of oracle's modules) in this beta release (0.80.1907) and are working on a fix (it has to do the way the client is deployed and communicates with the Prism application...
    Posted to Prism Issues (Forum) by Elad (SiSense) on 05-22-2008

  • Error when trying to connect to Oracle 9i database

    I am receiving the following error when trying to connect to an Oracle 9i database: Error Connecting - The type initializer for 'Oracle.DataAccess.Client.OracleConnection' threw an exception. Steps to reproduce. 1. Open Prism Desktop (v.0.80.1907) 2. Select Create New Data Source 3. For Data...
    Posted to Prism Issues (Forum) by mw0630 on 05-21-2008

  • How do I specify non-standard port for Oracle connection?

    How do I specify a non-standard port for a remote Oracle connection in the "Create New Information Source" dialog? Does the Prism 'Oracle client' acknowledge TNSNAMES.ORA? If so, where/how does it search for TNSNAMES.ORA?
    Posted to Prism Issues (Forum) by mconry on 04-18-2008
Page 1 of 1 (8 items)