About NoetixViews
Noetix Views (NoetixViews) unlocks the data hidden in corporate databases by providing user-friendly, plug-and-play business views of Oracle E-Business Suite data, helping speed the flow of information throughout the enterprise. Customized to each unique database configuration, the automated generation process is a snap—cutting weeks off typical custom generations. NoetixViews provides the fast track to delivering familiar business terminology right to employees, partners, and customers.
By hiding complexity within metadata, NoetixViews simplifies and greatly accelerates report generation and ad hoc query creation, empowering decision makers and front-line employees with timely and accurate access to critical information. The metadata has been hand-crafted by insigihtsoftwareto meet common business reporting needs with each view designed for a specific functional coverage area. Designed with integration in mind, NoetixViews is built on an open architecture platform, extending the power of NoetixViews information to a myriad of third-party reporting and analytical tools.
Benefits of NoetixViews
The benefits of NoetixViews include:
Quick implementation: In as few as two days, NoetixViews can be up and running, delivering timely and accurate access to critical information. Thus, providing huge savings in the development costs.
Automatic upgrade protection: The reports written for NoetixViews using any reporting tool are insulated from the Oracle E-Business Suite schema changes. If there is a new release (patches, service packs, or upgrades) of Oracle E-Business Suite and there is some change in the Oracle schema that might result in broken reports, insigihtsoftwarewill release a compatible version of NoetixViews so that your reports based on the Noetix views will automatically adjust to the new Oracle schema changes and continue to return accurate data. This is available to you at no extra cost.
Comprehensive documentation: NoetixViews comes complete with a comprehensive help file and documentation, providing valuable information to accelerate report development and generation.
Automatic customized generation: Custom business views simplify data access, yielding immediate return on investment. The NoetixViews scripts detect additional configuration information about the Oracle
E-Business Suite schema on which they are installed and generate Noetix views with customer-specific columns, such as descriptive flexfields.
NoetixViews Basics
This section explains general features and components of NoetixViews as well as concepts like roles and security. Being familiar with these terms will assist you in generating and maintaining Noetix views. An expanded introduction to views, roles, and using NoetixViews can be found in your MagnitudeNoetixViews User Guide.
In accordance with the changes implemented in Oracle E-Business Suite Release 12, the term “base currency” has been replaced with “primary currency” and the term “foreign currency” has been replaced with “transaction currency.”
NoetixViews Administrator
The Noetix Views Administrator (NoetixViews Administrator) is a Microsoft Windows-based application that allows you to complete a full generation of Noetix views from a client computer. A series of wizards guides you through the generation process, from creating a Noetix System Administration User account to generating the customized views for your site.
NoetixViews Administrator is also used for maintenance tasks, such as setting up query users, regenerating views, and generating the Noetix Help File.
For more information about NoetixViews Administrator, see Generate Using NoetixViews Administrator, Noetix Query User Management and Maintenance.
Noetix Help File
The Noetix Help File helps you in searching information pertaining to a specific view or column. It helps you to easily locate a NoetixViews topic (for example, role, view, column or query construction) within the help file.
The Noetix Help File is generated for each distinct Noetix System Administration User account and a set of Noetix views. To facilitate report creation by the functional users who do not have technical knowledge about the complicated Oracle table structures, the help file represents the complex Oracle table names and column names with common user terminology.
The Noetix Help File is available in Microsoft WinHelp, HTML, and Query Tool Help formats.
For more information about the Noetix Help File, see Choose Help Formats to Generate in “Generation of Views.”
Noetix Query Users
Noetix query users are database users, Oracle E-Business Suite users, or Oracle E-Business Suite responsibilities that are granted access to a set of Noetix views. Noetix query users can be set up after completing the generation process.
The Noetix System Administration User creates a Noetix query user by selecting a database user (or, with DBA privileges, creating one) and granting this user a set of Noetix roles appropriate for the user’s security level and information access needs. After this setup, this database user is considered a Noetix query user.
Users can also be set up to be authenticated against the Oracle E-Business Suite security. In this case, Oracle
E-Business Suite users and/or responsibilities are set up in the NoetixViews Administrator with access to appropriate roles.
To optimize system resources and reduce the possibility of runaway queries, Oracle provides resource limits. Resource limits control the following four variables:
A user’s CPU usage and disk I/O
The number of sessions per user
The maximum connect time
The amount of memory used by a multi-threaded server session
You can use the Create Profile dialog box of SQL*DBA to create or modify a user profile. For more information on user profiles, refer to Oracle’s Server Administrator’s Guide and SQL Language Reference Manual.
For more information about query users, see Preface.
Noetix Roles
Noetix roles are assigned to Noetix query users to both provide and restrict access to data held in Oracle
E-Business Suite. Each role grants access to a set of views. Roles are usually generated according to the level of granularity inherent in a specific Oracle Application.
The concept of a role is an Oracle Database feature. Noetix query users granted a role automatically have access to all the views assigned to that role. Roles are assigned to Noetix query users after generation. For more information about assigning roles, see Manage Access to Data Based on Roles in “Noetix Query User Management.”
General Ledger Security
When a Noetix query user requires access to secure Oracle General Ledger data, you can use NoetixViews Administrator to assign the proper General Ledger security.
General Ledger security rules control access to transactions or balances in General Ledger. These security rules should be predetermined by the Oracle E-Business Suite Administrator before assigning them to Noetix query users in NoetixViews Administrator.
Noetix query users can be set up to have no access or full access to secure General Ledger data, or to allow the responsibility with which a user logs on to determine what data should be accessible. Users can also be given custom access and assigned security rules for each chart of accounts or ledger/set of books. A user can be assigned any valid security rule, regardless of what roles (if any) they have been assigned.
If you add a security rule in Oracle E-Business Suite to a new segment of the Accounting Flexfield or create a ledger/set of books, the views must be regenerated before they incorporate the changes. With any change or addition to security rules in Oracle E-Business Suite, you should review and update users’ access to General Ledger data in NoetixViews.
For more information about General Ledger security, see in “Module-Specific Information.”
Multi-Currency
Oracle E-Business Suite allows you to work with currency amounts in either primary or transaction currency units. Additional functionality has been built into both the views and the Noetix Help File to help you to select the Oracle E-Business Suite data using transaction and primary currency units.
Noetix views are generated with the ability to reflect the use of more than one currency in your applications configuration. In General Ledger, each ledger/set of books is defined with a single primary currency unit. Individual transactions can be entered in any currency unit (that is, a currency different from the primary currency for each ledger/set of books).
When querying data from NoetixViews, use the Currency Code column to select the primary or transaction currency in which you would prefer to view the data.
NoetixAnswers
NoetixAnswers are prebuilt reports that are specific to your Oracle E-Business Suite configuration. NoetixAnswers are available for each NoetixViews module and save you the trouble of complicated report development.
After Stage 4 is complete, you can run the Noetix Answer Builder. Thereafter, you can generate the views and answers into the meta-layers of business intelligence (BI) tools with the use of the Noetix generators.