Popular Tags
- Reporting 1,302
- OTBI 1,236
- Analysis and Data Visualization 821
- BI Publisher 692
- FDI 675
- Analysis 627
- Administration 517
- Oracle Fusion Analytics 481
- OBIEE 393
- BI Publisher Data Models 290
- Answers 253
- Analyses 248
- Developers 231
- Analytics 211
- Security 208
- Data Connectivity 198
- Data Modelling and Datasets 189
- HCM 188
- ERP Analytics Content 169
- Report Output 165
- BIP 157
- BI Publisher Report Templates 146
- Agents 146
- OAC 139
- Packaging and Licensing 128
Welcome to the Oracle Analytics Online Forum!
We're thrilled to have you join our community of analytics enthusiasts and professionals. To enhance your experience and foster meaningful interactions, we encourage you to personalize your profile by setting up a display name and uploading a profile picture. Your display name will be how others recognize and engage with you in discussions, while a profile picture adds a personal touch to your forum presence.
Take a moment to update your profile with a display name and an image representing you. Let's create a vibrant and engaging community together!
We're thrilled to have you join our community of analytics enthusiasts and professionals. To enhance your experience and foster meaningful interactions, we encourage you to personalize your profile by setting up a display name and uploading a profile picture. Your display name will be how others recognize and engage with you in discussions, while a profile picture adds a personal touch to your forum presence.
Take a moment to update your profile with a display name and an image representing you. Let's create a vibrant and engaging community together!
Oracle Analytics Publisher
Discussion List
-
Call Function GET_ABSENCE_DAYS_PER_TYPE IN BIPI try this SELECT * FROM TABLE(GET_ABSENCE_DAYS_PER_TYPE( 'Disfrute de Vacaciones' ,to_char(:p_start_date, 'DD/MM/YYYY') ,to_char(:p_start_date, 'DD/MM/YYYY') )) AVL but… -
Enable BI Publisher in MS-Word 2007Hi Folks, I want to show the BI Publisher Menu in MS- Word 2007 but after install the BI publisher Tool, doesn't show the BI Publisher Menu in MS Word. For fix this issu…
-
Restricting access to tables/data sources with a privillege/roleis there a way to restrict the developers writing the SQL's based on the HCM/FSCM data source ( not everyone should have access to HCM data source)
-
Run report using Rest API - /services/rest/v1/reports/{reportPath}/runWe are trying to run report using Rest API - /services/rest/v1/reports/{reportPath}/run. But we are facing an error - 404 Not found. URL used: https://host.com:port/xmlp…
-
BIP Report in Oracle fusion not generating output when XML bursting is used in excel templateHi All, I've designed a BIP report using excel template as layout. I wrote XML bursting query to send the output to an email address. Observed that when I use excel temp…
-
Update Position Details Through Oracle HCM Rest APIWe have to update position details through oracle hcm rest api but there is no update api is available on the oracle portal so could you please suggest us how can we res…
-
Oracle import map macro enable xlsm overrides user specific desktop settingsDownloadable import map files from UCM are all set to default as Calculation Options - Manual, which in turn defaults other open excel files to Manual. The Team is worki…
-
How to conditionally hide a column based on a parameter value in BI Excel Template?We have a requirement to dynamically hide a column in the excel report based on what input parameter the user selects. . I am guessing it should be done using clause, b…
-
Issue with a BIP report output, where column headers & column values are mismatchingHi All, I am facing an issue with BIP report output where The column header and column values are mismatching. Example : A column Posting_Date the expected value is a da…
-
How can I use session variables with a report BIP?I built a Report (BIPublisher) using a subject area table, which is created in the physical layer with a sql query with session variables in the where clause. Is it poss…
-
How to Modify the Asset State Parameter in Property Tax ReportHi , PFB details - 1) We want to pass 'All' Values in Asset State Parameter of Property Tax Report. However, by default there is no option to select 'All values' in the …
-
Double strikethrough in rtf template not showing in report output, however single strike is showing.Any idea if it is feasible to show double strikethrough in report output with rtf template. Below change in rtf not showing any strike in output.
-
Is there function available for getting day of the week from any date field in RTF templateHello , I am creating a logic where i need to fetch previous Sunday and Saturday dates from a date column Payment date coming from XML field below. I have a 2024-02-26 c…
-
Merged Cell in Excel Template of BIP ReportHi All, How do I generate the report shown below? I wish to merge common text in "Organization" and generate report like below. Please provide pointers to any link for r…
-
Passing multiple values in BI Publisher text type parameterSummary Passing multiple values in BI Publisher text type parameter Content I am using a presentation variable to pass values to a BIP report. The BIP parameters have be…
-
I need to join ZX_REPORT_CODES_ASSOC and zx_rates_b.I thought the join was with entity_id and tax_rate_id. It works for some invoices, but the it is giving blank for other invoices.
-
Bi Publisher - add x days to a date element in rtf templateHi All, Is there any function we can use to add 'X' days to a date element in an RTF template ? One way I can think of is deriving it in the data model but just curious …
-
Query to find the tax Reporting code using the tax rate from zx_lines?The tax Reporting Code is in the table - ZX_REPORTING_CODES_B I need help on how to join this table with zx_lines, or join tax rate with tax reporting code?
-
-
How do get BI Publisher session token?Hi Experts, How do we get the active bip session token from Fusion to the standalone application after logging in to Fusion like sso login? Thanks in advance