Stack Overflow
Stack Overflow

Questions tagged [bi-publisher]

Business Intelligence Publisher - Oracle's reporting application.

First released in 2003 as part of Oracle's E-Business Suite it has now been integrated into many of the Oracle products and is also available as a standalone application. It is capable of generating XML data from SQL queries, XML files, web services, LDAP, MDX queries, Excel files and Oracle ADF View objects.

532 questions
0
votes
1 answer

How to add or suffix spaces in xslt 1.0

looking for syntax how to add or suffix extra spaces in xslt 1.0. i am working on ISO2022cgi payment template. i have customized the template as bank requirement. we have to send data with 35 characters length so bank can consider 36th character as…
Ram
  • 1
  • 2
0
votes
1 answer

SQL query to get the output in the format "YYYY/ MM" for first date of the year till now

I want to create a query to get the below output 2022 / 01 2022 / 02 2022 / 03 2022 / 04 2022 / 05 2022 / 06 2022 / 07 2022 / 08 i.e. all months in above format till the current month how to get tweak my query to get the above output select …
Sree
  • 3
  • 1
0
votes
1 answer

How to show two data set result together horizontally in BIP report

I have two data set from different fact tables but in report I have to show both the result set together. If I am using both the data sets it is appending down after the first dataset table. Please let me know how can I show both the tables together…
mamta
  • 1
0
votes
1 answer

obiee query to find out multiple races in a column in one

SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT 0 s_0, "People - People Real Time"."People Details"."People Full Name" FullName, case when "People - People Real Time"."Job Application - Legislative Information"."Ethnicity"…
SSA_Tech124
  • 577
  • 1
  • 9
  • 25
0
votes
1 answer

adds leading zero to a column value Etext template

How to format the column so that it adds leading zero to a column value. for example , in the etext template i want to add this logic. using which function can i do this ? that is if job_code is 2900 then it should come as 002900. I tried adding…
SSA_Tech124
  • 577
  • 1
  • 9
  • 25
0
votes
1 answer

Border not display on next row for split-column-data

I have a model xml data: Model data I have been using split-column-data: to display column dynamically as I have some data with multiple different column. The thing is the border between each rows is missing. …
Nicholas Leong
  • 11
  • 3
0
votes
2 answers

Remove semicolon from the end or individually

I am getting an output of one table as FILE_NUM SNO Read;write;Listen; 1 Listen; 2 ; 3 Write;READ; …
SSA_Tech124
  • 577
  • 1
  • 9
  • 25
0
votes
0 answers

BI publisher, Issue with repeating field in PDF template

I'm having issue with repeating field in PDF template. Below is the part that I defined repeating erea. This is the 'BODY_START' field. This is the 'BODY_END' field. This is the repeating field 'ITEM_CD'. Here is the data structure. BTW, I'm…
Sabbath
  • 91
  • 3
  • 26
0
votes
1 answer

Can we override template_name in OBIEE/BIP burst definition while scheduling report job using ScheduleService::scheduleReport()?

We have a report with bursting query in OBIEE12c. We schedule report job using webservice via ScheduleService::scheduleReport() using web service client. In the Burst Query we set the TEMPLATE for the generated report. Every thing is working…
Chandu
  • 1,837
  • 7
  • 30
  • 51
0
votes
1 answer

sql query to get previous and current job and position data

I have a table asg is like below - ASG_NUMBER START_dATE END_DATE JOB_CODE GRADE_CODE POS_CDOE 10 01-JAN-2021 08-JUN-2021 S29 Engineer …
SSA_Tech124
  • 577
  • 1
  • 9
  • 25
0
votes
0 answers

Can you use "If" with two conditions (XSLT) Oracle Bi Publisher RTF Template

Inside a for-each, we have a choose the multiple when conditions. What I need to do is this- In simple terms WHEN a certain variable equals a value, If value 1 = somevalue and value 2 = someothervalue -> Do Something Here is what I have. I have…
Jagarious
  • 1
  • 1
0
votes
2 answers

Oracle sql query to find the data as of last 15 minutes

I have a query that picks up the last_update_date in the format - person_number last_update_date location 10 2021-06-10T16:02:50.222+00:00 Peru 11 …
SSA_Tech124
  • 577
  • 1
  • 9
  • 25
0
votes
2 answers

SQL Query to find the previous job , location of a particular job type

I have the below table with data - I want to create a query that displays the employees that had previous job as student and were then converted to "Employee" even if the final status is ACTIVE/INACTIVE emp_number emp_status eff_start …
SSA_Tech124
  • 577
  • 1
  • 9
  • 25
0
votes
1 answer

Oracle BI Report based on Excel template has no data when called through ReportService?

Oracle BI Publisher 12.2.1.4.0 I have a set of reports that I want to run using runReport Report Service. All the reports are working well when started within browser. The ones based on excel template when run through Report Service has just a…
d r
  • 3,848
  • 2
  • 4
  • 15
0
votes
1 answer

How I can use case statment in BIP after where as paramter?

How I can use case statment in BIP App after where and compare it to a date if is the date is null show Full data if he ask for Specific date display the data for the date that he asked for
Yousef
  • 1
1 2 3
…
35 36