-
SQL server configuration in obiee11g
Hi I have created ODBC driver with SQL server native client 11.o and named it as DBDEV and in ODBC.ini file gave below ,But services are not getting started. How can i configure sql server. Can anyone suggest [DEVDB] Driver=/OBIEE11gHOME/Oracle_BI1/bifoundation/server/bin/libnqsodbc64.so Description=DEVDB Address=IP,1433…
-
OBIA 7964 with info 10.2 hf1
Dear Experts, I am plan to install all the below software's in the below format bcz of my current OS expiry could you please provide your suggestions. on MS windows server 2012 r2 OS Server1--->BI APPS 7964 & OBIEE 11.1.1.9.0 & Informatica Power Center 10.1.0 or 10.2 hf1 & DAC 11g Server2---> MS SQL Server 2012…
-
inforamatica/DAC
Hi Experts, Anyone has idea about informatica license cost ? all prebuild mappings will work in new informatica tool ? we just wants to use all prebuild mappings and data for other reporting tool? Could you please share your suggestions Thanks!!
-
Dac Connectivity Issue with SQL Server
Hi All, I am trying to connect DAC with SQL Server, but I am getting following Error. Can you please help me understand what I am doing wrong in this. "The driver could not establish a secure connection to SQL Server by using Secure Sockets Layer (SSL) encryption. Error: "java.lang.RuntimeException: Could not generate DH…
-
Standalone BI Publisher Instalation
Hello all, Maybe someone can help me with a doubt. I have a BI Publisher standalone instalation on version 12.2.1.2.0 and i need to upgrade / patch to version 12.2.1.4.x . I didn't find any information or patch to do this. It is even possible? Can someone point me a document, if any exists? Thanks
-
DAC issue. [[REP_57060] Login failure.
Hi, Need some insight to below error. [[REP_57060] Login failure. [UM_10016] [UM_10016] The Service Manager failed to authenticate user [Administrator] belonging to domain [Native]. The specified user name or password is not valid.] [Failed to connect to repository service [Oracle_BI_DW_PROD_02].] An error occurred while…
-
OBIEE 12c With OBIA 7964
Hi Experts, Anyone implemented OBIA 796: Support of BI Applications 7.9.6.3 & 7.9.6.4 with OBIEE 12.2.1(12C) ( Doc ID 2087632.1 ) Dual headed Planning to install and upgrade OBIEE 11.1.1.9.x OBIEE 12.2.1.4.o OBIA 7964 sql server informatica 10.1 dac 11g on windows server 2012 r2 could you please share suggestions!!
-
OBIEE, OBIA, INfo, Dac, sql server on 2014
Dear Experts, Planning this setup on windows server 2012 r2, same setup will be work for windows server 2016 ? ================================== Informatica Power Center 10.1.0 with DAC 11g MS SQL Server 2012 OBIEE 12.2.1.4.0 OBIEE 11.1.1.9.0 with BI APPS 7964 ======================================= Please send your…
-
OBIA: (Doc ID 2515201.1)
HI All, The below extended support date will applicable for OBIA 7964 customers? Lifetime Support Policy: For the planned new point release, Oracle plans to extend Oracle BI Applications Lifetime Support Extended Support dates an additional two years to at least June of 2023. Thanks!!
-
Business Intelligence
Good morning. The graphs of the analysis are not shown, neither in design nor in execution. Attached image Buenos dias. No se muestran los graficos de los analisis, ni en diseño ni en ejecucion. Imagen adjunta
-
Need to create an analysis showing customers that never spent in previous years
Hi Need your help I Need to create an analysis showing customers that never spent in previous years, prior of 2018 but spent in 2019...basically need to show only new (this year) customers. Thanks Joe
-
Export isse for date columns in excel for OBIEE 12c.
when i am exporting the data into excel in OBIEE 12c my date columns are showing as numbers. I have used the custom formatting for my date fields and my business needs the data to be shown in custom format only.The below oracle Doc is asking me to change the format of the date column to default which my user is not…
-
DAC - stopping Queued or Runnable Execution Plans already in the Current Runs
I want to stop an Execution Plan that hasn't started, but is already in the Current Runs, in either the "queued" or "runnable" status. 1. Abort - can't abort before a plan is running 2. Tasks - can't change status of tasks because until the plan starts to run, the tasks do not display 2. Scheduler - scheduler sees these…
-
Oracle DAC metadata help
Hi Team, How to find the physical folder link with logical folder in Oracle DAC. I searched in W_ETL_FOLDER, but didn't get how to link the Logical folder with Physical folder. Thanks in advance. Regards, Moses Palla
-
Unable to Extract data Receivables-customer real time, Receivables-Adjustment Real Time in OTBI Repo
Hi All, I have a requirement with one of my user asking to create an report in OTBI by using these two subject area (Receivables-customer real time,Receivables-Adjustment Real Time). Receivables-Adjustment Real Time--We have some columns or fields like (Ledger,Fright details,ledger currency and Business Unit..etc) but in…
-
PDFDocMerger API Does Not Show Data Correctly If We Merge Too Many Files
Hi OBIEE / BI Publisher 12.2.1.3 We are using PDFDocMerger API from xdocore.jar to Merge PDF Outputs API Works fine with 2 or 3 PDFs as Input. But when we are merging about 30+ files into one output, the Merged Output is not showing the Data properly We have a combination of RTF and PDF Templates which generates these…
-
How to do Oracle Data Visualization Plugin Install Row expander
Hey Iam new to data visualization. I need to add Plugin Install Row expander. In the document it is mentioned as Upload the zip file as is using the option in console in your Oracle DV, then restart DV. Can anyone let me know where to upload the file.Appreciate your help.Thanks.
-
BI APPPS ODI code logic
Hello All, Good day..!! I came across an OOTB code which is being used by ODI and trying to understand the logic it's being used. but not able to understand fully. Any help in this regard is really helpful to me. ODI Code:…
-
Customize OBIA Financial Analytics GL Ledger Account
Hi Community, Im new to OBIA (11.1.1.7)11g integrated with ODI. Can you please assist me with updating the mapping or scenario for the Ledger Account. I want to update this mapping so that we only extract one Ledger account for example WB Ledger IV. Please assist with steps to achieve this. Thank you.
-
Connect Bi Apps to new source database
Hi All, We have a Bi Apps Dev instance that has been connected to an EBS Dev instance (as the only source database) for a very long time - version12.2.5. We now need to connect it to a different development instance. What are the steps to do this? Is there any documentation available? Also, would it be necessary to do a…
-
Excel Plugin Oracle Smart View hangs on Data load
We have recently installed Oracle Smart View add-in to MS Excel and when using "Insert" option to bring in an OBIEE Presentation report into Excel, it hangs forever. I have modified the HKEYs and added DWORD key values, ReceiveTimeout, KeepAliveTimeout, and ServerInfoTimeout and also I have added the Smart View directory…
-
Schedule a prompted agent
Hi, I would like to create an Agent to deliver a report in OBIEE 12c - 12.2.1.3.0 but any suggestions on how to handle the prompted part? How can I have the User select the prompts before it can be scheduled? Do I give access the User to the Agent? Do I create some sort of Action on a Dashboard that captures Users input…
-
Snapshot for transactional data in BI Admin Tool
Hi, I am fairly new to OBIA / OBIEE / ODI. I am working on importing custom tables from EBS (through ODI) all the way to be used in reports and analysis in OBIEE. I have done this, however, these custom tables imported from EBS are 'kill and fill' tables and there is no trend or snapshot data that gets stored. I want to…
-
Oracle Service Cloud data preparation failure in Oracle Analytics Cloud
Hi Community. I'm trying to bring data from an Oracle Service Cloud instance to Oracle Analytics Cloud. But when I ask for a data preview it brings me the following error: ODBC driver returned an error (SQLExecDirectW).State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has…
-
Execute in connect statement not getting picked
Hi, I have been trying to use the execute on connect feature to run the query alter session set query_rewrite_enabled = force However it is not getting picked as I am checking in the nqserver logs. have been stuck on this for days. any help would be appreciated.
-
Bi Admin Tool crashing in "consistency check"
Hi All, I am trying to run the 'Check Global Consistency' on my RPD, but it keeps crashing. It happens at the same place ('Search fro Empty Keys' | see below images). This started happening after a patch merge, where I was attempting to merge together our customizations with a newly upgraded RPD (10.2, from 10.1). Likely,…
-
OBIEE 12c Graph with Date on Y axis
I am trying to create a graph where I want date on Y axis. ( something similar to timeline ). Is it possible to achieve in OBIEE?
-
How to display horizontal pivot section on OBIEE11g or OBIEE 12c
Hello I use script from link:http://obiee101.blogspot.com/2010/01/obiee-horizontal-pivot-sections.html but it doesn't work. It seems that this script is working for OBIEE 10g only. Anyone, Please suggest me. Thank you.
-
NQsserver memory not releasing
Hi All, We have noticed Bi Server (NQsServer) memory taken 36 GB. (Total 64 GB RAM) Most of the times noticed NQsserver not releasing the memory used on production windows server. Please let us know what could be the reason. I see no long running queries, stuck threads. all the services are up and running fine and…
-
OBIA 11.1.1.10.2.0 Configuration failed at 2% deploying applications presentation server
Hello All, DB:- oracle 12.1.0.2 I was trying to install and configure OBIA 11.1.1.10.2.0 in windows, all patches and other got succeeded. When I came to configure BIapps "ConfigApp.bat". It got failed at 2%. Here in log , it is showing invalid username/password, however I could connect to oracle by using same password,…
