BI Publisher
Discussion List
-
"Total Amount" column in OTBI from Paysheet - ICMSummary: Anyone who knows the exact column name of "Total Amount" in OTBI? This is a field from Paysheets in Incentive Compensation. Tried other existing columns in the …User0901 21 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Not able to fetch resultsHi, When I run the OTBI report it keeps spinning but not able to view the report and this is happening suddenly any idea what could be the reason and how to fix itMohammed Rafi 31 views 5 comments 2 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Fusion BIP 12cSummary Fusion BIP 12cContent I noticed that BIP in Fusion SaaS is still 11g instead of 12c. When do we plan to upgrade BIP to 12c? The reason I am asking this is that w…Adam Liu 67 views 15 comments 3 points Most recent by Swapnil Kashid Reporting & Analytics for Sales -
Remove unwanted options from a BIP report which is exposed as a sub tab via application composerSummary: We have created a BIP report, Added the report in Application composer Mash up> Added this mashup as a subtab in one of the object, on clicking this subtab, I c…S.Kumar 21 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
R13.x CX OTBI Subject Area to Database Lineage Mapping SpreadsheetSummary This posting includes R13 CX OTBI subject areas to database lineage mapping and security roles. Content This spreadsheet is published by Oracle OTBI Development.…Noelle Bartlam-Oracle 2K views 14 comments 11 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales
-
RTF TemplatesSummary: Hi, Can anyone please provide documents or sample RTF templates for learning or exploring purpose. Thanks. Content (required): Version (include the version you …Padamatinti Varsha 64 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Default Period Prompt to Current Period (ICM BIP Report)Summary: We have an ICM BIP report where we need the "Period" prompt to be defaulted to the current period. We tried using the SQL below, but it does not reflect correct…
-
Show OTBI Graph with no values rather than No Results messageSummary: There are instances when the OTBI bar graphs result in no data results. Instead of showing a "No Results" message, is it possible to show the graph instead? We …User0901 11 views 1 comment 1 point Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales
-
Outer join queriesSummary Outer join within same subject areaContent Hi, I am using "Marketing - CRM Leads" SA to create report on leads. this return only those customer who have leads th…azodpe 18 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales
-
Embed BI Publisher Report on Account PageSummary We need to embed a custom BIP Report on Account Page which gives info to users on unpaid customer invoices. I have created a report based on AccountID as paramet…Umang Gupta 27 views 2 comments 0 points Most recent by Raghavan p-Oracle Reporting & Analytics for Sales
-
BIP performance recommendations guide v1.0 for FA SaaS (2800118.1) is available on MOS PortalSummary BIP Performance Recommendations Guide is intended for FA SaaS BI system integrators, BI report developers and admins. It covers advanced performance tuning techn…Pavel Buynitsky-Oracle 24 views 0 comments 2 points Started by Pavel Buynitsky-Oracle Reporting & Analytics for Sales
-
SQL statements for DatastoresSummary What are the concrete SQL statements for an Datastore and what kind of joins are used for joining relevant database tables?Content Hello, we are looking for the …User_0HYL0 37 views 2 comments 4 points Most recent by Srinivas Malyala-Oracle Reporting & Analytics for Sales
-
What roles are needed to access the BI Data modelContent Hi, I created a custom role and assigned the roles: BI Administrator Role BI Applications Administrator Duty BI Applications Functional Developer Duty BI Publish…Valdir Dutra 43 views 3 comments 0 points Most recent by Valdir Dutra Reporting & Analytics for Sales -
"Sales - CRM Sales Activity"."Business Unit"."Business Unit Name" is nullSummary I am trying to do an Activities report but the Business Unit Name field is nullContent I am using the subject area "CRM - CRM Activity Real Time" but when I adde…Edgar93 34 views 1 comment 0 points Most recent by Dimple-Nagesh-Support-Oracle Reporting & Analytics for Sales -
Need out of box reports for Oracle recruitment(ORC)Summary Need out of box reports for Oracle recruitment(ORC)Content Hi Team, We are looking for Oracle recruitment(ORC) out of box reports. This is the new module for us …Harish Kumar Kovi 60 views 1 comment 3 points Most recent by Craig Hennessy Reporting & Analytics for Sales
-
How to embed hyperlink from OTBI report - data column field into Apps Composer CRM custom formSummary I need the ability to drill into some Custom App Composer CRM data from a Dashboard Report on that data set. Non Standard Oracle Cloud App FormsContent I need th…
-
Set Default Selection of Owner Prompt to Currently Logged-in UserSummary Set Default Selection of Owner Prompt to Currently Logged-in UserContent Hi, I want the currently logged-in user to be the default selection of Owner prompt I cr… -
Alternative Solution To Using User Organization Hierarchy Based LoginSummary Alternative Solution To Using User Organization Hierarchy Based LoginContent Hi, We're having issues with using User Organization Hierarchy Based Login filter in…edpalomo 52 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Configure option in Workspace Infolet MissingContent Hi, In DEV environment (Orange) I was able to see the Configure option, but in Production (Blue) there was no Configure option available for the infolets. How do…
-
Need Help in Logical SQL for recruiting sysdate time conditionSummary Need Help in Logical SQL for recruiting sysdate time conditionContent Hi Team, I am trying to add a new filter condition like "and TRUNC("Recruiting - Recruiting…Murali Peddini 39 views 1 comment 0 points Most recent by Murali Peddini Reporting & Analytics for Sales
-
Cannot Access Workspace InfoletsSummary Cannot Access Workspace InfoletsContent Hi, I've already set the profile option ZCA_ENABLE_ADAPTIVE_INFOLETS to Yes and added ORA_ZBS_SALES_ADMINISTRATOR_JOB to …
-
how to define a prompt to get Sales Manager and his reportee manager and reportee salespersonContent Hi All, We have a scenario, where in one sales manager has salespersons and other sales managers as reportees. Now, we are trying to build a dashboard prompt, wh…Srinivas Soora 51 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales
-
"Only quota contributing revenue is considered" - What does this mean?Summary "Only quota contributing revenue is considered" - What does this mean?Content Hi, I'm looking at the documentation of Pipeline Detail Facts and all metrics and m…edpalomo 26 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales
-
How to enable Enterprise Calendar and Custom Calendar at PromptsSummary How to enable Enterprise Calendar and Custom Calendar at PromptsContent We have use case where in our customer has "Enterprise Calendar" defined (01-Jan to 31-De…Srinivas Soora 30 views 4 comments 1 point Most recent by Rupak Chowdhury-Oracle Reporting & Analytics for Sales
-
Embedding a BIP reportSummary Embedding a BIP report in the tool with all the functionalityContent Hello, Does anybody know... When you embed a BIP report into the Operational tool, does it c…Stephanie Gott 86 views 7 comments 2 points Most recent by Mohana Gopal Selvam-Oracle Reporting & Analytics for Sales -
Documentation for Sales - CRM Pipeline Facts 11.1.1.9Summary Documentation for Sales - CRM Pipeline Facts 11.1.1.9Content Hi, Is there a documentation for Oracle Business Intelligence 11.1.1.9 subject area metric measures?…edpalomo 36 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Merge Values Created By Duplicate Sales Stage NameSummary Merge Values Created By Duplicate Sales Stage NameContent Hi, I created an analysis in OTBI and the Sales Stage Name is creating two sets of # of Opportunity Val…edpalomo 34 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales
-
How to extract Report from BI publisher Using BICC as a single CSV/zipSummary Not able to extract as a single CSV from a reports of multiple view objectsContent Hi Team, I have a report based on Lead, in which we have customer details, pro…
-
Custom Account Hierarchy ReportContent How to built the custom Hierarchy report through OBIEE, Please let me know any sample sql query is available. Structure : ___________Corporate Account__________ …Deepak Prakash 57 views 2 comments 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales -
Is it possible to customize the output csv file name after job in BICCSummary How to customize the zip file and CSV file after In BICC extract jobContent Hi All, Im exporting fusion application data to OCI using BICC, the file is generatin…Sudheer Vadla 74 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales