-
OBIEE 11g; Export to PDF blank page
Hi all I am exporting a OBIEE 11.1.1.7 dashboard page to PDF by making use of the Print -> Printable PDF functionality. The export however results in one blank page. The dashboard page consists of 2 pivots. One is +- 300 lines and the other +- 10 lines across 8 columns. So the data volumes are not large at all. The smaller…
-
Edit AdvancedPlanning.rpd using BI administration tool for APCC setup
Hi Experts, We are trying to setup APCC with VCP (12.2.6) and OBIEE 12.2.1.2 . Reference : https://docs.oracle.com/cd/E26401_01/doc.122/e48790/T573002T573093.htm When trying to update AdvancedPlanning.rpd in BI Administration Tool, to save the changes, it challenges to confirm password and even after giving the right…
-
OBIEE 12C : libnuma.so.1: cannot open shared object file
After installation of OBIEE 12c in RedHat Linux I am getting following error from my essbase reports. Appreciate your help on this. Odbc driver returned an error (SQLExecDirectW). Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general…
-
Cusotmize ports in OBIEE 12c
Hello All, In OBIEE 11g we had the option to specify specific ports using the staticports.ini file during the installation. In 12c though, we only have the option to specify a range for the ports (while installing). Is there anyway the ports (including the admin server and managed server) can be changed? Is there a work…
-
How can a put a filtered Value in a title
Hi everyone , Can i put a value in a title ? or alone in a title ? Thank youuu
-
sort order default not staying default when changing date prompt
Hey everyone, I'm having a really strange issue that i've never seen before. Basically i've created a report which happens to be a union report, and set a sort order on a pivot table to be smallest to largest on one of the columns. When i run it on a dashboard for the same date that i used to test the sort while building…
-
An Expression Filter of a date ( between sysdate and sysdate +6 months)
Hi everyone, I am new in OBIEE , i want to create an expression filter of a date that should be between Current date and Current date + 6 months My question is : What is the fonction for Current date + 6 months ! Thank youuu
-
OBIEE 11g to 12C migration error
We have created the export bundle using bi-migration-tool.jar in 11g. when we tried to import the bundle into 12c we got below error : Unexpected error during import: Target 'D:\oracle\OBIEE12c\Middleware\Oracle_Home\bi\bin\..\..\ user_projects\domains\bifoundation_domain\config\fmwconfig\biconfig\OBIS\NQSConfig.INI' not…
-
Max, Min, Median not working as expected ??
Summary Max, Min, Median not working as expected ?? Content Hello, I'm quite new to Oracle DVD I've just tried the Max, Min and Median calculation but they seem not to work they all gave a simple sum my version is Version 12.2.2.2.0-20170208162627 any idea ??
-
Printing in duplex mode using pasta in EBS R12.2.5
Summary Printing in duplex mode using pasta in EBS R12.2.5 Content I am trying to print a PDF in duplex mode onto a HPLJ4SI printer. We are running on R12.2.5, redhat Linux I have done the following: a) Created a new printer driver PASTA_TC_LEGAL which uses PSTLL SRW driver and has the following arguments:…
-
Mixed font fields in RTF templates
Summary Mixed font fields in RTF templates Content I am building PDF reports using Oracle Reports => XML => PDF (via MSWord RTF). I have a business requirement to display a text field some of which I want to be BOLD and/or italicized. I would prefer to store the text source in FND_NEW_MESSAGES with embedded escape…
-
ORA-12154: TNS:could not resolve the connect identifier specified at OCI call OCIServerAttach
Dear all, i am following the below tutorial http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bi1221/rpd/rpd.html#section4s4 i am using OBIEE 12c. under the section, Creating and Running Analysis, under step 8, i receive the following error message Odbc driver returned an error (SQLExecDirectW). Error…
-
obiee12c VA error
Hi Team, We I try to build VA project in version 12.2.1.2 using subject area or Excel data set i am getting below error. [2017-04-11T06:16:21Z] [OBIPS] [ERROR:10] [] [saw.httpserver.processrequest] [ecid: 1d48af96-6039-47ba-8a03-f04f3acc3148-0000241e,0:1] [tid: 430212864] [SI-Name: ] [IDD-Name: ] [IDD-GUID: ] [userId:…
-
OBIEE Collabration feasibilty
1. Should allow all users to engage in conversation,act on data and share knowledge? 2. Annotation - Should allow to add comments and needs to reports? 3. Conversation - Should allow users and colleagues to easily engage in conversation about key metrics. And should allow reports and associated comments to attain better…
-
OBIEE 12c - Configuration Error
Hi All, I am trying to install OBIEE 12C on Windows 8.1. I have already installed OBIEE 12C on my laptop but somehow I was getting error regarding JAVA_HOME. I uninstalled everything including JAVA and started a fresh installation. However when I am starting the BI configuration, It is failing all the time. Below is the…
-
How to export the existing BI reports and import them after a fresh BI installation.
Hi Everyone How to export the existing BI reports and import them after a fresh BI installation. Regards Sangita
-
Graph X-axis rotate in BI-MAD 11g
Hi, 1) By default MAD rotate the attribute on right side (x-axis) which I want to change on left side. However there is not properties to do that. 2) My requirement is like below image( left rotate). Is any way to achieve this ? Thanks
-
BI Publisher two pager RTF Template
Summary BI Publisher two pager RTF Template Content Hi, I am trying to create two pager RTF template (Job Appointment Letter), with data model having 1 field named Employee Name (having 5 records). I want to print Employee Name on first page and a paragraph (Terms and Condition) on second page. I tried it by adding Text…
-
Link Data Visualization to EPBCS or Essbase
Summary Link Data Visualization to EPBCS or Essbase Content Hi guys, It is a generic question. How do you link Data Visualization to EPBCS or Essbase? I am starting to use DV. Any suggestions? Thanks.
-
BI Publisher Report is adding duplicate carriage returns
Summary BI Publisher Report is adding duplicate carriage returns Content I developed the RTF template offline and imported xml data. The preview to PDF looks good. After uploading Template and running report on-line, the description field is repeating carriage returns. Example of what it should look like Hi Joe, First…
-
Deploying the EJB Application (EAR File) Using the WebLogic Server Console To generate report in PDF
Hi All, I referred Doc ID 1610118.1, for implementing EJB Application to generate reports in PDF format and saving it in shared drive. But I am still getting attached error while invoking Java Method. Please help to resolve this Thanks in Advance.@terry.williams
-
Need help on RTF calculation
Summary Need help on RTF calculation Content Hi, I want to have the page counter decreased by 1 in RTF template I tried using <?xdofx:(<?fo:page-number?>-1)?>, not working Appreciate if somebody can help with correct Syntax that i can use in RTF
-
BI Publisher - Scheduler page not appearing.
Summary BI Publisher - Scheduler page not appearing. Content BI Publisher - Scheduler page not appearing. Dear All, We are trying to schedule new reports from BI Publisher. However while we click the Schedules tab, it is displaying "The website cannot display the page". Also when we try to schedule a report we are able to…
-
RTF page break to make a copy, page numbering not working
Summary RTF page break to make a copy, page numbering not working Content Hi all, I have an RTF template for a picklist and I want to print each pick slip number twice; one original and one copy (with copy in header) for each pick slip number. So I added a page break but my page numbering is out of order. I get with PAGE…
-
Date as a dropdown in report filter
Hey Gurus, Customer is interested in having a dropdown for a field which is a date datatype. By default all dates are given a calendar in the filter by obiee. Converting date to CHAR would give us the dropdown option instead of the calendar. this will lead with issues in filtering. example of calendar in filter instead of…
-
BI Publisher Page Break Issue
Summary BI Publisher Page Break Issue Content Hello, I am working on a rtf invoice template. I am having issue in printing the notes at the end of each invoice. To explain in detail, I am running the report for two invoice number. the rtf will generate in 2 different pages, one for each invoice number. Now we got a…
-
Usage Tracking (Kibana and Elastisearch)
Would anyone happen to have screenshots for a walkthrough on how to set these up?
-
OBIEE 12c bi_server1 and BI services difference
Hi, I'm confused what's the difference between the managed server (bi_server1) in Weblogic/EM and the 5 BI services (OBIS1, OBISP1, etc) in EM. Is the bi_server1 like a container for the 5 BI services? When do I need to start/stop the bi_server1? I'm assuming starting/stopping bi_server1 will also start/stop the 5 BI…
-
Average Metrics
I would like to create the following metrics in the RPD and would like an idea of how these would be calculated and what formula to use. Average # of Sick Days for All Employees Average # of sick days for Employee Reported Sick Average # of sick days per Employee in Year Thanks in advance.
-
Oracle OBIEE Enterprise and Developing before Production
I am looking at using Oracle OBIEE Enterprise 12C for our company however I would like to download and proto type all the various reports we have as well as create the data warehouse. If it pans out, we would purchase it. Where is the documentation/license agreement that states that we can build out the OBIEE first without…
