BI Publisher Data Models
Discussion List
-
Calculate Yesterday date based on CURRENT_DATE variableSummary Calculate Yesterday date based on CURRENT_DATE variableContent Hello, how do I could calcolate obtain yesterday date based on current_date field in an OTBI analy…Giuseppe 1234 71 views 2 comments 1 point Most recent by RichardChan General Transactional Reporting (OTBI) -
Audit Report for Bank DetailsSummary Audit Report for Bank Details - Pulls all updates on employees bank detailsContent how do I create a audit report for employees bank details. This needs to show …Peter Kirwan 74 views 1 comment 0 points Most recent by Ruzwan Akram General Transactional Reporting (OTBI)
-
report on user account details - Role NamesSummary SQL for reporting on employees rolesContent Can someone see how to stop the multiple rows from returning in below SQL? select "PER_USERS"."USERNAME" as "USERNAME…Peter Kirwan 57 views 4 comments 1 point Most recent by Ramesh Nakka General Transactional Reporting (OTBI)
-
Adding subtotal breaks into a BI Publisher table reportSummary How do I add subtotal breaks into BI Publisher report?Content In an Analysis created with subject areas it's easy to add subtotals by going into the view under C… -
data Model ReportContent Hi, How to create Promotion data model report based on promotion employees regards, nivaetha -
Help with my SQL CodeSummary Help with my SQL CodeContent I am trying to create a BIP Report to show Document Payslips pdf uploaded for each employee (with HDL) which covers the Tables like …Ruzwan Akram 56 views 1 comment 1 point Most recent by Ruzwan Akram General Transactional Reporting (OTBI)
-
Using Subject Area for Report: "Unable to retrieve metadata from data model"Summary Attempting to use Subject Area "Payables Payments - Payment History Real Time" in an OBI report which I have used before. Now I get error when I attempt to edit …Wendy Ware 41 views 2 comments 0 points Most recent by Wendy Ware General Transactional Reporting (OTBI) -
StatsSummary Stat ReportContent is it possible to report where you have a count of the number of employees in a age range - the age ranges would be columns and then rows woul…Peter Kirwan 24 views 1 comment 0 points Most recent by Chris Dabel General Transactional Reporting (OTBI)
-
How to stop employees viewing reports in 'Custom'?Content Hi We're having some trouble with report access. We're testing our reports and came across an issue where accounts with just the employee role can run reports co…Aaron Leggett 42 views 2 comments 0 points Most recent by Aaron Leggett General Transactional Reporting (OTBI) -
SQL editor for Oracle BISummary What tools are people using to edit SQL in Oracle BI?Content Hi, as per title, I'm wondering what everyone is using to edit SQL in Oracle BI? Eg. for data model …Alex Andreadis-21319 74 views 3 comments 1 point Most recent by Neil Peacock General Transactional Reporting (OTBI) -
Trending reports in Fusion HCMSummary Can we create trending reports in Fusion HCMContent I require to create turnover reports in Fusion HCM with data trending over the period of time. For eg, if I s…Amit Shringarpure-21149 36 views 0 comments 0 points Started by Amit Shringarpure-21149 General Transactional Reporting (OTBI)
-
Using Parent-Child Hierarchy values defined for COA segments in OTBISummary Using Parent-Child Hierarchy values defined for COA segments in OTBIContent We have Parent- child hiearchies for the COA segment values especially for BSV, Natur…GopiKAutomus 66 views 1 comment 0 points Most recent by rajArun General Transactional Reporting (OTBI)