Category 192-2
Discussion List
-
How can I create a historical overview from a flexfield CHARACTER Data type?I have data information stored in a CHARACTER data type flexfield. To expose it in an analysis in Oracle Business Intelligence (OITBI), I navigate to the 'Incentive Comp…Priscila Banqueri 11 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
How to filter for Finalized territories in Sales - CRM Territory Resource subject area?Summary: How to filter for Finalized territories in Sales - CRM Territory Resource subject area analysis? Content (required): I'm using Sales - CRM Territory Resource su…Chin Chi-Oracle 53 views 4 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
How to align 63 Report Fields in RTF Report TemplateSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Malavika Sairaman 102 views 7 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
SQL Query for Territory BIP ReportSummary: Actually I trying to create a Territory Report includes the Territory Name,Parent Territory,Status , Dimension and Converge details . Can somebody helps with th…Tinu 221 views 4 comments 0 points Most recent by Prabha.R Oracle-Oracle Reporting & Analytics for Sales
-
Is there any subject area to get the Module to which each object belongs toSummary: What is the equivalent Subject Area for this table - adf_extensible_table_usage Content (required): 'adf_extensible_table_usage' has a column - 'Application_nam…Venkateswari 31 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
How to Generate a BIP Report in xlsx Format with 90+ Report FieldsSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):Malavika Sairaman 72 views 3 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Mask/Hide OTBI File Path Location on Browser Address BarSummary: Trying to find a way to hide/mask the OTBI file path location shown on browser address bar to minimize unexpected attack from anyone. Content (required): We jus…Karen Benita 51 views 3 comments 0 points Most recent by Swapnil Kashid Reporting & Analytics for Sales
-
Application usage reportHow long the audit data has been captured without doing any configuration related to the application usage insights? What is the minimum time period (days/months/years) …Sangeetha Kumar 121 views 8 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Restricted Access to Reports and AnalyticsSummary: Hello All, I have a requirement where users should be able to access all reports and analytics in OTBI but should not be able to access any objects in Fusion Ho…Manju_Bujendra 147 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales
-
How to build an Analysis using Subject Area with Subscription Product Associated Asset fields?Hello! I was not able to find a Subject Area that brought Associated Assets fields. I also tried to create a custom Subject Area to have those fields, but the only child…Bruno Matheus 62 views 1 comment 0 points Most recent by Alexandra Rabaea-Support-Oracle Subscription Management
-
How do we obtain a report of the notes associated with a lead?Summary: We need to obtain a report to obtain the relationship of leads with the notes that have been created. Content (required): We tried to build this report across s…SERGIO BARRETO 61 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales -
How to build a bar graph report, grouping by color ?**This post was created as part of a How to Service Request (SR) Summary: How to build a bar graph report, grouping by color ?Priscila Terazawa - Support-Oracle 51 views 1 comment 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
Subject Area - How to add the attachments field in a reportSummary: How to add the attchament field in a report made through the subject area "Sales - CRM pipeline" Content (required): We want to add the attachment field in a re…SERGIO BARRETO 243 views 2 comments 0 points Most recent by SERGIO BARRETO Reporting & Analytics for Sales
-
Subject Area - OTBI Performance Real Time**This post was created as part of a How to Service Request (SR) Release: 23A Summary: Can you provide any documentation that contains information about all the fields i…Dragos Deak-Support-Oracle 42 views 1 comment 0 points Most recent by Dragos Deak-Support-Oracle Reporting & Analytics for Sales
-
Why is my new custom field not showing in BI?**This post was created as part of a How to Service Request (SR) Release: 23A Summary of the question: I have created a new field 'NewField_c' in the 'Object_c' custom o…Ionel Spaloghe-Support-Oracle 73 views 1 comment 0 points Most recent by Ionel Spaloghe-Support-Oracle Reporting & Analytics for Sales -
Create Custom Subject AreaHi, Please help with the steps how to create custom subject area from the custom data model ? ThanksMohammed Rafi 73 views 3 comments 5 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales -
How to create a report to show opportunities for the logged in user territory hierarchy?**This post was created as part of a How to Service Request (SR) Release: 23A Summary of the question: How to create a report to show opportunities for the logged in use…Deborah Bourgeois-Support-Oracle 61 views 3 comments 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales
-
Last 7 days or week query - Looking to query for Opps, Contacts or Accounts updated in last 7 daysSummary: I am trying to generate reports on Opportunities Created or modified in last 7 days - or "Last Week". Also, I want to do the same with Contacts and Accounts cre…
-
Select query not giving desired resultSummary: I'm using below query but it is not giving desired result Content (required): The use case is to fetch the Email ID and subscription number of the contact assoc…Neelesh Varma 32 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales
-
Reporting by Sales Reps for their Accounts and the activity in their accountsSummary: I am looking for a report that would enable the Sales Manager to drill into a Sales Rep, then see a summary of their accounts, then select on an account and see…Tim Gruidl 62 views 6 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
How to combine two rows of text data into a single column in OTBI?**This post was created as part of a How to Service Request (SR) Release: 11.13.22.07.0 Summary of the question: How to combine two rows of text data into a single colum…Priscila Terazawa - Support-Oracle 631 views 2 comments 0 points Most recent by Priscila Terazawa - Support-Oracle Reporting & Analytics for Sales
-
Can the Notification Preferences of all users be found through reporting?**This post was created as part of a How to Service Request (SR) Release: 22C Summary of the question: Is there a way to obtain for all users, through reporting, the inf…Andrei Stan-Support-Oracle 51 views 1 comment 0 points Most recent by Andrei Stan-Support-Oracle Reporting & Analytics for Sales
-
How to Send an Email with report attachment?Question : How can an email notification be sent to the opportunity owner with all the opportunity details at the same time? **This post was created as part of a How to …Iulian Hanza-Support-Oracle 12 views 1 comment 0 points Most recent by Iulian Hanza-Support-Oracle Reporting & Analytics for Sales
-
Analytics: Infolets Limitation**This post was created as part of a How to Service Request (SR) Release: 22B Summary of the question: Is there any limitation of indicators to add within the Infolets s…Ionel Spaloghe-Support-Oracle 41 views 4 comments 0 points Most recent by Ionel Spaloghe-Support-Oracle Reporting & Analytics for Sales
-
How can I create reports with 2 different CSA**This post was created as part of a How to Service Request (SR) Release: 22B Summary of the question: I am trying to create a report using 2 different custom subject ar…Ionel Spaloghe-Support-Oracle 31 views 1 comment 0 points Most recent by Ionel Spaloghe-Support-Oracle Reporting & Analytics for Sales
-
How can I generate a report that has a manual quota amount set for each rep and pull that into a repSummary: I don't have territories and Quotas setup yet. I wanted to see how to generate a report that allows me to set a static amount for a sales rep and then pull in t…
-
Can we migrate reports/folders and content from 22B version in DEV to Production which is 21D?Summary: Can we migrate reports/folders and content from 22B version in DEV to production which is 21D? Description :- We are planning to migrate our reports/folders fro…Syed Misbauddin-Support-Oracle 21 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Reporting & Analytics for Sales -
Change US week num into ISOWeekNUM**This post was created as part of a How to Service Request (SR) Release: 22B Summary of the question: The week number that is provided in CX is using a US week num. Can…Ionel Spaloghe-Support-Oracle 31 views 1 comment 0 points Most recent by Ionel Spaloghe-Support-Oracle Reporting & Analytics for Sales
-
"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
-
Calculated Field in OTBIHi, I have created OTBI report based on custom object in which I have field called Start Date and Number of months. I need to display calculated field called End Date wh…Mohammed Rafi 102 views 11 comments 6 points Most recent by Shivakumar Ayyanagowdar-Oracle Reporting & Analytics for Sales