-
Exporting the report name with title view name
Hi friends, Im in obiee 11.1.1.7.150120 Im exporting the report in csv format. I have the title view which has the dynamic title name generated. Is it possible to export the report with that title view name instead of the name which we enter for the report while saving the report in the catalog. Because defaultly while…
-
Migration Error - OBIEE 11g to 12c
Hi, Created the export bundle using bi-migration-tool.jar in 11g, which is having JDK version jdk1.8.0_92. When i tried to import the export bundle in 12c, linux terminal got stuck with the step "Performing actual import". Pasted the migration log file. Please help me resolve the issue. 2017-05-02 12:10:20 INFO Loading 12c…
-
BI Publisher Template upload isn't working in 8.55
Summary BI Publisher Template upload isn't working in 8.55 Content I am trying to upload a new .rtf file to a BI Publisher report. I can browse, find the file and select it. When I click OK to upload the system just spins and eventually just stops with no error message. This works just fine in 8.54 tools. Anyone have this…
-
R12.1.3 - Supplier Payment file - eText file
Summary R12.1.3 - Supplier Payment file - eText file Content Hi, I am building Supplier payment file as eText output in RTF template. I want to remove apostrophe (') in supplier name in eText output file. I have used REPLACE function (i.e: REPLACE(Payee/Name,'''',''))but it is not working. Regards, Anjana
-
HOW TO CONVERT TO A DATE FORMAT
Summary HOW TO CONVERT TO A DATE FORMAT Content Hi guys. I'm trying to convert the whole column to a date format but I'm having this issue so I don't know what do I have to put into this field. Would you help me to figure out what am i doing wrong. Thank you in advance.
-
REST Call with template id
Summary REST Call with template id Content Hello, I'm using BiPublisher 12.2.1.3 on linux. I want to run a report through a REST call and passing: * the templateName/id to use * the data to use I already have the default template working correctly. Now I want to specify the template name/id to use. This is the body of my…
-
OBIEE 12c When use IFNULL in RPD then I get wrong data in analysis
Hi all, I have tricky one. We have formula in RPD like IFNULL(column1) + IFNULL(column2) + IFNULL(column3). If I use it in report I'm getting quite different data in compare to 11g version. If I squize the data to some certain point I get correct data. Finally if I use sorting in the pivot table the row sum is constantly…
-
[nQSError: 12017] Unexpected socket read timeout: connection terminated by network, e.g. by the fire
Hi Folks, We are facing an issue intermittently in OBIEE 12C. When we hit the URL sometimes it stuck at "signing" page and after some time it gives OBIEE login page as below Sametime in presentation server logs it throws below error, [2017-05-17T04:11:59Z] [OBIPS] [ERROR:1] []…
-
How to export the folder heading of a report in excel format in obiee 11g
I am not able to export the folder heading of a report , although the column heading and data are appearing but the folder heading is not getting displayed. Kindly provide suggestions!!
-
What version of BI Admin Tool to use to upload RPD to BICS?
Summary What version of BI Admin Tool to use to upload RPD to BICS? Content Hi, I have a on-premise RPD created using OBI Admin Tool 12.2.1.2.0 and need to upload it to BICS. But I get an error on BICS that the data model cannot be replaced with my on-prem RPD. The same RPD is working fine on-prem. Anyone else have similar…
-
BI Publisher "Failed to Load XML" when creating sample data
Summary BI Publisher "Failed to Load XML" when creating sample data Content I am new to BI Publisher and I am receiving the error "Failed to Load XML" after trying to view the data generated by the following SQL code (runs successfully in SQL Developer): SELECT oh.order_number, ol.line_number, ol.creation_date,…
-
On Premise Update to DV for 12.2.1.2
Summary On Premise Update to DV for 12.2.1.2 Content We have recently installed on-premise OBI 12.2.1.2.20170718 and are licensed for DV embedded within OBI. It looks like the version of DV embedded is v1. Is there any plan from Oracle to bring this up to speed with OAC and DVD (to version 3)? Our users are already…
-
RDF to BIP conversion-OR2BIPConvAssist
Summary RDF to BIP conversion-OR2BIPConvAssist Content Hello, I have installed BI Publisher Trial Edition 11g for Windows 64 bit(11.1.1.7.1). I am able to successfully connect to my database (Oracle) through JDBC. I am trying to convert an RDF report into BI Publisher report using OR2BIPConvAssist (Windows). I am unable to…
-
get XML template for BI Publisher Report
Summary get XML template for BI Publisher Report Content Hi, We have created a BI Publisher Report in ERP cloud. We are trying to get the XML template for this report to be used as source of metadata. Anyone knows how to get it? Thanks, Xuelin
-
Call procedure/sql before executing query with params
Summary Call procedure/sql before executing query with params Content Hello experts, I am new in BIP. I have a weblogic with bip (12.2.1.3.0 (build:20170720.0424) ) installed. I want to execute a method/procedure ( alter session set current_schema = :parameter_schema; ) before the sql query, so it will retrieve the data in…
-
Evaluate function issue, cannot ship function
Hi friends, Im in obiee 11.1.1.7.150120 and i have the Fact called fact-capex-bi and the dimension called dim-capex-bi. In that fact fact-capex-bi i have the column Budget and in dimension dim-capex-bi i have the column year. This year column consist of the values like FY17, FY18 etc. My scenario is when i try to…
-
Master Detail report using excel template and Excel Output style
Summary Master Detail report using excel template and Excel Output style Content We created a excel template with 3 nested groups like below. G_HEADER G_SUB_HEADER G_DETAILS G_HEADER has 5 sets of data groups G_SUB_HEADER has one set of data for each G_HEADER group G_DETAILS has one set of data for each G_SUB_HEADER group.…
-
Export OBIEE users into excel files
Hi Guru's, I need to exports all users of Analytics , roles and privileges for our AUDIT Team For information, we have configured Active Directory Thanks you for help OBIEE version 12.2.1.2.0
-
OBIEE - Multi level hierarchy into single column
Hi, I have a multi level tree account table with say parent level at level1 and leaf level in any of the child levels say level20. My fact table has data only for leaf level. My requirement is to aggregate all the levels into single column to show in report. For example, below is my table structure is Acct Dim Table:…
-
OBIEE 12c - Reflecting changes in hierarchies over time
Departments move around frequently at my client. For example, the Product Design department used to roll up to the Arts division. In April, it was moved into the Business division. Is a display like this possible in OBIEE with changes to the database and/or the RPD?
-
XML output error
Summary XML output error Content hi, I am trying to create a xml report and though my short code and code name is same also in same case yet im getting the below error. Any help is appreciated. Calling XDO Data Engine... java.lang.NullPointerException at…
-
How to print Continued in Next Page Number in RTF template in Bi Publisher
Summary How to print Continued in Next Page Number in RTF template in Bi Publisher Content I have a requirement where in if table data splits across pages in Bi Publisher Report then we need to print 'Continued in Next Page Number' ,say for example if data in table splits from page 2 to page 3, 4 and so on then at bottom…
-
Time Series Scatter Graph
Hi, I'd like to create a scatter graph in a 12c OBIEE analysis with time on the x-axis. Data Visualization Desktop lets you do this but you can't do it in Answers. I found a blog article on how to enable a time series scatter but the steps seem to be out of date because the .cxml and .pcxml files don't seem to exist…
-
Multiple Master child relationship
Hello all, I apologize in advance if this question seems rudimentary. I have a pie chart that has a count of products sold. I have set up master-child relationship so when a user selects a slice of the pie, a product/brand table renders and shows the brands of the counts of the products sold (from the pie chart). Now, I…
-
adding a symbol in a dimension for a dashboard prompt
Hello All, Is there a way to add a symbol, specifically a "-" (hyphen) on a dimension? E.g. if I have "YEAR" as a dashboard prompt, I'd like the values 2016, 2017, 2018 to show as "20-16", "20-17", "20-18" Is this even possible? My initial thought was casting the dimension as a string but realized I have nothing else to…
-
Self join on Fact Table using alias
Hello, I have a "Sales Fact table" with Transaction # and Original Transaction #. I created a new Alias for the same fact table as "Sales Original Fact Table", which will self join to the "Sales Fact Table" on Transaction # = Original Transaction #. What is the best way to model this in the rpd? Should I use both "Sales…
-
If then else statement for from and to dates
Summary If then else statement for from and to dates Content Hi Guru's I need to build a template that will apply if-then-else statement based upon a the transaction date that lies between a start emp rate date and a end emp rate date. i.e. A record will have a transaction date of 03/07/2017 and it will have an start emp…
-
Oracle BI Publisher - Optional Parameter
Summary Oracle BI Publisher - Optional Parameter Content Hi All, Is there any way we could make parameter in Oracle BI Publisher data model/report optional. By default parameters are mandatory, though there is no asterisk notation. I need like, if no value passed to the parameter it will take default value mentioned in the…
-
OBIEE 12c: Deploy bicustom.ear using WLST
Hi, We have created custom styling for our application and I want to deploy the bicustom.ear file to the target Weblogic server using WLST rather than via the console. Anyone know of any documentation on thiss or have examples of WLST scripts to do this? Thanks Adrian
-
Hierachical Level Measures
Hello All, We have one hierarchy with levels :- OPTY(Higher) and ITEM(Lower). Customer wants to display the measure "Quantity", where in OPTY level we need to display Max(Quantity) and in Item level we need to show Sum(Quantity). So how will we proceed with that. Please guide me. Thanks Saroj
