Oracle SQL Expression in Zephyr Call Center (Siebel Analytics)

Error received:State: S1000. Code: 10058. [NQODBC] [SQL_STATE: S1000] [nQSError: 10058] A general error has occurred. [nQSError: 27002] Near <=>: Syntax error [nQSError: 26012] . (S1000) SQL Issued: {call NQSGetQueryColumnInfo('SELECT "Position Hierarchy"."First Name", "Position Hierarchy"."La ...

Oracle A problem to embed HTML in the formula

The following is my formula:CASE WHEN ("F_FS_ALL"."F_FS_ALL - measure">100 AND"Scenario"."Gen2,Scenario"='AR') THEN ||'<img border="0" src="res/s_blafp/meters/icon/rc/red.gif">'|| "F_FS_ALL"."F_FS_ALL - measure"*100 WHEN ("F_FS_ALL"."F_FS_ALL - measure"<100 AND "Scenario"."Gen2,Scenario" ...

Oracle hyperlink in a report

i'm trying to enter a hyperlink in a report. i clicked on f(x) of a field, and wrote:Clicki got the following error: [nQSError: 10058] A general error has occurred. [nQSError: 27002] Near <<>: Syntax error [nQSError: 26012] . (HY000)SQL Issued: SELECT Click FROM "Custom Object 3 Lists"does ...

Oracle error with filter expression

i'm trying to write this in the formula for a column which should give me the results for the previous year. I wrotefilter("Facts - GL Balance"."Balance Global1 Amount" using valueof(YAGO_MCAL_YEAR#1))i get this error.Formula syntax is invalid.[nQSError: 10058] A general error has occurred. [nQSErro ...

Oracle Case Statement in Answers Filter

I'm trying to build a query in Answers that filters the data returned based on the current month number. If the current month is 1 then we want to show all 12 months, otherwise we want to show months less than the current month. If I use the following: CASE WHEN extract(month from current_date) = 1 ...

OBIEE A general error has occurred. [nQSError: 17001] Oracle Error code: 10

1. On Admin tool I'm using oracle OCI instead of ODBC and I'm able to view data on presentation layer2. When I launch Answers, select my Subject area then select fields and when i click on display results, I get the error below.State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] ...

Oracle [nQSError: 46033] Datatype: 25 is not supported in OBIEE Repository

Ive imported a table from sql server into OBIEE repository now the issue is in the physical layer when we on viewdata for a particular coulumn it throws the following error and for the rest of the columns data is coming up.Datatype: 25 is not supportedCan any one suggest the workarounds ?Thanks in A ...

Oracle Password Reset of OBIEE administrator

When I am Login in the OBIEE adminstartion window and opening the online mode it was asking the adminisatrtor passwordI have given password but I am getting below error :nQSError:37001 could not able connect to oracle BI server nQSError :43001 Authentication failed for Administartor in repository st ...

Oracle Reset password OBIEE

When I am Login in the OBIEE adminstartion window and opening the online mode it was asking the adminisatrtor passwordI have given password but I am getting below error :nQSError:37001 could not able connect to oracle BI server nQSError :43001 Authentication failed for Administartor in repository st ...

Oracle OBIEE conection to P6 Analytics

I configured OBIEE to use OraclePrimaveraP6Analytics.rpd, but when I log in instead of all dashboards I can only see an errors such asError Codes: OPR4ONWY:U9IM8TAC:OI2DL65PState: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 23006] The se ...

Oracle Unable to connect to SQL Server 2008 from OBIEE 11G(on 64 bit Linux box)

We are unable to connect to connect to SQL Server 2008 from OBIEE 11G which is on 64 bit Red Hat Enterprise Linux.*************************************************************************************************Infrastructure: OBIEE 11.1.1.5 64bit, on 64 bit Red Hat Linux Enterprise Linux 5.6 , MS S ...

Oracle No script engine supported for 'JScript' error in OBIEE 11G ibots

Infrastructure: 64 bit OBIEE 11.1.1.5 on 64 bit Red-Hat Enterprise Linux 5.6We tried using *.java to export the delivery content of an 'Agent' and place it in a shared folder on Windows.We are able to use the .java file directly in putty and it works fine in creating a folder and copying the file fr ...

Oracle ODBC Error during login to OBIEE 10.1.3.2

OBIEE 10.1.3.2 was installed and a repository was created which passed the consistency check.Now when I go to login into Presentation Services, I get the following error -Unable to Log In Error connecting to the Oracle BI Server: Could not connect to the Oracle BI Server because it is not running or ...

Oracle [nQSError: 46036] Internal Assertion: Condition pExpr->IsValueExpr(), file

HelloThis is my first post so bear with me. I get the 46036 error from Answers when I add a field that I created in the BMM of the RPD. We are on OBIEE 10.3.4.1. I added a logical column to a table and inserted the following expression to filter the business units: "FinanceDW".""."Finance"."PS_CSU_D ...

Oracle OBIEE 11g: Non conformed dimension filter

I have two fact tables and some confromed and non conformed dimensions between the fact tabels.The hiearchies being built and proper levels were set for the fact tables. The measures of the fact were set to the total level of the non confromed dimension tables.The fact also hold some non aggregated ...

how to connect Oracle BI Enterprise Edition(OBIEE) to IBM universe Database

Hi, please i need to know if OBIEE can be used to access an IBM universe database and the steps involved. ...

Oracle Not able to login OBIEE on Linux

I have installed Oracle Business Intelligence Suite Enterprise Edition,v. 10.1.3.3.2 on Oracle linux ES 4..But i am not able to login BI server, when i am try to login to this getting this below error:BI Server is Running and OC4j also running..Error connecting to the Oracle BI Server: Could not con ...

Oracle When are OBIEE certifications going to be up?

Does anyone know when OBIEE certs will be up and what's going to be a price tag? ...

Oracle OCP for OBIEE

Currently, I am working on a project which is based on OBIEE. I am looking for a OCP for OBIEE Admin/Implementation. Please guide me, how to find a suitable OCP and where and also, If I am eligible for any discount as an Oracle Employee. ...

Oracle OBIEE Certification

I just need a little bit of help, I have been learning OBIEE on my own and with a friends help, I feel that I know OBIEE now and would like to go write a certificate, if there is anyone who has written a certificate, please let me know where to go, your help would be greatly appreciated.thank you in ...

Oracle OBIEE certification (BI)

Please assist me which type of certification and levels in OBIEE is avilable and which book I should follow for the certiication As I am working on the OBIEE domai since 6 months.Lokking forward for you positive and earliest responsce Thanks in advance ...

Oracle New to OBIEE?

If you are new to OBIEE and want to learn. Visit my blog and download the video tutorials for OBIEE and Hyperion.learnhyperion.wordpress.com and download the video tutorials -AmitEdited by: user10758781 on Nov 24, 2009 3:09 AM ...

Oracle OBIEE Basic documents

I am new for OBIEE. Any one pls help me for basic documents and send me the documents. ThanksEdited by: user8949151 on 04-Jan-2010 22:08 ...

Which Version of Oracle DB and OBIEE IS FOR WINDOWS 7 , 64 BITS

Can anyone please let me know Which Version of Oracle DB and OBIEE is supported for Window7 on 64 bits, Which version and where I can download from. ...

Oracle link to download OBIEE is not working

i am trying to download OBIEE trial version from the link http://www.oracle.com/technology/software/products/ias/htdocs/101320bi.htmli am trying this since 3 days , but the page does not seem to work, where can i contact to get this to work or if someone knows an alternate link? ...

Oracle Delivers to OBIEE Users

I wanted to deliver reports to multiple users Emails using OBIEE delivers. Here my Client Admin need to schedule the iBots based on his requirment for different target users. I could not able to send reports to multiple users using the Specified user list or Results using conditional request.But I c ...

Oracle OBIEE

If you want to learn Hyperion, OBIEE, Essbase, Planning, Hyperion Financial Management, Hypeiron Brio, Interactive reporting. Please visit my video tutorial to lear Data Warehousing and Hyperion.Download from learnhyperion.wordpress.com ...

Oracle / Hyperion / OBIEE+

Oracle Community,My company (www.harbinger-group.com) has certified consultants available to lead or support your short or long term projects. Practice areas includeOBIEE+System9PlanningHFMEssbaseWe are certified Oracle Partners and located in Minneapolis, MN.We also have Professional Trainers avail ...

Oracle 10g Lite with OBIEE

Does anyone know if I can use 10g lite as the datasource for OBIEE and use the sample SH schema if it is a implemention option? I am trying to get the SH schema into 10g XE to go along with the existing HR sample schema but have not found anything on it so now I am trying 10g Lite. ...

Oracle ayuda con el error[NQODBC][SQL_STATE:HY000][nQSError:10058] estoy aprendien

hola a todos:estoy aprendiendo a usar el BI por lo que al darle update row count en la tabla del diagrama prhysical de oracle bi administrator tool del repositorio sh.rpd me marca el siguiente error [NQODBC][SQL_STATE:HY000][nQSError:10058][nQSError:43093] se ha producido un error al procesar la ins ...

Oracle OBIEE installation Problem.

I downloaded OBIEE v.10.1.3.3.1 from oracle Technology Network websiteand installed successfully. and then installed Oracle Apps 7.9.3 successfully.now want to install third_party_software Informatica Powercenter 7.1.4. here i got the problem. when i clicked the Launch.exe from the informatica_7.1.4 ...

Oracle I can't get Application Express and OBIEE to both work on my laptop

I had just installed and configured OBIEE on my laptop where I had successfully installed Application Express 3.0. Both were working , however, I was having an issue creating a ODBC connection with the "SH" schema. Later I had realised this OBIEE problem was actually do to the fact that the password ...

Oracle [nQSError: 46033] Datatype: 25 is not supported

Ive imported a table from sql server into OBIEE repository now the issue is in the physical layer when we on viewdata for a particular coulumn it throws the following error and for the rest of the columns data is coming up.Datatype: 25 is not supportedCan any one suggest the workarounds ? ...

Oracle OBIEE installation in Ubuntu 9.10

I am new to Ubuntu and am exploring Linux for the first time, I am a developer in Oracle but I want to learn OBIEE in Linux, but some how when I install, it says that the platform should be either RedHat or Suse, I do not know how to proceed further.Please help me as I have made all installation my ...

Oracle Single Sign on when invoking Apex reports from OBIEE(LDAP Authentication)

Is there any way to pass the LDAP authentication details from OBIEE to Apex so that there is no need for users to login once more in Apex Env if they have successfully logged into OBIEE? Users are authenticated via LDAP authentication scheme in both OBIEE and Apex. Version details:OBIEE 10.1.3.4.0 A ...

Oracle [nQSError: 12002] Socket communication error at call=recv: (Number=10004)

Can any1 plz help...!I am unable to start presentation services...! I am currently using windows server 2003 service pack 2. I tried configuring scheduler after which I got the message:"Windows could'nt start Oracle BI Presentation server on local computer. For more information review the system eve ...

Oracle Integrating OBIEE with APEX

I want to integrate OBIEE with APEX, In the OBIEE Application, i have created a cookie for username and passing it in the apex applicatin,while running the apex application, I will get the username , it has to check for the user from a table and if valid, the application should open,without asking f ...

Oracle OBIEE Dashboard Drill Down

I am doing OBIEE dashboard .. I have around 6 regions (shown as coloms). I want to drill down a particular region. The result is that the screen changes to drill down for the particular region only.I want the screen to show the drill down along with other 5 regions data (summary level and not drille ...

Oracle OBIEE and Analysis Services 2008

I'm trying to use OBIEE with AS 2008. The drivers look like they only take 2005 and 2000. Is that accurate? ...

Oracle Login error on OBIEE

I've installed OBIEE and added my custom instanceconfig, created the application on OC4J and even tested the presentation server with "sawserver.exe -c C:\OracleBIData\web\config\myinstanceconfig.xml".Everything works fine. I can open without any problem the repository on the administration tool (ev ...

Oracle Email to OBIEE Users

I have configured ibots and I want to schedule a report to send it to user's running the report. We are on 10.1.3.4 and Authentication is LDAP. while creating iBots in the recipients tab I select the users and save the iBot. But the users do not get the email. I know Our LDAP authentication does not ...

Oracle OBIEE Authentication using Hyperion Shared services

We want OBIEE users to get authenticated via Hyperion shared services11.1.1.3.24. Hyperion shared services internally uses MSAD to getusers and groups. Hyperion shared services has two user directories,one is native directory and the other directory is associated withMSAD. If I understood well, thos ...

Oracle OBIEE javascripts

I am implementing java script in OBIEE report with writeback.I have created a dashboard with a single report and added some HTML and javascript.I have a button at the end of the report when the user click the button a column in the report called Approval flag should be marked as 'Y' for all records ...

Oracle OBIEE on Iphone/Ipad

We are trying to get our Dashboards on Iphone/Ipad. We downloaded the application from the app store, but due to internal security issues, my users cannot all access to the server.Anyway, they tried to access with Safari, but the problem is the menu is not displayed. They can access, see their defau ...

Oracle problem while installing obiee 11.1.1.5

I am trying to install OBIEE 11.1.1.5 in windows xp 32 bit.I downloaded all the disks and now i am trying to install.Disk1->setup.exe when i run i am getting this problem like JRE is not found inside the bin/javaw So pls install jre 1.3.1 or higher.I went to programs->java->I have jre1.6.0_ ...

Oracle OBIEE with JD Edwards

I have a requirement to implement OBIEE with JD Edwards. So, can anyone give me a basic idea on how OBIEE and BIP connects with JD Edwards. Is there any pictorial representation available about the Architecture. Also as JD Edwards can be on different databases such as DB2, Access etc. is there any s ...

Oracle OBIEE Language Issue

We have upgraded OBIEE from 10.1.3.3.2 to 10.1.3.4.1. When a user log in older version default language was coming in english but when user login in newer version his obiee language is changing based on his IE web browser settings (for eg: "finnish" if the IE webbrowser is in "finnish"). We changed ...

Oracle Redirect to an otage message when OBIEE services down

We have OBIEE 11g installed on Weblogic 10.3.3.0 and we have to have an outage message when either BI presentation Service or BI server goes down.Basically redirection to different URL or customized HTML page.I believe there is a customization which possible in weblogic.Can anyone direct me to it? ...

Oracle OBIEE 11g additional table in the generated sql

In OBIEE 11g RPD, we have a fact table whose source table is consisted by table A, B, C. Table A joins to table C while table B joins to tables C. And in the content tab, table C is used to filter out some records . If we select a column of A(The aggregation rule of this column is SUM) in the answer ...

Oracle OBIEE 11g install fails on step 7 (database connect string)

I've currently spent 2 days trying to install OBIEE 11g on two machines (independently). This first is a Windows XP SP3 test PC running 4GB RAM, whilst the second is a Windows 2003 virtual server with 3GB RAM. The Database is Oracle 10g (10.2.0.4.0) on AIX 5.3.The DBA has successfully run the RCU on ...