Popular Tags
- OTBI 1,468
- Reporting 1,403
- FDI 1,174
- Fusion AI Data Platform 1,028
- Analysis and Data Visualization 999
- BI Publisher 870
- Analysis 686
- Oracle Fusion Analytics 604
- Administration 556
- OAC 506
- OBIEE 435
- Fusion HCM Analytics 421
- Analytics 414
- Fusion ERP Analytics 402
- BI Publisher Data Models 360
- Security 301
- HCM 274
- BIP 267
- Answers 265
- Analyses 255
- Developers 246
- Oracle Analytics Cloud 234
- Data Modelling and Datasets 230
- ERP Analytics Content 216
- Data Connectivity 212
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Table
Discussion List
-
10Enhancement Request: Dynamic Column Display Based on Checkbox Selection in Table VisualizationEnhancement Request: Dynamic Column Display Based on Checkbox Selection in Table Visualization Description: We would like to have the ability in OAC to dynamically show … -
11Enable alternate styling in table or pivot table viz.To ease the readiness or rows in tables or pivot tables in OAC DV, alternate styling to rows should be allowed when formatting data background color, this option already…Eslam Elbagoory 52 views 3 comments 11 points Most recent by Bhaskar Konar Oracle Analytics Idea Lab
-
11Need a mechanism to identify table/calculation dependency in workbook to safely delete unused onesWe need to establish a way to clearly identify both the table and the associated calculation reference. Its highly possible to have a change in table structure which wil…Ancy Paul-Oracle 82 views 6 comments 11 points Most recent by philipgodfrey Oracle Analytics Idea Lab -
5Ability to restrict default ROWCOUNT (number of rows) in Table View QueryWe have some a real-time use case to analyze a DB based dataset that has 100Million+ (and growing) rows. While the metrics like sum & count work like a charm, the challe…Mohit Shimpi-Oracle 21 views 1 comment 5 points Most recent by Sherry J George Oracle Analytics Idea Lab -
Workaround ideas to include or exclude columns in DV?In OAC and classic, there's a feature that allows you to choose to include extra columns in a table or exclude columns from a table. We would love to be able to do somet…Caroline Blanchard 31 views 1 comment 3 points Most recent by Dorothy Joseph-Oracle Oracle Fusion AI Data Platform Forum -
How to access the link between OTBI column names to fields in the Oracle data tablesI'm designing reporting using OTBI, however there may be a requirement to query the tables directly using BIP. I would like to understand, where I am selecting columns f…Rachel_ 51 views 4 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence Forum
-
FDI Dataset Editor Filter ConsiderationsReaching out to inquire re: anyone's experience running into filter limitations with FDI's dataset editor. We are trying to embed filters in the dataset editor page for …Matt_B 111 views 1 comment 0 points Most recent by JohnW-Oracle Oracle Fusion AI Data Platform Forum -
I see a table in ALL_TAB_COLUMNS, but when I try to query to table it says it doesn't exist.So I was looking for a table and I could see it in the ALL_TAB_COLUMNS using this query: SELECT DISTINCT TABLE_NAME FROM ALL_TAB_COLUMNS WHERE TABLE_NAME = 'ase_app_role… -
Convert FDI Workbook Tables into DatasetsWhat is the most direct way to convert a table that a user has created within a workbook into a standalone dataset? I understand the table visualization can exported to …
-
6Merge the Table and Pivot Visualization Types into oneHaving only one visualization for Table and Pivot table with a property to switch from one to the other. Combine these two in one: The pivot table viz type should assume…Benjamin Arnulf-Oracle 32 views 2 comments 6 points Most recent by R Stonaker Oracle Analytics Idea Lab -
11Oracle Time and Labor table HWM_TM_REP_ATRB_USAGES - LATEST_VERSION flagI am facing an issue regarding HWM_TM_REP_ATRB_USAGES table. In particular I have seen that for some employees the table HWM_TM_REP_ATRB_USAGES doesn't show LATEST_VERSI…Marina Chiovato 81 views 3 comments 11 points Most recent by Nupur Joshi-Oracle Oracle Fusion AI Data Platform Idea Lab
-
How to display Historic data in FDIHi, I see that by adding some FACTS metric (eg: Headcount Turnover) I'm able to see historic data for assignments and I can also filter by date: Is there a way to have t…Stefano_Mazzocca 71 views 1 comment 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Fusion AI Data Platform Forum -
How to custom aggregate rows of a table?I have a list of companies, let's say A, B, C, D, E, F. I want to aggregate them in a custom way, let's say 1, 2, 3 where 1 = {A,B}, 2 = {C,D}, 3 = {E, F}. How can I do …Stefano_Mazzocca 51 views 4 comments 0 points Most recent by Benjamin Arnulf-Oracle Oracle Fusion AI Data Platform Forum
-
17DV: Logical Date columns sort differently on a chart vs a tableSorting on a logical date column should be consistent across visualization types. Currently a logical column (e.g. CAST ('01-' || MMM-YYYY) AS DATE)) sorting within a ta…
-
PVO help needed for data augmentationHi, I'm trying to pull HCM data through data augmentation and I'm struggling a bit. I'm trying to have a report with all the legal employer information (name, tax regist…Lauriane Massin Whitaker 31 views 3 comments 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Fusion AI Data Platform Forum -
24B: BIP - What is the subject area or tables to get transaction approvers from Learning?Please provide the subject area or an SQL tables to retrieve transaction approvers from the Learning module (24B). I have tried using this one, but it doesn't return any…Nipon 31 views 1 comment 0 points Most recent by Rajesh L-Oracle Oracle Business Intelligence Applications Forum
-
Performer of the Action Plan [Talent management] information in BI publisher tablesI'm looking for this information in the bi Publisher tables: I looked through its tables: HRT_TASK_USERS, HRT_TASKS, HRT_TASK_OBJ_RELATIONS, but I didn't find it, do you…User_2DB15 51 views 2 comments 0 points Most recent by John Hung-Oracle Oracle Transactional Business Intelligence Forum
-
4Possibility to use header/subheaders to organize columns in Tables/Pivot tablesHello, It would be desirable to be able to add Header/Subheaders to better organize data in Tables/Pivot tables in DV. Thanks. Best regards, Jorge -
Which tables stores value for Order Orchestration Function and error messagesCan someone help/confirm Which Oracle tables stores value for Order Orchestration Function and error messages (under Financials - Order Management module)Hemant_Jain 11 views 1 comment 0 points Most recent by Abhilash K - Deloitte USI Oracle Analytics Publisher Forum
-
Table that stores the file contents of an attachmentHello, We need a table that stores the base64 format of the attachment uploaded in a work order or if there is any table that stores the binary format of the file conten…Radhika Sharma 221 views 1 comment 0 points Most recent by Gianni Ceresa Oracle Analytics Publisher Forum