-
DAC changes required for RPD migration
We have a datawarehouse (DWH) with DIM and FACT tables and OBIEE report is build on top of that. The datawarehouse is loaded through Informatica ETL from JDE source system and Informatica ETL workflows are triggered through a DAC scheduler Currently, as per the requirement I need to add a new column in PRODUCT DIM and make…
-
Hi Experts , I am facing issues in executing BI Server commands for RPD generation based on xml file
Hi Experts , I am facing issues in executing BI Server commands for RPD generation based on xml file. Command:biserverxmlexec -P password -I xyz.xml -B abc.rpd -O abc2.rpd its returning usage message again and no error or success message
-
PDF Output does not show the QRCode Image
Hi OBIEE 12.2.1.3 BI Publisher Desktop 64 Bit - Windows 10 - 11.1.1.7, Build 12.210 I am doing a Proof of Concept to use QRCODE in BI Publisher, using IDAutomation Demo I have followed the below articles written by Tim Dexter https://blogs.oracle.com/xmlpublisher/advanced-barcode-support…
-
I would like to know if it is possible to build a report and Infolet of Last Transaction Date Item?
-
How to call Cloud Report on ExternalReportWSSService from Oracle database?
Hi All We've created a custom report on Cloud and I'm able to invoke it through ExternalReportWSSService using SOAP UI. Now I want to integrate the webservice into APEX application. I'm calling using apex_web_service.Make_request. I gave p_url as https://<host_name>/xmlpserver/services/ExternalReportWSSService Below is the…
-
Conditionally generate output file
Hello Everyone, I have a BI publisher extract in Oracle Fusion that is scheduled to run every day. When there is no data it is generating a default tag DATA_DS. Is there a way to generate the output file when only data exists?
-
How to modify Electronic Record for Inventory Miscellaneous Transaction Report
I need to add the Reference and Reason field to the RTF Template so that the approving user can make an informed decision without calling the user requesting the transaction. Anyone know how I can modify this in OTBI?
-
Can we use reusable mapping in the package in ODI12c?
-
Locating Worker Number
Hello, I am building a payroll report in Oracle Business Intelligence 11.1.1.9 which requires 'Worker Number' as a parameter. Is Worker Number in one of the OOTB subject areas for OBIA? I know it is linked to the assignment record but I have been unable to locate it. Many thanks, Charlotte
-
Is there any way i can Order a Filter in Oracle Analytics(Oas)
Hi, i´ve been trying to order my 'Year' filter in a descending way. However, i haven´t really been able to achieve this. I did got the result i wanted in the 'Prepare' Section Tho. But, when i go to the visualization mode, it just seems like I'm not applying anything. As you can see there is a new dataset created in the…
-
I can't abort a job in Datasync.
Hello everyone! Today we were working to extract data for a new report but for some reason, the job never ends. After a few hours, we decide to abort the job, but, the job just never ends. Keeps running and running with the additional information just showing "executing steps" Does anyone know how to force to stop the job?…
-
Divide data over multiple graphs in BI Publisher (MS Word plugin)
I'm using a clustered vertical bar graph with 6 columns per cluster. At present the graph only fits 9 clusters, but there will cases where the I need to display 40+ clusters. I'm looking for a way to divide the data over multiple graphs. Is this possible? Thanks
-
doubts on properties of data model and report in BI publisher
scalable mode should be enabled but in Data model properties section, I am not getting scalable mode property Any idea on why this property is not coming and also how can we change display name of report and data model. I can only see description here but not the display name. Thanks in Advance.
-
Group by clause not used while running analysis which leads to error "exceeding max number of rows"
* I am on Oracle BI Administration Tool 12.2.8.0. and running analysis on OAC Classic Version. * We have one product dimension and two cubes A and B. * We have created product hierarchy on our product dimension from level 1 to 30 shown in pic1 and product details as leaf node shown in pic2. * We have created similar keys…
-
CREATE REPORT WITH 3 LEVELS OF SUMMATIONS
Hi, I've a query as below and i want to create inner most sum of category, then summing of DEPT then finally the sum of STATES SELECT CATEGORY,GROUP_MEMEBRS,WORK_TITLE,DUE_AMT, PERIOD_YEAR,DEPT,STATE_NAME FROM MASTER_T USING bi publisher 11.x + ms word API to create the rtf file. any suggestion on how to resolve this.
-
CREATE REPORT WITH 3 LEVELS OF SUMMATIONS
All, i need some help but it seems i previously posted my question in different location below is the link. iam trying to create 3 grouping with sum for each group ass shown. Also i want the breakpoint not to overlap the section/group .…
-
OTBI Analysis - Count & Rank
Hello, I currently have the following Count formula: COUNT("Worker"."Person Number" BY CONCAT(CONCAT("Target Bank"."Target Bank Account Branch Number", ' '), "Target Bank"."Target Bank Account Number")) This works well, however I also need for this to Count based on the below Rank formula: RANK("Payroll…
-
Create agents to send files to FTP/SFTP
Hi, I am fairly new to Oracle Analytics and i wanted to create an agent which can store files (csv,xlsx) to FTP server. I figure out how i can create an agent to email files which is based on analysis which i have created. No FTP/SFTP configuration done so far exploring from where i should start to end. Oracle Analytics…
-
Set ideal time in OAS and redirect to login page
Hi, Would someone guide how i can set ideal time after which session should automatically get expires and redirect to the login page. Oracle Analytics 5.9
-
Redirect to dashboard after login
Hi, How can set up something so, when user logs in he/she can directly redirect to dashboard? I am on oracle analytics version 5.9
-
ODBC Driver Returned an Error (SQLExecDirectW).
Hello, I have obtained the following error in OBIEE: Can someone guide me on how to fix this? Kind regards.
-
OBIEE Pre-Builts Loading one year at a time
Hi All, We are in a situation where we need to load one year at a time into the DWH (warehouse). We have 7 years of data to upload and we need to upload one year at a time. JDK 1.8.0_x Oracle WebLogic Server 10.3.6 OBIEE 11.1.1.9 OBIA 11.1.1.10.2 ODI 11.1.1.9 OHS 11.1.1.9 Oracle Analytics Cloud 5.8 Oracle Data Gateway 5.8…
-
How to use both aggregate and analytic function in ODI
Hi All, I am working on ODI mapping where I am calculating" Min(ID) over parition by(device_num, sys_id) as min_id" in expression component, I used another expression component to filter duplicates using row_number over partition by (ID) order by(min_id) this reaults in window function error. followed by a filter…
-
How to call Bi publisher reports in Oracle EBS
Hi Team, We are planning to call the bi publisher reports in Oracle ebs. Could you please help us, how to integrate the bi publisher reports in ebs. Thanks, Sridhar.v
-
BIP Template Builder Installer failed: Word is running
Hello, Need to reinstall BIP Desktop 10.1.3.4.2 on a new laptop running Windows 10 Enterprise Version 20H2 build 19042.1466 Word for Microsoft 365 MSO (16.0.14326.20702) 32-bit Did this many times before with older versions of Windows and Office, so I know that all the Office apps have to be closed, and they are closed.…
-
BI apps 7.9.6.4 Fiscal calendar values Load
Hi All, Can someone please explain what/where to configure to see Fiscal calendar values in warehouse. Our client already implemented Public selector case management analytics from source Siebel. I do not see Fiscal calendar values(Fiscal year, Fiscal Quarter, Fiscal month) in W_DAY_D. How to get these 3 columns? Please…
-
BI Publisher - Column Header in Pivot Table using XPT Layout
Screenshot.jpg Good Day Experts, Is there a way to put a column header in a pivot table in XPT layout for BI Publisher? I can't see a property wherein you can show the header name and not sure if this is a limitation in XPT layout for pivot table. Attaching a screenshot for reference. The one in yellow highlight is the one…
-
Need help in building the Excel based BI Publisher Report
Hi, I am trying to build an excel based BI Publisher report in the below format SKU and Description Comes from Table T1 In this table for every SKU there will be 1 record and Item Id is the Primary Key. Between Table 1 and Table 2 it is 1:M relationship. Table 2 Store the Code Information and Item Id is the Foreign Key in…
-
Migrating table changes
Hello, I have a question on the migration process. I have a table and i added a new field in RPD as well as the Data Warehouse in DEV. The same process was repeated in QA (DEV rpd was not migrated to QA, instead changes were directly made on QA rpd). Do i need to export the DAC patch from DEV and import in QA? Any idea?…
-
how can i merge column head xml publisher rtf
dear all, i don't know how can i add command to merge column in B1 if text duplicate. please suggest to me. i add picture at this discuss. at this below i want to merge head1 in column1,2 (aaa,bbb) / merge head2 in column 3,4,5 (ccc,ddd,eee) head1 head1 head2 head2 head2 aaa bbb ccc ddd eee row1 xx xx xx xx xx Regard, Moo…
