-
How can I move OBIEE 12C BI server from Starting in ADMIN mode to RUNNING
Last week (5th of september) we succesfully deployed a new rpd and catalog with a BAR file, switching from our Oracle 10 Database to Oracle 12 Database (on a OBIEE12 linux production server working smoothly for 3 months) - For 3 days, we had no problems and the system was working fine with the new database connections -…
-
Oracle BI Publisher 10G/11G/12C , dynamically renaming the output BI Publisher PDF file while saving
Hello All, I have a requirement to dynamically rename the output PDF files in BI Publisher when saving it based on the logged in user in the BI Publisher report. For example, I have a BI Publisher report which when saved as PDF on my desktop should automatically have customised filename like, Employee_Number.PDF , where…
-
BI Publisher PDF Generation
Summary BI Publisher PDF Generation Content Hi, I'm unable to generate a PDF output for my BIP report template . I can view the report in the interactive view however I'm unable to generate any other output format (PDF, XML...). I tried using an RTF template, it does work on word and generates the PDF with a data sample,…
-
BIP - RTF XSLT bisubtraction 2 variables
Summary BIP - RTF XSLT bisubtraction 2 variables Content Hi the community, In a BI Publisher RTF template it is required to extract 2 variables. The extraction is done through the following statements: <?if:../../Tax_Summary_Lines_Section_S8/Summary_Taxable_Amt_ID8!="0"?> <?if:position()=last()?>…
-
license for using BI publisher desktop(RTF file)
Summary license for using BI publisher desktop(RTF file) Content Hi all, I work with oracle apex applications , and in apex we generate XML file and use it in RTF (created by BI publisher desktop) to generate reports. My question is: If we have one license for database, is it legal to use BI publisher desktop or should we…
-
How to calculate month of month difference?
Summary How to calculate month of month difference? Content I would like to calculate the month of month sales growth, and the calculation could be applied to the filters (e.g. the region, or the product). Any simple way to make this? thanks.
-
Embedding DVD content on remote Siebel IP14
Summary Embedding DVD content on remote Siebel IP14 Content Hi there, I have been playing around a bit with DVD 12c (version 54) in order to create some analysis. So far I only saw PDF and PPT as export formats. I would like to know if there is a way to embed such visualizations into a Siebel IP14 via an iframe. If so, if…
-
Custom Font should print in BIP PDF
Summary Custom Font should print in BIP PDF Content Need your help regarding the font changes in BI reports for JDE, We were developing the RTF template with Custom font and the same font should be printed in PDF when we run the job. Can you please help us advise as how to change the font ? Font name is “ImagoBQ-light” is…
-
Install Advanced Analytics Error due to proxy problem
Summary Install Advanced Analytics Error due to proxy problem Content Does anyone encounter the same problem when installing Adavanced Analytics under DVD ? Thank you! Jeff
-
BI Publisher PDF Generation
Summary BI Publisher PDF Generation Content so here are the code and the data sample! I'm using the 12.2.1.0.0
-
Unable to install OBIEE 12c on Windows10(x64)
I an trying to install Oracle Business Intelligence 12c (12.2.1.0.0) on my Windows 10 desktop(x64). After installing the pre-requisites JDK and FMW, when I am trying to run the setup_bi_platform-12.2.1.0.0_win64.exe after unzipping both the disks to a folder, a window appears carrying the message "Preparing for install"…
-
authnetication problem DSN configuration
Hello, I have just installed oracle BI 12c. I am a newbie for Oracle BI. Everything was ok. I can login from the web to Enterprise manager and to the console using weblogic user and pw. I am now trying to login using Oracle BI client from windows. When trying to configure DSN ODBC data source , I put user weblogic and…
-
how to achieve not to display place holders and formula columns which are not part of a group
Summary how to achieve not to display place holders and formula columns which are not part of a group Content Based on some input parameter i need to print out put or no output(zero bites) using XML publisher report(xml source is RDF file) using lexicals i have achieved this by concatenating 1=1 or 1=2 based on input…
-
Informatica support with db12c?
Is Informatica 9.x supported with obiee 12c? regards
-
PeopleSoft HRMS/HCM to Oracle Fusion HCM cloud conversion made easy
Summary PeopleSoft HRMS/HCM to Oracle Fusion HCM cloud conversion made easy Content PeopleSoft HRMS/HCM to Oracle Fusion HCM cloud conversion made easy * DataTerrain launches new reports conversion solution for customers who are migrating PeopleSoft HRMS/HCM to Oracle Fusion HCM cloud. Our well defined framework enables…
-
How to calculate days between dates？
Summary How to calculate days between dates？ Content For example, I've two dates, the Delivery date and Ordering Date, how could I calculate the days between them, so that I'll find out how long it takes the goods out of warehouse? Is there any function in DVD to support this? Such as datediff ... BTW, I found DAYOFYEAR…
-
Display Last Modified By - In Catalog
In the catalog folders, we can see the following fields (highlighted in red) Name, Type, Last Modified, Owner But I want to also display the field "Last Modified By" (expected here - highlighted in green) Is it possible to do that? My OBIEE version is "11.1.1.7.160719"
-
SFDC compatibility with 12c
Salesforce supported with obiee12C? Can we use their api? Regards
-
OBIEE Server in DMZ to support OBIEE Mobile Device App
Does Oracle support installing OBIEE in a DMZ for access to mobile devices connecting from the internet? The install documentation mentions using vpn, and the architecture diagram only shows using a proxy, but I see nothing in any of the documents I have seen so far regarding installing OBIEE in a DMZ. specifically…
-
Error during 'pasteConfig.sh' (instance) - OBIEE T2P Cloning
Hi - I am following OBIEE 11g Test-to-Production (T2P) / Clone Procedures Guide (Doc ID 1625533.1). I am nearly finished with the steps, but have hit an error on the target. Here is the step, taken from the MOS note: Here is the output from the command line: INFO : Jul 19, 2017 11:26:46 - CLONE-21276…
-
Calculate Total and Percentage for BI Report
Summary Calculate Total and Percentage for BI Report Content Hello Experts, I am looking to see how to calculate total and individual line item % based on the total. Would appreciate if you can provide any inputs for the same. * e.g. red part below is what I am looking to calculate. I am able to find the green part from a…
-
PREVIOUS YEAR MTD CALCULATION
Hi All, how can i calculate previous year MTD in OBIEE RPD? I tried below calculation but getting below error.is there any other way to achieve this or am i missing something? AGO(TODATE(METRIC,MONTH_LEVEL) ,YEAR_LEVEL,1) ERROR: [nQSError: 22044] Nesting of AGO or TODATE functions with differing level arguments is not…
-
Vertical Line in Pivot Graph
Hi All, Oracle Business Intelligence 12.2.1.0.0 I need to insert a vertical line against one of the X axis data point. For example, in the report shown below, I need to show a vertical line against the year 2011 in a pivot line graph. I am using running sum to plot other measures and so need to stick on to the pivot graph.…
-
SOAP header Security was not understood
I am using OBIEE 11g Action Webservice to call an external Application using SOAP URL WSDL file. How can I configure the OBIEE 11g Weblogic to return the expected page. I am getting ServiceExecutionFailure : Error invoking web service <WSDL file name> endpoint <http://x.x.x.x> Client received SOAP Fault from server :…
-
Folder Not Display Problem
When upgrading from Oracle BI version 11.1.1.7 to 11.1.1.9, we could not view the folders in the catalog in BI Publisher. Is the cause of the problem? Could you help? Thank you.
-
Dynamic Column Heading
Hi, Oracle Business Intelligence 12.2.1.1.0 I am using a session variable to populate a column heading in OBIEE. I use the command @{biServer.variables['NQ_SESSION.Cal']} in the column heading. Variable returns the value in format 2017-September. I need to just display September in the column heading. We could create a new…
-
OBIEE 12c - How to use a column value as an image caption
I am displaying an image in a pivot table, using this code: <body> <div class="thumbnail"> <figure> <img src="@H" "width=250px" border="0" /> <figcaption>Caption goes here</figcaption> </figure> <span> <img src="@H" "width=800px;"/> </span> </div> </body> The words Caption goes here are currently displaying below the…
-
filtering date in layout editor of bi publisher
Summary filtering date in layout editor of bi publisher Content Hi All, I am trying to filter date in a table in layout editor of BI publisher and my filter format for date doesnot work. please let me know if there is any other way to filter table on a date column. below is the format i see,i am able to format the date…
-
Map integration with OBIEE 11g
Hi folks, I have implemented navteq(nokia here) maps with OBIEE 11g. Now i am stuck at a specific requirement : Scenario: Show sales on map for cities and its streets. Requirement: Whenever user drill-down to city, he/she should be able to see sales at street level and vice versa. I have tried many methods like MASTER…
-
Chained Agents execution is not captured in S_NQ_INSTANCE
It seems that Chained Agent executions are not captured in S_NQ_INSTANCE table. I can only see rows related to Agents which were executed manually or in scope of enabled schedule. This looks like a major flaw, because Agent chains a used very extensively and without the possibility to track these executions it immediately…
