Welcome to the Oracle Analytics Community
Popular Tags
- OTBI 949
- Reporting 844
- Analysis and Data Visualization 647
- Analysis 572
- BI Publisher 506
- Administration 499
- obiee 282
- reports 282
- Oracle Fusion Analytics 240
- Analyses 237
- Developers 223
- BI Publisher Data Models 213
- FAW 212
- Data Connectivity 184
- Data Modelling and Datasets 160
- OBI Answers 150
- security 143
- Report Output 133
- Agents 130
- Packaging and Licensing 124
- Home and Catalog 116
- ERP Analytics Content 109
- HCM 105
- OBIEE Answers 102
- Access and Manage Data 102
OBIEE Answers
Discussion List
-
2How we can find a list of all reports which are not being used by end users in OAC?How we can find a list of all reports which are not being used by end users in OAC? We’ll need this information multiple times during the OAC Migration and it’s not viab…User_LYZND 20 views 4 comments 2 points Most recent by Michal Zima Oracle Analytics Cloud and Server Idea Lab -
Bursting output file name character limitContent Hi, I have defined Bursting Output file name in the query as below- LegalEntityName || BusinessUnitName || 'Report' || To_CHAR(SYSDATE,'YYYYMONDDHH24MISS','NLS_D…JYOTI MAURYA 100 views 8 comments 0 points Most recent by SR_CC Oracle Transactional Business Intelligence
-
How to convert PO ordered amount in USD (Conversion type as SPOT)We are creating an analysis using 'Procurement-Procure to Pay Real Time' where we need to convert and display PO amount in USD. Using the conversion tyoe as SPOT. I coul…Thanigainathan R 3 views 0 comments 0 points Started by Thanigainathan R Oracle Transactional Business Intelligence
-
Getting error while creating reportHello All, We are recently migrating from OBIEE 12c to OAS 6.4. But we are facing one problem after migration. One of our connection pool contains connection for vertica…Anirban310 41 views 1 comment 0 points Most recent by EzequielC-Oracle Oracle Analytics Cloud and Server
-
EVALUATE function with REGEXP_SUBSTR dbfunction not working as expected within OTBI reportingHi, We need to use REGEXP_SUBSTR function to get 6th segment value from Depreciation Expense Concatenated Segments. For example, we have a concatenated segment value of …Satyavrat_Savarn 14 views 0 comments 0 points Started by Satyavrat_Savarn Oracle Transactional Business Intelligence
-
How to use And condition in Conditional formatting in Taleo OBI ?Hello Guys, We are trying to combine two conditions like if job board = 'xyz' and number of days the job is posted to to 'xyz' job board is >=7, then display the cell or…User_P2ZNQ 3 views 0 comments 0 points Started by User_P2ZNQ Oracle Business Intelligence Applications
-
Performance Tile not working with PercentajesHi guys, I'm having a problem trying to display a performance Tile in obiee. I'm reporting a total percentage but is seems that the performance tile object does't work w…
-
OBIEEwhen exporting thereport to excel it is onlydownloading 3573rows but my EM has the belowvalue.when exporting the report to CSV it is downloading the entire data.. it only happenswith excel..how can i get this resolved?
-
OBIEE Report not fetching outputI have configured a new database and a connection pool in my existing RPD and did the RPD development in all 3 layers. I can connect to the database from RPD and import …
-
BI Scheduled Report Job and Daylight Savings TimeSummary We had a scheduled that ran an hour early after daylight savings time ended Content There is a scheduled report job that runs at 5:30am each wednesday. With dayl…Rob Stahly 97 views 5 comments 0 points Most recent by Juliet Soriao Oracle Transactional Business Intelligence
-
Selecting the latest Order revisionSummary Need to retrieve the latest Orders revisions Content Hi, While creating an Analysis to retrieve the Sales Orders details we need to show only the latest revision…Mr H 136 views 10 comments 0 points Most recent by User_259TP Oracle Transactional Business Intelligence
-
Is it possible to do map visualisations in OTBISummary Is it possible to do map visualisations in OTBI Content Hi, Using only Oracle Transactional Business Intelligence (OTBI) with all the limitation of old Oracle Bu…Nathan CCC 67 views 2 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence -
ORA-03113: end-of-file on communication channel error - Please HelpContent Hi All, In last few months, for the second time we are facing one quite strange issue. Random users, with random reports (or some user with all reports) are faci…User_KOLMZ 102 views 3 comments 0 points Most recent by Aman Jain-Oracle Oracle Transactional Business Intelligence
-
Report not attached in email coming from agentSummary is there a size limit to the file Content We currently have a scheduled agent for a report that comes out as a csv report. However, the report is not shown as an…Kevin Lee Choon 107 views 5 comments 0 points Most recent by Julian Challenger-Oracle Oracle Transactional Business Intelligence
-
Is it possible to use SUM on a column where COUNT(DISTINCT(column) ) is used?Summary Is it possible to use SUM on a column where COUNT(DISTINCT(column) ) is used? Content Hi, Is it possible to use SUM on a column where COUNT(DISTINCT(column) ) is…Aloka Bhattacharya 152 views 5 comments 0 points Most recent by Aloka Bhattacharya Oracle Transactional Business Intelligence
-
Finding the alphabets from a Alphanumeric in OTBI.Summary: I have a requirement to identify the alphabets (be it upper/lower case) from a string. The format of the sting is as follows: SSN: XXX-XX-XXXX (112-10-1234) TIN…satya_nvs 79 views 2 comments 0 points Most recent by Venkat Koduvayur-Oracle Oracle Transactional Business Intelligence
-
How to Dipslay Total at the Top of Stacked Vertical Bar ChartSummary Need to know how to Dipslay Total at the Top of Stacked Vertical Bar Chart Content While representing data as vertical bar chart (due to groupings used/needed) I…Krishnaraja Nelli-47394 66 views 4 comments 0 points Most recent by Noelle Bartlam-Oracle Oracle Transactional Business Intelligence
-
Is there possible to create prompts in combine resultDear , i have otbi report which showing result based on two criteria means combine and now i want to click on colleague name and opens new report based on that name so i…Mirza_Adeel 56 views 3 comments 0 points Most recent by Amrita Gupta-Oracle Oracle Transactional Business Intelligence
-
OTBI Report running into error when I add Sum on a column-Sort has no work space in the work directoSummary OTBI Report running into error when I add Sum on a column-Sort has no work space in the work directory. Content Hi, I have an OTBI Report running into error when…Aloka Bhattacharya 86 views 5 comments 0 points Most recent by Amrita Gupta-Oracle Oracle Transactional Business Intelligence
-
OTBI Report Date Format changes when exporting to ExcelContent We are trying to change the formatting of a column in OTBI report by changing the column properties of each date columns. We are using the following format: Date…ZenG 280 views 2 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
Run an analysis (agent) as target user, but deliver to proxy userContent We have some sensitive data which are automatically shielded off through HR roles in the BI Catalog because they are obiee analysis in hcm subject areas. We have…MaartenDIF 46 views 3 comments 0 points Most recent by MaartenDIF Oracle Transactional Business Intelligence
-
OTBI session and repository variables full listContent Hi, could anyone provide the full list of session variables and repository variables available in OTBI Regards, AlbertoAlberto Boccato 107 views 6 comments 0 points Most recent by mgoswami Oracle Transactional Business Intelligence
-
Calculating Percentage in OBIEE ReportSummary Calculating the Percentage of two columns. One column being a calculated field in itself and the other pre-defined field. Content Hello, I am trying to calculate…MarkS 78 views 1 comment 0 points Most recent by Syed Misbauddin-Support-Oracle Oracle Transactional Business Intelligence
-
Is there a way to specify new default colors in OTBISummary Overwriting Default Colours for bar graphs and Pie Charts Content Hello Everyone, I'm looking for a way to overwrite the default colors for graphs. I know that I…Rob F 56 views 5 comments 0 points Most recent by SantoshKumarBhairi Oracle Transactional Business Intelligence
-
Smart view no longer connect to OBIEEContent Hi, I have installed the latest smart view and now found out that the private connection to obiee is no longer provided. below is the screenshot of old smart vie…Jenny Tan 26 views 1 comment 0 points Most recent by Christian Berg Oracle Transactional Business Intelligence
-
Display photographs in OAC AnalysisSummary Display photographs in OAC Analysis Content Facing a strange issue in OAC while displaying photos. Customer is capturing photographs of readings. These photos ar…SaurabhJaiswal-Oracle 37 views 2 comments 0 points Most recent by Nathan CCC Oracle Transactional Business Intelligence
-
Run OTBI Report in previous Accounting PeriodSummary Run OTBI period in previous Accounting Period Content I have a OTBI Report with Accounting Period as input parameter. Requirement is to run the report for curren…Vinod Kumar Mohanraj 66 views 2 comments 0 points Most recent by Vinod Kumar Mohanraj Oracle Transactional Business Intelligence
-
Drill to another Compound LayoutSummary How can I let users drill into a number that takes them to a 2nd compound layout on an analysis? Content Hello, I have an analysis that I plan on making into a d…slgott 57 views 2 comments 0 points Most recent by MaartenDIF Oracle Transactional Business Intelligence
-
Getting error in BICC while running the DOO Line DetailSummary BICC job is failing while running the DOO Line Detail Content BICC job is failing while running the Line Detail. Attached is the log file. Please help Table name…vijayakrishna 59 views 2 comments 0 points Most recent by vijayakrishna Oracle Transactional Business Intelligence
-
Unable to use Heat matrix on fusion OBISummary error in using heat map view (invalid view type) Content Hi I am unable to use Heat map visualization for HCM fusion OBI. I am gettign an error "Invalid view typ…Mohit Gupta-45440 26 views 1 comment 0 points Most recent by Robert Fighiroae-Oracle Oracle Transactional Business Intelligence