This topic describes the new features and known issues for Angles Hub 24.4, released in December 2024.
New Features
The new features in Angles Hub 24.4 are as follows:
Noetix Web Query (NWQ) Migration to Angles Hub with the Excel Add-in
The new Excel Add-in for Angles Hub makes it easier to migrate Noetix Web Query (NWQ) Excel Add-in reports into a unified Excel environment. It simplifies the process of integrating existing NWQ reports, enhancing self-service reporting without disrupting current workflows. The migration tool automatically transfers key NWQ metadata into Angles Hub, ensuring a smooth transition. It supports both public and private report folders, helping users centralize their reports and set them up for future needs, all while reducing the complexity of migration. This feature helps NWQ Excel Add-in users quickly adopt Angles Hub for their reporting requirements.
For more information, see Key Highlights.
OCA Business Views and OADW Compatibility
Angles for Oracle provides pre-built business views for essential OCA modules like financials, supply chain management (SCM), and human capital management (HCM), facilitating customers' transition from Oracle to Oracle Cloud Applications (OCA). These views act as a semantic layer, enabling quick integration with Oracle Autonomous Data Warehouse (OADW) for reporting. The OCA business views are compatible with the Snowflake, Azure SQL, and OADW databases.
Angles for Oracle also support flex fields personalization so that customers can customize their views. The data security is enhanced to ensure safe and compliant reporting. Additionally, we enhanced support for replicating data from OCA to OADW, ensuring smooth and consistent reporting across the platform.
Compatible with Oracle’s Cloud 24D
Angles for Oracle 24.4 supports Oracle’s Cloud 24D. To provide you with the most up-to-date reporting capabilities, all data pipelines and business views have been adjusted to reflect the changes in 24D and are compatible across financials, supply chain management, project portfolio management, and human capital management.
Known Issues
The known issues in Angles Hub are as follows:
Excess Metadata Extraction in Platform Report Extractor
The Platform Report Extractor retrieves metadata for multiple views, even when extracting a single report, which may lead to unnecessary data retrieval, causing confusion and inefficiencies in metadata management.
[ANGO-3809]
Reports with Calculated Fields Cannot Be Extracted
Reports containing calculated fields are currently not supported for extraction from the Noetix Platform. As a result, users who rely on calculated fields for reporting may face limitations when extracting reports and importing content to Angles Hub.
[ANGO-3810]
Prebuilt reports fail to run in Excel Add-in
The prebuilt Angles for Oracle reports fail to run in the Excel Add-in. As a result, users cannot directly utilize standard reports in the Excel Add-in without making adjustments. The alternative solution is to copy the report and manually adjust parameters, filters, and default values before running it.
[ANGO-3811]
Imported reports from Noetix Web Query (NWQ) fail to run in Excel Add-in
The imported reports from Noetix Web Query (NWQ) to Angles Hub fail to run in the Excel Add-in. As a result, users, who have migrated reported from NWQ, cannot directly utilize standard reports in the Excel Add-in without making adjustments. The alternative solution is to copy the report and manually adjust parameters, filters, and default values before running it.
[ANGO-3812]
Date Fields as Optional Parameters Cannot Be Cleared in Excel Add-in
Users are unable to clear the default value for a date field when it is set as an optional parameter. This restricts flexibility in report execution when working with date-based filtering. As a temporary solution, users can modify the default date value instead of clearing it entirely.
[ANGO-3814]
Error occurs when the Property icon is selected
When the Properties icon is selected in the Excel Add-in, an error occurs, hindering users from modifying report configurations effectively. As a workaround, users should avoid selecting the Properties icon or restart the application if an error occurs.
Excel Add-in Reports crash due to data type mismatch
If the extracted report data does not align with the expected data type, the Excel Add-in may crash, causing disruptions when working with reports containing unexpected or inconsistent data types. As a workaround, validate data types before extraction and ensure consistent formatting across datasets. Additionally, apply to_char and to_number formatting in the reports to align with expected data.
Report Header Row in Excel Add-in gets overwritten after modifying column labels
If column labels are modified in an Excel Add-in report, the header row is overwritten upon running the report, causing users to lose customized headers and leading to inconsistencies in report formatting. As a workaround, save a separate version of the report after modifying column labels. Alternatively, modify the SQL query with appropriate column aliases to reflect the headers, or define the column names in the Column Criteria tab.
Prolonged initial load time for reports in Excel Add-in
When you try to load the reports for the first time in the Excel Add-in, it takes longer than expected. This delays user workflows, especially when there are a large number of reports. As a workaround, optimize the number of reports assigned to the appropriate workspaces. Alternatively, retrieve the report list in advance, and subsequent report retrieval will quicker.
Excel Add-in locks Workbook while running reports
When a report is running in one sheet, all other sheets within the workbook become unusable until the process completes. As a result, users cannot interact with other sheets, disrupting workflows, especially for large reports. As a workaround, apply filters to reduce data size and run reports in smaller batches.
Excel Add-in locks all open Excel Add-in workbooks while running reports
When a report is running in the Excel Add-in, not only is the current workbook locked, but all other open Excel add-in workbooks also become unusable until the process completes. This prevents users from switching to or working in other Excel workbooks, causing disruptions, especially when handling multiple reports. To mitigate this, apply filters to reduce data size, run reports in smaller batches, or use Power BI or Tableau for report execution when possible.
[ANGO-3848]
Addressing Excel Generator Limitations with Excel Add-in
The Excel Generator functionality related to filters, parameters, and data retrieval has some limitations, preventing users from generating reports with advanced filters and parameters. To address this, use the Excel Add-in instead, which provides equivalent functionality.
Export to Excel not working as expected
The Export to Excel feature does not function as expected, preventing users from exporting reports directly to Excel. To address this, use the Excel Add-in for exporting and working with reports in Excel.
Automatic Fill-Down not supported in Excel Add-in
The Excel Add-in does not automatically fill down formulas based on the retrieved line count, requiring users to manually apply formulas to additional rows. To address this, perform a manual fill-down after running reports.
Automatic data range adjustment for pivot tables and diagrams not supported
The Excel Add-in does not automatically adjust data ranges for pivot tables or diagrams based on the retrieved line count, requiring users to manually update pivot table ranges and diagram references after data retrieval. To address this, adjust data ranges manually when new data is retrieved.
Sorting reports based on module, workspace, or view name not supported
Users cannot sort reports based on module, workspace, or view name, making it difficult to organize and locate reports efficiently. To address this, use manual filtering or search functions as an alternative sorting method.
Report Definitions do not support column sorting in the SQL Query or Columns Criteria tab
Users are unable to sort report columns in the SQL Query or Column Criteria tab, which restricts flexibility in report structuring and requires post-extraction sorting. As a workaround, sorting can be applied at the database query level before generating reports.
Snapshot-Based Reports do not allow column aliases
Reports that rely on snapshot-based data retrieval do not support column aliases, preventing users from renaming or customizing column headers dynamically. As a workaround, use standard reports where aliasing is supported or modify the report output manually.
Complex SQL queries not supported in report definition's SQL Query
The reporting engine does not support complex SQL query structures, limiting advanced query customization. Users who rely on nested queries, CTEs, or subqueries may face execution failures. As a workaround, break down queries into simpler structures, pre-process data within the database, or use snapshot-based reports.
Snapshot rescheduling not reflected in user interface (UI)
When rescheduling a snapshot-based report, the changes do not reflect immediately in the user interface (UI), causing users to assume the schedule has not been updated. As a workaround, refresh the page manually or search for "Current Scheduler is" in the Scheduler tab.
[ANGO-3843]
Personal workspaces must be manually created by administrators
User-specific personal workspaces do not generate automatically and must be manually configured by an admin, delaying onboarding and increasing the administrative workload. As a workaround, implement a workspace creation policy as part of user provisioning.
On-Premise or Offline Hub with single sign-on (SSO) prevents Excel Add-in usage
Customers using an on-premise or offline Hub with Single sign-on (SSO) authentication cannot access the Excel Add-in, meaning the add-in will not function for users with this configuration. As a workaround, review authentication settings or consider an alternative user configuration for Excel Add-in access.
Related topics