Pregeneration Considerations
Pregeneration ConsiderationsThe scalability and open architecture of Noetix Views (NoetixViews) provide flexibility in how you generate and use Noetix views within your Oracle E-Business Suite environment. As a part of the installation of NoetixViews, the data (.dat) files for the NoetixViews modules purchased by your organization are installed. They are used by the Noetix Views Administrator (...
Generation Stages
Generation StagesThe NoetixViews generation comprises generation preparations, generation phases, and generation administration.As a part of generation preparations, you need to complete the pregeneration tasks. see Generation Stages.For generating views, you have to start the NoetixViews Administrator and perform the steps in each generation phase. The generation phases are as follows:Stage 1:...
Generate Using NoetixViews Administrator
Generate Using NoetixViews AdministratorOption 1: Generate Using NoetixViews AdministratorNoetix views can be generated from a client computer using the NoetixViews Administrator. This generation method involves running NoetixViews Administrator on a Microsoft Windows-based client computer and performing the generation using a series of wizards.Before generating Noetix views you must complete t...
Generate Using Scripts
Generate Using ScriptsOption 2: Generate Using ScriptsThe scripts-based generation involves generating Noetix views by running scripts from SQL*Plus and provides a straightforward means of providing information and making generation decisions. A scripts-based generation may be preferable for large generations or certain Microsoft Windows environments. For information about determining the best ...
Run Noetix Answer Builder
Run Noetix Answer BuilderThe Noetix Answer Builder generates metadata for custom prebuilt reports based upon the Noetix views. After successfully running the Noetix Answer Builder, you must run Noetix generators to generate the metadata generated by the Noetix Answer Builder into the meta-layers of the business intelligence (BI) tools.You can run the Noetix Answer Builder when prompted during S...
Choose a Generation Method
Choose a Generation MethodOverviewPeriodic maintenance is required to keep your Noetix views generation in synchronization with your Oracle E-Business Suite configuration. insigihtsoftwarerecommends frequent regenerations to keep Noetix Views (NoetixViews) metadata and user accounts synchronized with changes made to your Oracle database or applications (for example, to pick up security changes ...
Option 1: Regenerate Using NoetixViews Administrator
Option 1: Regenerate Using NoetixViews AdministratorRegenerating views using the NoetixViews Administrator involves walking through a short series of wizards in the application used to administer NoetixViews. The steps you follow are very similar to the steps used when initially generating NoetixViews.This regeneration method is performed using a Microsoft Windows-based client computer, usually...
Option 2 Regenerate Using Scripts
Option 2 Regenerate Using ScriptsOption 2: Regenerate Using ScriptsRegenerating Noetix views using scripts involves running a series of scripts from SQL*Plus. The steps you follow are very similar to the steps used when initially generating Noetix views.This regeneration method is mainly performed on a UNIX-based computer. If the NoetixViews files and scripts are not already present on this com...
Option 3 Regenerate Using Scheduled Concurrent Manager Job
Option 3 Regenerate Using Scheduled Concurrent Manager JobOption 3: Regenerate with Scheduled Concurrent Manager JobRegenerating Noetix views using a scheduled Concurrent Manager job on UNIX requires a number of initial tasks to set up the environment and parameters to be used. After this initial setup is completed, no additional user input is required, and the regenerations can be scheduled.If...
Option 4: Regenerate Using Scheduled Cron Job
Option 4: Regenerate Using Scheduled Cron JobRegenerating Noetix views using Cron, the UNIX scheduling service, requires a number of initial tasks to set up the environment and parameters to be used. After this initial setup is completed, regenerations can be run on a scheduled basis with no user input required.If you have upgraded NoetixViews and have used the Cron earlier to regenerate your v...
Option 5: Incremental Regeneration
Option 5: Incremental RegenerationThe incremental regeneration process generates only new custom views and those views that have been modified since the last run of Stage 4 or incremental regeneration. Incremental regeneration requires the NoetixViews Workbench and generates only the global form of the views. The process can incrementally regenerate all the customizations that are created throu...
Regenerate Noetix Answers/Help File Separately
Regenerate Noetix Answers/Help File SeparatelyThis section provides information about the tasks to be performed after the regeneration of views, such as, regenerating Noetix answers and Noetix Help File.Regenerate Noetix AnswersAfter the views are regenerated, the Noetix answers should also be regenerated. Thereafter, the updated views and answers can be generated into the meta-layers of the bu...
Maintenance
MaintenanceThe following topics explain the concepts and procedures related to
the maintenance of NoetixViews:Locate Important Directories and FilesNoetixViews Administrator ToolsAdministrative ScriptsOrganization Refrsh FeatureResolve Issues in Your Noetix Views GenerationManage Key Flexfield Data in the Global ViewsRefresh Parent Child Hierarchy DataNoetixViews Customization
Locate Important Directories and Files
Locate Important Directories and FilesThe Noetix Views Administrator (NoetixViews Administrator) equips you with the tools to perform a number of maintenance tasks from the administrator’s computer. Many of the Noetix Views (NoetixViews) maintenance tasks can also be performed using SQL scripts.Locate Important Directories and FilesThis section provides information about the location of the imp...
NoetixViews Administrator Tools
NoetixViews Administrator ToolsThe following tools and features are available within the NoetixViews Administrator. For information about other features, on the Help menu, click Help Topics.To access these toolsClick Start > All Programs > NoetixViews > NoetixViews Administrator. The welcome dialog box is displayed.Locate the tool on the toolbar or on the menu options.Change Base Installation D...
Administrative Scripts
Administrative ScriptsThis section provides information about the script files that can be used to complete a variety of generation and maintenance tasks pertaining to NoetixViews. A number of important UNIX, MS-DOS, and SQL scripts are available in the NOETIX SYS user directory (by default, <installation folder>\Noetix Corporation\NoetixViews\Installs\<NOETIX SYS TNS>) on a computer running Mi...
Organization Refrsh Feature
Organization Refrsh FeatureYou can use the organization refresh feature to enable the global forms of Noetix views to detect and process newly added organizations in Oracle E-Business Suite without regenerating the views.The following table lists the Oracle E-Business Suite modules and the corresponding organizations for which you can use the organization refresh feature.Oracle E-Business Suite...
Resolve Issues in Your Noetix Views Generation
Resolve Issues in Your Noetix Views GenerationIf there is an issue in your Noetix views generation (for example, if NoetixViews is not functioning correctly or if it is not returning data as described in the Noetix Help File), a workaround may be provided by insightsoftwareSupport. The workaround is typically in the form of a modified SQL script that will be placed in the NOETIX SYS user direct...
Manage Key Flexfield Data in the Global Views
Manage Key Flexfield Data in the Global ViewsIn Noetix global views that leverage the key flexfield views, the relevant segment values or descriptions related to a key flexfield code combination defined at your site are retrieved by using the data cache or no data cache option. In the data cache option, data is retrieved using the key flexfield data cache tables that are maintained by Noetix. I...
Refresh Parent Child Hierarchy Data
Refresh Parent Child Hierarchy DataThe parent-child hierarchies corresponding to the Accounting Flexfield segments are stored in a flattened table. Based on the parent-child hierarchy data available in the flattened table, the parent-child hierarchies and parent-child essentials views are generated during Stage 4. However, the flattened table needs to be refreshed to reflect the changes in the ...
NoetixViews Customization
NoetixViews CustomizationThis section provides information about the customization of Noetix views for various purposes. The section also contains information about the Noetix Customization Maintenance (NCM) program and Noetix Views Workbench (NoetixViews Workbench).For information about the best practices and checklist for accomplishing a business intelligence (BI) report through its various s...
Noetix Query User Management
Noetix Query User ManagementThe following topics explain the concepts and procedures related to
the Noetix Query user management:Types of Query UsersGather User InformationCreate Noetix Query Users Using GUICreating Noetix Query Users using ScriptsModify Noetix Query UsersDelete Noetix Query UsersData Security in NoetixViewsRefresh Security for Query UsersProvide Row-Level Security in BI Tool...
Types of Query Users
Types of Query UsersIn Noetix Views (NoetixViews), Noetix query users’ access to data is determined by the roles, the Oracle General Ledger security access, and the custom Oracle Human Resources and Oracle U.S. Federal Financials security settings. When a user is set up to use Oracle Applications mode security, the Oracle E-Business Suite responsibilities and security profiles assigned to the u...
Gather User Information
Gather User InformationYou need to determine which users in your organization need to access Noetix views before adding them as Noetix query users.Before you begin, you should make a list of the Oracle E-Business Suite users and responsibilities, and the database users who need to be set up as Noetix query users to grant them access to the views. This list should include:The name for each user....
Create Noetix Query Users Using GUI
Create Noetix Query Users Using GUICreating a Noetix query user involves either of the following:Granting an existing database user, Oracle E-Business Suite user, or Oracle E-Business Suite responsibility access to Noetix views.Creating a database user and granting access to NoetixViews. You can add Noetix query users using the Noetix Query User Maintenance tab of the Security Manager dialog bo...
Creating Noetix Query Users using Scripts
Creating Noetix Query Users using ScriptsThe scripts-based method of creating Noetix query users allows you to add multiple Noetix query users at the same time. You can add existing database users and Oracle E-Business Suite users and responsibilities as Noetix query users of Database User (Type U), Oracle E-Business Suite Authenticated User (Type A), and Oracle E-Business Suite Authenticated R...
Delete Noetix Query Users
Delete Noetix Query UsersA Noetix query user account can be deleted with the use of the Noetix Query User Maintenance tab of the Security Manager dialog box or scripts.Important: Using the Noetix Query User Maintenance tab, you can delete only Noetix query users of the Oracle E-Business Suite Authenticated User (Type A), Oracle E-Business Suite Authenticated Responsibility (Type R), and Databas...
Data Security in NoetixViews
Data Security in NoetixViewsThe data security model provided in NoetixViews has the following components:User authentication: This component concerns the validation of the credentials provided by the user while logging on to business intelligence (BI) tools. The credentials consist of a user name, a password, and, at times, an Oracle E-Business Suite responsibility.View and answer authorization...
Refresh Security for Query Users
Refresh Security for Query UsersRefresh Security for Query UsersThe data access privileges of Noetix query users are determined by a security data cache. The settings in the security data cache determine the organizational units for the views modules that query users can access. In the case of Noetix query users of the Oracle E-Business Suite Authenticated User (Type A) and Oracle E-Business Su...
Provide Row-Level Security in BI Tools
Provide Row-Level Security in BI ToolsProvide Row-Level Security in BI Tools provides the ability to restrict Noetix query user's access to data in global Noetix views. For the Noetix query users of the Oracle E-Business Suite Authenticated User (Type A) type, row-level security is automatically configured based on their data access privileges in Oracle E-Business Suite. For Noetix query users ...