-
An error occurred during execution of "connect". Connection refused [Socket:14]
We have integrated OBIEE with EBS R12. In our DEV instance, unable to OBIEE, the log file is showing below error message OracleBIData/web/log/sawlog7.log An error occurred during execution of "connect". Connection refused [Socket:14] --------------------------------------- Type: Error Severity: 42 Time: Fri Apr 26 12:54:07…
-
OBIEE SCALE OUT: with out admin will secondary server runs and takes over the control if primary ser
DOC followed to perform Scale out: Configuring High Availability for Oracle Business Intelligence Applications Version 11.1.1.8.1 (Doc ID 1679319.1) we are successful in creating new server for BI_SERVER as a failover (scale out). i'm seeing BI_SERVER2 and instance2 folders created in my backup server, but not Admin server…
-
BI Publisher 11g to 12c - PDF output contains hyprlink, but that link displaying in two lines after
Summary BI publisher migrated reports from 11g to 12C, Hyperlinks are displaying in the two lines when it contains dot. Content Hi All, we have migrated BI publisher reports from 11g to 12c. All these reports we using RTF file for design and displaying outputs in PDF format. My reports contains hyperlinks, those are…
-
"Disabling" a connection pool does not appear to be working in OAC 12.2.5.1.0
I was under the impression that OBIEE uses the first listed and available connection pool when executing queries, so that if I set No Access permission for the first listed connection pool it would not be used at all. However, that is not the case. This connection pool IS being used. My connection pool list looks like…
-
Priority in business model
Hi everyone, I have question about model in business layer. Let's assume that I get model like: F1 and F2 - facts tables D1 and D2 - dimension tables My question is: Can I set priority for this model that when I use columns from F1, D1, D2 I want that BI generate SQL Query without join between D1-D2? It is mean - when I…
-
Can we use group by when using Filter function?
I have this two metrics that I am adding together but i also wanted to group the results set by employee ID, however i cant figure out how to use the group by with my filter function. any suggestions? FILTER("Fact - Ap"."# Applicants" USING ( "Details"."Active Flg" = '1' )+ FILTER("Fact - "."# of Applications" USING…
-
User Session Expiry Enterprise Manager
Hi Team, Please advise on the below property in Enterprise Manager. User Session Expiry Reducing the user session expiry time will increase performance as resources associated with the session can be released to service new requests. The downside is that users will be required to log in more frequently and can lose…
-
How many BI enabled Objects can be there in Oracle fusion ?
Is there any limitations to BI enabled objects in fusion ?
-
OBIEE 12.2.1.4.0 Webcat Report unable to generate complete info on Dashboard prompts
Hello Experts, We have OBIEE 12.2.1.4.0 on Linux. We have created some dashboards (having prompts based on both column and variables) . And we used the presentation variables (for eg: ORD_DT ) in the filter of the analyses to restrict the data fetched. Generated the webcat report, by connecting to the Catalog offiline ,…
-
"Invalid subscribers skipped" Error after upgrading to 12c
We recently upgraded from OBIEE from 11.1.1.7.150120 to 12.2.1.3.0 and some users are experiencing issues with receiving agents. It only seems to affect a few users. When I try to run the agent with one of these users included, I get the below error. It doesn't matter if the user is directly added to recipients or…
-
Accounting Format in OBIEE
I'm writing a series of analyses that include dollar amounts, and the stakeholders wish to use a specific accounting format. However, I have not yet figured out how to do this in OBIEE. For cells with dollar amounts, only the first row and totals/subtotals should have a dollar sign. The dollar sign must be left-aligned,…
-
export service instance fails
Trying to create OBIEE 12.2.1.1 Service Instance fails and results in the following error message: Any ideas on how to resolve this? Initializing WebLogic Scripting Tool (WLST) ... Welcome to WebLogic Server Administration Scripting Shell Type help() for help on available commands Starting Export Service Instance…
-
Limit access to subject area with Answers but not in Dashboard in OBI EE 12c
Hi, I have users which have access to answers. I want to restrict to these users access to specific Subject area but still allow them to see created reports from this Subject area in dashboards. I cant find any solution. I still want to allow them to use other subject areas in answers but if I restrict access to some…
-
How to apply sum on columns from dimension table in RPD?
I have two tables in each of the three layers in RPD: table A (fact) and table B (Dim) joined by line_id. They are setup as separate logical table source. There is couple of fields from table B (dim) that I want to apply sum on in the rpd in other words I want to define them as measures. How do I achieve this correctly in…
-
How to do prediction analysis on the basis of two variables in OBIEE 12C using forecast function?
I am trying to use R model in OBIEE 12C and want to predict collection of the Company on the basis of Sales of the Company.But I am facing challenge where one variable is impacting the other.For only sales or collection we can predict but not collection with sales impacting it. Regards, Abid
-
Burndown Chart in OBIEE 12C
Dear GURUs, I'm using the latest version of OBIEE 12.2.1.4 on-prem on Windows 2012 R2 Server. We have some new requirement where the user wants to use Burndown Chart to represent the estimated and actual values for his Team. The question is: Is it possible to create a Burndown Chart in OBIEE 12C? If not, what is the…
-
[nQSError: 17010] SQL statement preparation failed
OBIEE ver. 12.2.1.2 Need help on this .. the report always failing with this error : OBIEE Analytics show this: Error Codes: OAMP2OPY:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P Odbc driver returned an error (SQLExecDirectW). State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A…
-
OBIEE - compare dates in two reports
Report A & B each consists of two columns...Key & Transaction Date. I want to create Report C consisting of the Keys in report B where the Transaction Date in B for that Key is greater or equal to the date for the Transaction Date in A for that Key. Report C filters The Key matches Report A The Key matches Report B The…
-
Clear some elements on the home page
Hi All, Is there a way to clear some of the elements/objects from the home page? Say, the "recent dashboards" and/or "most popular" for example. We're trying to take screen shots for some documentation and would like to have to home page cleared out (at least initially) ... OBIEE 11.1.1.9.x Regards, Charles
-
Upgraded to OBIEE 12c, and now cannot add subtotals while on dashboard.
We just upgraded from OBIEE 11g to 12c. Everything seems to be working fine, however we are running into an issue on some reports. Normally while on a dashboard, you can click a column to add in subtotals. On 12c this functionality only appears to be working for some reports but not others. See attached screenshots. You…
-
OBIEE 12.2.1.4 Visual Analyzer
Hi, I am unable to see any objects in my Visual Analyzer Favorites and Projects sub tabs under the Projects section. When I add a project to Favorites it says "XXX has been added to Favorites", but it doesnt show up on Visual Analyzer Favorites section. I can see it under the OBIEE home page Favorites. Has anyone come…
-
Embed .pdf icon into .rtf output document (BI Publisher)
Content I have an .rtf (being used for embedded BI Publisher). I would like multiple .pdf's to pull into the final .rtf output document, based on the locations listed in xml data. See Pic for example. I have a dynamic XML file that will contain several file locations. I would like these files to be embedded into the .rtf…
-
Attribute over aggregate function shows an internal error
Summary In simple cases when an attribute function is used over another aggregate function, it works fine. But when the same aggregate is put inside a case when statement, the calculation shows a syntax error Content Hello, I am working on a dataset as follows : When I use aggregate function inside an attribute function,…
-
OBIEE issue while integrating with EBS
Hi dears, Kindly be infomred that we are facing an issue while we try to integrate EBS users with Oracle BI as after we have done the standard configuration we can't login to oracle Bi using EBS users. also note that we have checked below documents: Note:1338007.1 How To Configure OBIEE 11g To Authenticate Using a Database…
-
Track Usage in OBIEE 12c based on a prompt value chosen
Hi, We have a requirement to create an usage tracking report which should show values based on the prompt chosen on the dashboard. Currently we created a scenario where we have a presentation variable created for the prompt whose values need to be tracked and are passing it's value to the report. As it is a presentation…
-
NTile function behavior inconsistency between DV and Oracle database
Content Hi, I am trying to create some data buckets using the NTile function in data visualization, but getting incorrect result when its trying to distribute similar values into different buckets. I have cross-checked it with NTile query function result from oracle database and they don't seem to match. I have attached…
-
Calling BIP report with hyperlink issue
When customer use the hyperlink to navigate to a address like "baidu://message/?sid=&&id=DS_1207" in rft. The address was changed to "file:///u01/oracle/config/mserver/bi_domain/baidu:/message/?sid=&&id=DS_1207" when view the report. Tried to create a form field as below: <fo:basic-link…
-
How to connect On Premise Essbase to OAC
Summary How to connect On Premise Essbase to OAC Content Hi, We need to connect OAC (Autonomous) to Essbase Database which is located in On - Premise Environment. Can connectivity can be achieved by using datasources via RDC? Regards, Paresh
-
Does OBIEE have public facing capability?
OBIEE 12c. One of our departments want to provide data and maps on a public facing web page, for anyone to look at. Is this possible? If so, can someone point me in the proper direction as I have been unsuccessful at googling it. Thanks in advance for any help.
-
Data-Sync New/Updated files not moving to cloud
Summary Load Strategy New/Update not moving new / changed files Content At 7 AM this morning my job ran. My load Strategy is set to (Update Table - Add New - Update existing). My filter is V_Last_Update_DT. Zero records were copied up to the cloud. (select to_char(max(last_update_dt), 'mon-dd-yyyy hh:mm:ss') dt ,count(*)…
