Popular Tags
- OTBI 1,393
- Reporting 1,362
- FDI 946
- Analysis and Data Visualization 937
- BI Publisher 814
- Analysis 660
- Administration 551
- Oracle Fusion Analytics 541
- OBIEE 420
- Analytics 336
- BI Publisher Data Models 335
- OAC 320
- Security 263
- Answers 260
- Analyses 253
- Developers 239
- HCM 234
- BIP 230
- Data Modelling and Datasets 217
- Data Connectivity 205
- ERP Analytics Content 197
- BI Publisher Report Templates 184
- Report Output 180
- Agents 151
- Customizing Reports 146
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Answers
Discussion List
-
Convert Date FieldSummary Convert from MM/DD/YYYY to YYYY-Qx Content Hello, I have a date field I want to convert. I want to convert that from MM/DD/YYY to "YYYY-Qx". Any thoughts on how …slgott 51 views 2 comments 0 points Most recent by slgott Oracle Transactional Business Intelligence -
The tool 'OracleBIOffice.exe' is not available after R12 upgradeSummary The tool 'OracleBIOffice.exe' is not available after R12 upgrade Content We are not able to install OracleBIOffice.exe tool after R12 upgrade from the EPM Worksp…User_AEMC1 21 views 2 comments 0 points Most recent by user650055 Oracle Transactional Business Intelligence
-
Trailing Spaces in OBIEESummary formatting question Content Hello! I am hoping to poll the community regarding some OBIEE formatting i'm trying to accomplish. I have a report where I need to cr…Joy Hanneman-161050 133 views 2 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
Future Dated ActivitiesSummary Show me only the Opportunities that don't have a future dated activity added Content Hello, I'm struggling to think through how to do this. Here is the business …slgott 41 views 1 comment 0 points Most recent by MaartenDIF Oracle Transactional Business Intelligence
-
how to connect to Bi publisher administer console in fusion 19C?Summary How to access the bi publisher administer console in fusion 19c? Content I have added some roles to my fusion account. But, I cannot see the bi publisher adminis…Geetha Devi 141 views 11 comments 0 points Most recent by Geetha Devi Oracle Transactional Business Intelligence
-
Use ESS to run a BI Publisher job that transmits reports via SFTPSummary Is it possible to use ESS execute a BI Publisher job will transmits reports via SFTP? Content We have built some Custom Reports in BI Publisher that extract data…Juan Miguel Isip-94819 414 views 7 comments 0 points Most recent by Arun Raj Oracle Transactional Business Intelligence
-
Setting relative dates in a filter for an OTBI AnalysisSummary In an OTBI Analysis is there a way to add into a relative date range into a filter? Content I need an Analysis with a filter to pick up dates within the last wee…Tim Welsh 2.1K views 17 comments 0 points Most recent by Kamran Butt-161785 Oracle Transactional Business Intelligence
-
Security Console TablesContent Hi Everyone Quick question, is there a table that I can query in BIP that will show me the Roles and Roles Description? We have been struggling to assign the rig…Aaron Leggett 203 views 5 comments 0 points Most recent by Karthik Vinodkumar Oracle Transactional Business Intelligence
-
Force Performance Tiles to show 0 versus No ResultsSummary Force Performance Tiles to show 0 versus No Results Content Is there a way to force a Performance Tile to show 0 versus the No Results message?Andy French 31 views 1 comment 0 points Most recent by Ankush Rode Oracle Transactional Business Intelligence
-
Get privilege to issue logical SQL in OTBISummary As a developer i need to "Issue SQL" /analytics/saw.dll?issuerawsql to query using logical sql metadata repository database (rpd) with log level 2 then view log …Nathan CCC 178 views 2 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence -
Filter on blank and future datesSummary Create a filter using SQL expression to show just the null and future dated values Content Hello, I have a need to see only the null values and future dates. I'm…slgott 240 views 2 comments 0 points Most recent by SantoshKumarBhairi Oracle Transactional Business Intelligence
-
Remove Access to Create OTBI ReportsContent Hi, How can I remove this access? I am able to remove from New using Manager Privileges.Misbahul Khair 61 views 5 comments 0 points Most recent by Tom Strudley Oracle Transactional Business Intelligence
-
Future Dated ActivitiesSummary Show Opportunities with Future Dated Activities tied to them Content I posted this to the Reporting and Analytics for Engagement Cloud forum but I don't have gre…slgott 51 views 3 comments 0 points Most recent by slgott Oracle Transactional Business Intelligence
-
Can we generate a OTBI analysis in a Pyramid format in R13 release update 18B versionSummary Can we generate a OTBI analysis in a Pyramid format in R13 release update 18B version Content Hi, Can we generate a OTBI analysis in a Pyramid format in R13 rele…User_MC37Q 207 views 14 comments 0 points Most recent by Gail Langendorf-Oracle Oracle Transactional Business Intelligence
-
Customer hierarchy using BI Analysis (or OTBI)Content Hi All, I need to build a customer hierarchy report using BI Analysis (or OTBI). It should display Party Name, Party Usage and Primary Address. Can anyone help m…Rinku Gautam 248 views 6 comments 0 points Most recent by adelsorbo-Oracle Oracle Transactional Business Intelligence
-
Subtract resulting values of CASE functionSummary Need to subtract two values that are first derived using the CASE function Content I have created two measure columns that use a CASE function. I am trying to su…Stephanie Golly-Oracle 364 views 3 comments 0 points Most recent by RichardChan Oracle Transactional Business Intelligence
-
How to get and SQL for our own OTBI AnalysisSummary SQL for OTBI Analysis Content Hi All, How to get and SQL for our own OTBI Analysis.I know we can get this in the advanced tab but there we cannot see the sub que…Praveen Kumar-146357 82 views 3 comments 0 points Most recent by [Deleted User] Oracle Transactional Business Intelligence
-
How to Pass Parameter from Dashboard to BI ReportSummary Passing Parameter from Dashboard to BI Report Content Hi Experts, I have a BI Report which has a parameter. (A List of Value Item which gets value from a SQL Que…AshishERPCloud 1.3K views 21 comments 1 point Most recent by sameer ashturkar Oracle Transactional Business Intelligence
-
'Publish for Subscription' in OTBI AgentContent Hi, can anyone point me to any information on how to best utilise this feature within OTBI agents. Ideally I am looking to establish a way to set an agent to not…Linda Stelling-61686 75 views 4 comments 0 points Most recent by Linda Stelling-61686 Oracle Transactional Business Intelligence
-
Export Analytic XML structure (not data) via analytics-wsSummary Back up analytics using analytics-ws Content I am wanting to do some partial automation with version control/backups using the analytics-ws. Does anyone know if …Wade Wilson 101 views 6 comments 0 points Most recent by Wade Wilson Oracle Transactional Business Intelligence