-
64 bit DAC client/Server not running on same JRE
We installed 64 bit DAC 11.1.1.6.4. While bringing up the server and client, faced issues and nailed down to below. DAC Client is working fine with JRE 1.7 and DAC Server is working with JRE 1.8.x Just wondering is this the correct approach? and would like to know if anyone faced this issue and how it got resolved.
-
BI publisher output directly to printer
Hello there, I hope I am in the right place for my question. In our school, we use BI Publisher to produce our certificates and diploma's. The data is generated from our Student Information System to a BI P report. Currently, the possible outputs that we can choose from are formats like .pdf, .csv, .docx etc. but we would…
-
Quality Management: Pending Approval table does show names for some records
Hi experts, Kindly, end user when there is a quality issues, in front end the process showing it is pending with approver. but when I fetch data by BIP the name is not appearing. Is this a bug or some missing steps are needed here.
-
Oracle Analytics Desktop Publishe Reports
Hi, I'm using Oracle Analytics Desktop Tool for designing and generating a reports and statistics using oracle database as a dataset, the tool is very good but I have some questions. 1 - Why I'm not seeing a publish baton on my tool so I can Publish the dashboards to the web server 2 - How can I publish the dashboards that…
-
How to print child account data in FRS report
I have developed a PL Statement report using the Financial Reporting web studio. This report contains the parent account to display balances. While running it in HTML we can expand to the child account balances but In PDF preview we can see only see parent account balances. Is there any way using which we can get child…
-
how to get sessions from Presentation services in obiee cluster
Hi everyone. I'm trying to monitor Presentation services sessions and cursor cache in Administration->Sessions (saw.dll?Sessions , not Administration Tools application) in Cluster of 3 instances of obips. And it shows me sessions from only one of them. For example: i'got three instances of obips [obips1, obips2, obips3],…
-
BI publisher 10.1.3.4.2 can't connect on Orcale DB 19C
Hi , BI publisher 10.1.3.4.2 can't connect on Oracle DB 19C , anyone have idea to upgarde BI publisher 10.1.3.4.2 to 11.1.1.7 ?
-
Oracle BI Publisher report & data model Audit record
How do we able to know which users is doing the archive and unarchive of the xdo/xdm files in Oracle BI Publisher? Any SQL query to extract for this info?. Thanks....
-
How to Migrate Only Web Catalog From OBIEE 11g to 12C
Hi, Is there any process to migrate only Web Catalog from OBIEE 11g to 12C. I know there is a process to migrate (Create bundle .jar file) the whole bundle which includes RPD, Catalog and security files etc but I don't want to migrate all those stuff. Any suggestions are appreciated on this. Thanks, Federico A.
-
I want create customize filter in otbi report
Hi community, I want to create filter which fetch only data whose start is in coming 3 days, 7 days, 8 days in otbi report. Like this screenshot.
-
OTBI Analysis – Field Not Aligning to Data
Hello, I am attempting to create an Analysis within OTBI for Oracle Recruiting Cloud (ORC) - attaching the catalog file for reference. Although, there is one field which is returning the expected data for each Candidate, but its not being aligned correctly with the other data/fields within the report. For example, it…
-
Could someone please send me a sample of PL/SQL in BI Publisher Data model?
I am going to write a complex report in BI Publisher. I am not sure if I can use PL/SQL in BI Publisher Data Model. If so, could someone please send me a sample of PL/SQL query? Thanks. Simon
-
Is it possible to join dimension tables which are joined to 2 fact tables in BMM layer?
Hi All, Please find the below Physical and logical joins, the data in OBIEE was visible for fields of both dimension tables when it was joining only to Case fact in BMM. But after I joined the 2 Dimension tables to Service Request Fact aswell, after which data is not showing for Dim_WC_SPLN_SRV_OUT_D fields in OBIEE. How…
-
BIP Template issues
Hi I am currently building a BIP template and am facing an issue. The template is base on the customised data model of Collections Aging by Collector 7 bucket report. I have adjusted the datamodel to bring in one extra column called BUSINESS UNIT. This value sits at invoice header. Now the seeded aging report gives me the…
-
Extra Blank page in BI publisher output
Hello All, I am novice to BIP and need some help.After uploading the RTF ,i m getting blank page in report output .Any help or idea is appreciated Thanks, Raj
-
BiPublisher Sum within group Causing Error / Crash?
I am utilising bipublisher with oracle intelligent advisor. I have the following group over 3 fields. "Rate Card Item Description" "Quantity" "unitCostP3Final" The grouping is working as is the summing on the quantity field, but when I try to sum the unitCostP3Final field, it is crashing. Quantity is mapped in, where as…
-
Informatica to ODI mappings conversion
Do we have OOTB utility which will convert informatica mappings to ODI mappings
-
OBIA 11.1.1.10.3 on linux domain-registry.xml not found
Hi team, I am currently installing obia 11.1.1.10.3 on linux and i am facing an error when trying to Configure Oracle Analytics Server When i am trying to execute the step below, i am receiving an error mentinning the file domain-registry.xml not found Error: Could not find or load main class –jar[xxx@xxxxxxxxxx scripts]$…
-
OBIA 11.1.1.10.3 support with ODI Market place
Hello All, Does OBIA 11.1.1.10.3 support with ODI Market place? If so how the repository sync and BIACM wiring will happen. Please confirm. Aiswarya G
-
ORACLE OBIEE 12.2.1.3 Integration with Oracle EBS 12.2
Hi All Can anyone help me to get any documents/support ID's to integrate OBIEE 12.2.1.3 with EBS 12.2.. Am not seeing any. Thanks in Advance Kai Schikum
-
OBIA 11.1.1.10.3 - Install bundle patch question
Hi Team, I am currently installing OBIA 11.1.1.10.3 and the documentation is mentionning to Apply Mandatory Patches. Source : https://docs.oracle.com/applications/biapps103/install/GUID-66B98B0E-11F9-4DAE-9C1F-947BBB805B39.htm#BIAIN-GUID-7CE11331-50EA-4D8D-97F2-83E834AB8936 So one of the patch downloaded (Coming with the…
-
BI Publisher Desktop MS Office 365 - Cannot View BIP Properties Window
I regularly use the BI Publisher Desktop plugin to create RTF report templates in MS Word 365. When I double-click an existing field, BI Publisher Properties will not open. Same scenario when I try to right-click -> BI Publisher -> Properties. I tried uninstalling both MS Word and BI Publisher add-in but was still not…
-
OBIA Support with OAS MarketPlace
Hello all, Does OBIA has any plans to support OAS on Marketplace and ODI on Market Place? Thanks Aiswarya G
-
Merging Transaction Lines
I am running transaction reports from Oracle Transactional Business Intelligence. The produced report includes various lines which net to £0 as well as minor adjustments for tax, delivery, roundings etc. I was wondering if it is possible to create a transaction list report which merges these transaction lines? For example:…
-
Upgrade OBIEE to OAS within 11.1.1.10.3
Hi there, Any experience in upgrading OBIEE 12c to OAS in an existing OBIA Deployment? I did already a standalone OBIEE Upgrade, but cannot find any reference how to do this with OBIA. Should I reinstall ODI in the new WL Instance? Any hint is welcome. Ciao MP
-
Does BICC Support CPQ?
We use Oracle Cloud CPQ, and I am trying to discern if there are data stores for this system in BICC?
-
Mouse over text / tooltip not working as expected after upgrading OAS 5.5 to 6.4
Hi, After upgrading OAS 5.5 to 6.4 (in-place), we're seeing dashboard formatting issues - 1) Mouse over / tooltip text is not displaying properly, its getting displayed as a text in report. After referring few MOS / google , tried to set HardenXSS in instanceconfig.xml, however its not working, had to remove it and start…
-
Is there a limit on number of parameters that can be added to a BIP report/Data Model?
Hi Team , There is a need which requires fields to be taken from middleware and passed as a parameter to the BIP. So wanted to know the maximum no of parameters that can be added to a BIP report if exists.
-
Segmentation in OAS 6.4
Hi there, anyone as tried to activate the segmentation functionality in OAS 6.4? I'm going to perform a PoC for a customer and would like to collect any experience done. Thanks for any hint! Ciao MP
-
Where is the Developer documentation for OAS 6.4?
Hi there, anyone found the developer Documentation for OAS 6.4? I went to the usual site but under developers guides there are still the old OBIEE 12 documents describing the SOAP Services. Are they still there? Happy to work with it. I thought the new integration is done through REST services. Any hint is welcome. Ciao MP
