Angles for Oracle-Generator for Tableau User
About Angles for Oracle Generator Service
The Angles for Oracle Generator Service is a component that makes metadata and configuration information for Noetix Views (NoetixViews) and Noetix Analytics available to instances of the Angles for Oracle Generator. The information provided to the Angles for Oracle Generator enables the Tableau Desktop users to develop reports.
About Noetix ODBC for Oracle Driver
The Noetix ODBC for Oracle driver provides connectivity to NoetixViews and Noetix Analytics data sources. The driver supports the data access privileges (row-level security) and view-level authorization that are set up for users in NoetixViews, thereby ensuring that Tableau users can see only the information that they are authorized to access. The driver also provides Active Directory-based authentication for the Tableau Desktop users, thereby eliminating the need to maintain database accounts for the users.
About Angles for Oracle Generator for Tableau
The Angles for Oracle Generator is installed on end user workstations and provides the following benefits to the Tableau Desktop users and administrators:
- Enables the creation of Tableau data sources that are based on NoetixViews or Noetix Analytics data sources.
While it is possible to modify the Tableau data source files created by the Angles for Oracle Generator from within the Data Source tab of the Tableau Desktop, such modifications are not supported by insightsoftware.
- Supports a presentation layer that provides a business friendly view of the NoetixViews or Noetix Analytics metadata including the descriptions for the various metadata objects.
- Supports data filters for the NoetixViews columns and Noetix Analytics fields.
- Supports user authentication.
- Supports authorization, including the role-level and row-level security, for users of NoetixViews.
Support for NoetixViews Metadata
The following NoetixViews metadata objects are supported in the Angles for Oracle Generator:
- Standard, Cross Operations Extension (XOP), and global forms of the Noetix views.
- Key flexfield views associated with the global views.
- Parent-child hierarchies and parent-child essentials views for the Accounting Flexfield structures associated with the global views that support parent-child hierarchies out of the box.
- Row-level security (consisting of organization unit security and application-specific security) is supported in all forms of Noetix views only when data is queried by the Tableau Desktop users from live sources through the Noetix ODBC for Oracle driver. For information about security for the various forms of Noetix views, see the Noetix Views Administrator Guide.
However, the Noetix answers and structure-specific key flexfield views are not supported in the Angles for Oracle Generator.
Support for Noetix Analytics Metadata
The following Noetix Analytics metadata objects are supported in the Angles for Oracle Generator:
- NOETIXDM and NOETIXODS relationship sets.
- MAGDM and MAGODS relationship sets.
- Field definition folders that provide hierarchy information for Accounting Flexfield segments.
- Field definition folders that provide hierarchy information for customers or parties.
- Calculated fields based on numeric, string, or date type columns pertaining to one or more NOETIXODS or NOETIXDM tables used in a relationship set. The calculated fields can include expressions specific to the syntax of Tableau.