Popular Tags
- OTBI 1,407
- Reporting 1,365
- FDI 985
- Analysis and Data Visualization 953
- BI Publisher 820
- Analysis 663
- Administration 553
- Oracle Fusion Analytics 550
- OBIEE 421
- Analytics 347
- OAC 338
- BI Publisher Data Models 335
- Security 273
- Answers 261
- Analyses 253
- Developers 240
- HCM 239
- BIP 233
- Data Modelling and Datasets 218
- Data Connectivity 206
- ERP Analytics Content 199
- BI Publisher Report Templates 185
- Report Output 180
- Agents 151
- Customizing Reports 146
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Oracle Analytics Publisher
Ask questions in the Oracle Analytics Publisher forum to get help from peers and experts. Receive answers from Publisher's top customers and developers.
Discussion List
-
Sequential grouping in Rtf template.Hi Team, We have a requirement of BI report where we want to group the payments on their status and get the total for each set of payments in accordance with their chequ… -
Table that stores the file contents of an attachmentHello, We need a table that stores the base64 format of the attachment uploaded in a work order or if there is any table that stores the binary format of the file conten…
-
XML Comments in XSL sub-templates?Strange things happen when I add XML comments to the XSL sub-templates embedded in my RTF report template. This code works as expected. ... …
-
How to Print Sales order Line Text Attachment into BIP report?Dear All, How to Print Sales order Line Text Attachment into BIP report? We have same requirement for PO Line Text attachment to be printed in PO report, which we are ab…
-
How to create Cross functional reports in Fusion BIPwe are trying to create BIP report from different SAAS modules eg : few attributes from fusion Order management, and few attributes from Oracle Transportation Managemen…
-
-
Can someone help me with the query to get the Product Fiscal Classification code?I need to get the Product Fiscal Classification for a Fiscal Document Capture. I can get the PRODUCT_FISCAL_CLASSIF_ID from cmf_fiscal_doc_lines_vl, but unable to figure…
-
How to print a Paragraph which has multiple conditionswe have requirement to print time off paragraph for employees belonging to 4 states and grade not equal to 99. other paragraph where employee belonging to one state and …
-
where can i find the tables in hcm related to currency conversion rates and tax deduction detailshi where can i find the tables in hcm related to currency conversion rates and tax deduction details masters where details are stored for our reporting
-
Split worksheets multiple timesWe are using BI Publisher Excel template (97-2003) . We have data that can exceed the row limit of 65k rows. This template has 3 tabs/worksheet each can exceed 65k. How …
-
Convert a number to a fraction BIP reportHi all, Is there a function sql to convert a number to fraction using a BIP report in Oracle HCM? For example if I have 0.25 FTE value, I want to print the fraction 1/4.…
-
Report output require in one rowHello BI Expert, I have a problem with the output of the report. How can we obtain a single employee record in a row? If someone could help me with this, it would be gre…
-
Font issue in the BIP report output when login with different sign in languageWhen I run the BIP report with English as sign in language,the output font is Arial whereas when run the same report with Japanese as sign in language, the output font i…
-
How to add a trigger that will skip running report if no data returnedI'm running multiple reports throughout the day that will show as failed if there are no results to the report (which is expected sometimes). My analysts have to go and …
-
Report output require in one rowHello Expert I have a problem with the output of the report. How can we obtain a single employee record in a row? If someone could help me with this, it would be greatly…
-
BI Publisher errorHi Job fails for Data model>bursting and the error code is this: does anyone know what is the issue? Waiting Time: 0.7 seconds Data Fetch Time: 10.4 seconds Total Execut…
-
Help with Development of Payroll GL Report in BIPGood Day, We're preparing for go live at the end of this month on Oracle Fusion Cloud. Our team is learning OTBI and BIP in preparation for this, and I have a question r… -
I want query for below columns, for AR Invoice Integration Exception report using interface Tables.Columns are ACCOUNT_CLASS, Distribution_Account, description, Invoice_Number, Distribution_Amount, Payment_Term, Currency, GL_DATE, Error_Reason, Ship_To_customer_Name, …
-
Oracle bursting syntax error in FusionError while compiling bursting query: java.io.IOException: prepare query failed[nQSError: 43113] Message returned from OBIS. [nQSError: 27002] Near : Syntax error [nQSEr…
-
Can’t install BI Publisher for desktopHello, I'm trying to install Oracle Analytics Publisher for desktop however I have the following error "Another version of this product is already installed. Installatio…