Popular Tags
- OTBI 1,407
- Reporting 1,365
- FDI 990
- Analysis and Data Visualization 954
- BI Publisher 821
- Analysis 663
- Administration 553
- Oracle Fusion Analytics 550
- OBIEE 421
- Analytics 348
- OAC 339
- BI Publisher Data Models 335
- Security 273
- Answers 261
- Analyses 253
- Developers 240
- HCM 239
- BIP 233
- Data Modelling and Datasets 218
- Data Connectivity 206
- ERP Analytics Content 199
- BI Publisher Report Templates 185
- Report Output 180
- Agents 151
- Customizing Reports 146
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Table
Discussion List
-
8Enable 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 32 views 1 comment 8 points Most recent by R Stonaker Oracle Analytics Cloud and Server Idea Lab -
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…User_BAITI 35 views 4 comments 0 points Most recent by Bhaskar Konar Oracle Transactional Business Intelligence
-
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 … -
4Need a mechanism to identify the table and calculation reference used in workbookWe 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 11 views 0 comments 4 points Started by Ancy Paul-Oracle Oracle Analytics Cloud and Server Idea Lab
-
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 21 views 2 comments 6 points Most recent by R Stonaker Oracle Analytics Cloud and Server 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 62 views 3 comments 11 points Most recent by Nupur Joshi-Oracle Oracle Fusion Data Intelligence 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 63 views 1 comment 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Fusion Data Intelligence -
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 30 views 4 comments 0 points Most recent by Benjamin Arnulf-Oracle Oracle Fusion Data Intelligence
-
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…Jayko Paten 21 views 1 comment 17 points Most recent by R Stonaker Oracle Analytics Cloud and Server Idea Lab
-
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 21 views 3 comments 0 points Most recent by Mallikarjuna Kuppauru-Oracle Oracle Fusion Data Intelligence -
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 33 views 1 comment 0 points Most recent by Rajesh L-Oracle Oracle Business Intelligence Applications
-
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
-
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, JorgeJorge Olmeda 21 views 2 comments 4 points Most recent by Jorge Olmeda Oracle Analytics Cloud and Server Idea Lab -
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
-
2Ability 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 11 views 0 comments 2 points Started by Mohit Shimpi-Oracle Oracle Analytics Cloud and Server Idea Lab -
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…
-
Help with Development of Payroll GL Report in BIPGood Day, We're preparing for go live at the end of this month on Oracle Fusion Cloud. Our team is learning OTBI and BIP in preparation for this, and I have a question r…Jared Custer 171 views 9 comments 0 points Most recent by Renuka Nuguru-Oracle Oracle Analytics Publisher -
Table for employees role history.Is there any table or related table in HCM that stores historical role assignment data and transaction data, and timestamps history for an employee?James Leborn 21 views 0 comments 3 points Started by James Leborn Oracle Transactional Business Intelligence