Questions tagged [oracle-bi]

Oracle Business Intelligence Foundation Suite, a comprehensive, modern and market-leading BI platform provides the industry's best in class platform for ad hoc query and analysis, dashboards, enterprise reporting, mobile analytics, scorecards, multidimensional OLAP, and predictive analytics, on an architecturally integrated business intelligence foundation.

Oracle Business Intelligence Foundation Suite, a comprehensive, modern and market-leading BI platform provides the industry's best in class platform for ad hoc query and analysis, dashboards, enterprise reporting, mobile analytics, scorecards, multidimensional OLAP, and predictive analytics, on an architecturally integrated business intelligence foundation.

This enabling technology for custom and packaged business intelligence applications helps organizations drive innovation, and optimize processes while, delivering extreme performance.

http://www.oracle.com/us/solutions/business-analytics/business-intelligence/overview/index.html

94 questions
9
votes
1 answer

How to print escaped HTML characters in Oracle XML Publisher

I am using Oracle's XML Publisher (based on Oracle XML Parser 10.1.0.5.0) to generate reports from my db using an .RTF template. In my front end the user enters some values in a CK Editor like the following image: In the database the values are…
MaVRoSCy
  • 17,747
  • 15
  • 82
  • 125
4
votes
1 answer

Creating rtf template with multi spreadsheets(excel)

I have created a data template report(xdodtexe) and the output will be in excel with multiple spread sheets. My E-Business Suite version is r12.1.3 and I am using Office 2013. I have created an rtf and in two separate pages layouts are there. For…
user3493180
  • 43
  • 1
  • 2
  • 5
3
votes
0 answers

Resources not properly loaded on Oracle BI Web Service

I am trying to create a Java + Maven app that uses the Oracle Business Intelligence (BI) Web Service to render an analysis using HTMLViewService. So far I've been using the GO URL without problems, but I want to migrate to Web Services for security…
actunderdc
  • 1,448
  • 2
  • 11
  • 20
2
votes
1 answer

Setting a data format common to all analysis in obiee 12c

Is there any common configuration in OBIEE 12c , which allows to define decimal places applicable to all analysis? For example,presently, if you want to set the decimal places for currency column, you need to take the data format of that column and…
2
votes
1 answer

create hierarchical table in oracle database

this is my query to construct a hierarchical table to use in oracle bi actually I use it in my subject area. but sometimes when I drill down with value label my analytics is display no result but when I drill with header label it work fine!!!! also…
GhostMan
  • 63
  • 13
2
votes
1 answer

How to solve adfContext leak on oracle-bi or enable adfContext finest logging?

In our Weblogic server log we get "ADFContext Leak" error and our app freezes. How to enable ADFContext finest logging on oralce BI? Or how to solve this ADFContext leak?
mehdi shahdoost
  • 1,469
  • 5
  • 17
  • 27
1
vote
0 answers

Oracle Analytical Desktop Variable Prompt issue

Before Saving After Saving In Oracle Analytical Desktop, I am using Variable Prompt (Custom Visualization), After saving my canvas the dropdown values of Variable Prompt Disappear .Only the selected value left in the dropdown. OAD can't retain…
1
vote
1 answer

OTBI analytical function to get Yes or no for an employee according to another column value

My OTBI(Oracle Transactional Bi report) report have the following columns - Person number Date_to comp profile_updated 10 10-jan-2021 Specialization Y 10 …
SSA_Tech124
  • 577
  • 1
  • 9
  • 25
1
vote
0 answers

Unknown error while importing .dva file in Oracle Analytics Server 5.5.0

I have a problem while I'm trying to import a .dva file generated from Oracle Analytics Desktop into Oracle Analytics Server. It speems that it doesn't come from any specific dva file, it happens with all the files I try to import. For example, the…
1
vote
0 answers

String index out of range oracle bi publisher

I'm download .xml from Oracle apex > Shared Components > Report Queries and open with oracle BI addon in MS Word. XML is successful loaded I'm add header text and change column name and save as .RTF file. After import .RTF file in Oracle apex >…
Pointer
  • 2,123
  • 3
  • 32
  • 59
1
vote
2 answers

Nested loop in Oracle BI Publisher .RTF template

I have two nested loops each one use a different node to get data: 1) 2) Looping with the first group for each target_test I generate a page of report and with the…
Sharknado
  • 27
  • 1
  • 6
1
vote
1 answer

Oracle Forms 12c integration with BI Publisher

There is a tutorial that explains in detail, how is the integration of oracle bi publisher with oracle forms 12c. Oracle forms 12c comes with the possibility of integrating oracle reports as well as oracle bi publisher, it would be very helpful if…
1
vote
1 answer

Error with group by expression?

SELECT DISTINCT dha.order_number, dha.ordered_date, dha.org_id, houf.name Business_Unit, dha.TRANSACTIONAL_CURRENCY_CODE, dla.ORDERED_QTY, …
besho_Demian
  • 31
  • 1
  • 9
1
vote
1 answer

Oracle BI: how can i retrieve another result list from current result list

I am using Oracle Business Intellgience (12c) and let's say I have a report resulted from an execution of the following query select code_filial, max(paid) as maximum_pay from leads_history group by code_filial It will return a table with highest…
Sherzodbek
  • 170
  • 1
  • 20
1
vote
1 answer

OBIEE 12c : Facing issue in getting the components started(Could not load CSF library)

I am facing few challenges when performing a fresh installation of obiee12c(12.2.1.3) in our test environment(RHEL6). As soon as i installed and ran the configuration utility for obiee, we see the following components has not been started after…
1
2 3 4 5 6 7