Skip to main content
insightsoftware Documentation insightsoftware Documentation
{%article.title%}
Published:
Was this article helpful?
0 out of 0 found this helpful

Regenerating NoetixViews metadata into Oracle Analytics repository

This chapter provides information about regeneration of NoetixViews metadata into the Oracle Analytics repository. The chapter also provides information about the prerequisites and procedures to regenerate.

When to Regenerate NoetixViews Metadata

You may need to regenerate NoetixViews metadata into the repository periodically. The following are the conditions in which you would typically perform a regeneration:

  • NoetixViews schema definition changes
  • NoetixViews are regenerated
  • Want to add a NoetixViews role to the Oracle Analytics repository
  • NoetixViews upgrade

Previously Generated Subject Areas and Roles

The Choose Roles and Choose Subject Areas dialogs provide visual cues to indicate which subject areas, roles and relationship sets were previously generated. These cues utilize circles with the following colors:

  • Gray: Gray circles denote subject areas or roles that do not exist in the repository.
  • Blue: Blue circles denote subject areas or roles that exist in the repository.
  • Green: Green circles denote subject areas or roles that exist in the repository and are synchronized with NoetixViews.
  • Red: Red circles denote subject areas or roles that exist in the repository and require regeneration to synchronize them with NoetixViews.

Red and green cues are only available for NoetixViews 6.5 and higher. The Angles for Oracle Generator is unable to read the state of objects in earlier versions of NoetixViews and cannot show items in red or green as a result.

In addition, the Choose dialog provides a Select based on Oracle BI repository checkbox to make it easier for administrators to regenerate all of the content that was previously generated into the repository. Selecting this option will overwrite the current subject area and role selection with the specific subject areas, and roles that exist in the repository shown at the bottom left corner of the dialog. This box is selected automatically when the view-level regeneration option is selected for NoetixViews 6.5 and above.

Content generated into an Oracle Analytics repository by a previous version of Angles for Oracle Generator must undergo a full regeneration before this capability can be used.

Actions Performed during Regeneration

The Choose dialog gives specific information on how subject areas and roles will be modified during regeneration, which is displayed in the Action column of the dialog:

  • Create: Subject areas or roles marked with Create are the ones that do not yet exist in the repository. They have been selected for generation, and will be added to the existing repository.
  • Do not create: Subject areas or roles marked with Do not create are the ones that don’t currently exist in the repository. They have not been selected, and will be ignored by the Angles for Oracle Generator.
  • Regenerate: Subject areas or roles marked with Regenerate are the ones that already exist in the repository. They have been selected, and will be synchronized to reflect their definitions in NoetixViews.
  • Regenerate changed objects: Subject areas or roles marked with Regenerate changed objects are the ones that exist in the repository, and contain one or more views that have changed in NoetixViews since the last Oracle Analytics regeneration. These and related views will be synchronized to reflect their new definitions in NoetixViews.
  • Do not modify: Subject areas or roles marked with Do not modify are the ones that exist in the repository but are not selected for regeneration. The generator will not attempt to regenerate them, but will preserve them in the repository.
  • Delete: Roles marked with Delete are the ones that exist in the repository, but have been unselected in the Choose dialog. They will be removed from the repository during regeneration as a result.
  • Mixed Actions: Subject areas marked with Mixed Actions have child roles that have multiple actions that the generator will execute. Expand the subject area to see the actions that will be taken on each individual role.

Full Regeneration

The generator supports Full regeneration strategy. The regeneration strategy is controlled by radio buttons in the Choose Roles and Choose Subject Areas dialogs for NoetixViews.

For the Full regeneration strategy, the Angles for Oracle Generator will regenerate all NoetixViews content selected in the Choose Roles dialog for the top-level-name specified in the Target Parameters tab of the generator. Selecting the check boxes corresponding to any NoetixViews roles or subject areas from the dialog will cause the corresponding presentation folder and logical display folder, and their contents to be removed if they are present. In addition, any physical tables or joins that do not correspond to selected items will be removed from the physical layer. For very large repositories, full regenerations may take several hours to complete.

For full regenerations, all objects that must appear in the repository under the chosen top level name must be explicitly selected:

The selection of subject areas and roles would:

  • Delete the existing FAG0_FIXED_ASSETS and POG0_PURCHASING roles from the repository.
  • Regenerate the existing APG0_PAYABLES, ARG0_RECEIVABLES and GLG0_LEDGER roles.
  • Create the previously ungenerated INVG0_INVENTORY role.

Prerequisites for Regenerating NoetixViews Metadata

The prerequisites for regenerating are the same as they are for generation, which are listed as follows:

  • Oracle Analytics Client Tools are installed
  • The Angles for Oracle Generator for Oracle Analytics is installed
  • NoetixViews is generated
  • The user credentials to access NoetixViews is available
  • Connectivity information about the database where NoetixViews is hosted is available
  • The Oracle Analytics utilities, nqUDMLGen.exe and nQUDMLExec.exe are available
  • If you plan to use an existing repository for regeneration, make sure that it is offline and not in use

Backing-up Repositories

Before you start the regeneration process, you must take a backup of the repository if you want to regenerate into the same repository or if you want to retain the current NoetixViews metadata. You can either perform a manual backup by physically copying the repository file, or by specifying in the Generator.config configuration file, the number of backups to be taken before regeneration. For information about modifying the Generator.config file, see Appendix B.

Independent of the backup setting in the Generator.config file, the Angles for Oracle Generator will back up an existing Oracle Analytics repository prior to importing new UDML files. If the import process fails for any reason, the Angles for Oracle Generator will restore the backup it took to preserve the integrity of the repository file.

By default, the Angles for Oracle Generator maintains three backup copies and takes a backup of the existing repository before modifying it.

Regenerating Repository Using Angles for Oracle Generator

The procedure for regenerating NoetixViews metadata using the Angles for Oracle Generator is similar to the initial generation. With the exception of passwords, the fields on all the pages of the Angles for Oracle Generator display the information that you provided the last time you used the generator. Type the passwords and edit the fields as needed for regeneration. For more information, see the "Generating UDML Files and Repository Using Angles for Oracle Generator" section in Generating Oracle Analytics Repository.

If you manage multiple instances of NoetixViews content with different top level names, you can load the values specified for a specific instance into the Angles for Oracle Generator.

To load the values specified for a specific instance

  1. Open the Angles for Oracle Generator tool. Navigate to the Script tab.
  2. Select Open Existing at the bottom left. Alternatively, Open Existing Script can be selected from the File menu. A warning message will appear, explaining that your existing entries in the interface will be overwritten. Select OK to proceed.

    If you do not want to lose the existing values specified in the interface, save them as a new generation arguments file before continuing.

  3. The Load Arguments File dialog will be displayed. Select the generation arguments file associated with the NoetixViews instance that you want to regenerate, and then select Open.
  4. The values from the generation arguments file will be loaded into the Angles for Oracle Generator interface, with the exception of the Oracle connection, warehouse connection and repository passwords.
  5. By default, the Angles for Oracle Generator will only import UDML files into the Oracle Analytics repository that were changed since the last regeneration to minimize the time needed for the import process. Select the Import Unchanged UDML Files box on the Execution Plan tab if you prefer the generator to import all of the UDML files it creates, including the ones that didn’t change since the last regeneration.
  6. Validate that the values are correct and enter the correct Oracle connection, warehouse connection, and repository passwords in the appropriate boxes. Then, proceed with regeneration.

    During the regeneration process, the Angles for Oracle Generator may refresh its metadata layer by executing a series of Oracle PL/SQL scripts. The Angles for Oracle Generator determines if changes were made to NoetixViews metadata, and updates its metadata layer automatically if a change is detected. In addition, the Angles for Oracle Generator will refresh its metadata layer if a customization was made through a generator hookscript.

Use a separate directory for each repository that NoetixViews is being generated into. This makes it easier to keep the different UDML and repository instances organized. In addition, saving the generation arguments file to this directory makes it easier to remember which schema or NoetixViews roles, or relationship sets were specified.

If NoetixViews organizational units, roles, business areas, or relationship sets are not selected in the Choose Roles dialog, the associated objects in the physical, business, and presentation layers may be deleted from the repository, particularly in the case of full regenerations. For more information, see Previously Generated Subject Areas and Roles. If custom objects were added to the Angles for Oracle Generator-generated physical schemas, business models, or presentation catalogs, they will be deleted as well, unless they were added as defined in the "Manually Adding Custom Objects to Generated Repositories" section in Customizing Generated Content.

The Remove underscores from generated presentation column names setting on the Target Parameters tab should not be modified from its original value. Doing so will break existing reports and dashboards in Oracle Analytics Presentation Services.

Intelligent UDML Import

The Angles for Oracle Generator utilizes the Oracle Analytics nQUDMLExec.exe utility to import NoetixViews content into the Oracle Analytics repository file. This process can take a significant amount of time, depending on the amount of content to import and the version of Oracle Analytics.

The Angles for Oracle Generator provides an Intelligent UDML Import feature to minimize the amount of time spent importing UDML files during regeneration. This feature automatically detects changes in each individual UDML file since the previous generation and will only import the files where one or more changes were detected, significantly decreasing the amount of time required for regeneration.

The nature of the underlying changes to NoetixViews that precipitate regeneration of the Oracle Analytics repository will impact which UDML files the Angles for Oracle Generator imports into the repository. For example, the Angles for Oracle Generator skips the import of the physical layer UDML files and will only import the associated business layer file when join type (i.e. INNER, OUTER) of a relationship between two views is modified. In practice, most changes to NoetixViews will cause the physical layer UDML files to be imported, along with the business and presentation layer files associated with the views or relationship sets that were modified. The other, unrelated business and presentation layer files will be skipped during the import process.

The Angles for Oracle Generator does not assign upgrade IDs to the UDML statements it creates. Oracle Analytics applies upgrade IDs to these objects as they are imported for the first time. The Angles for Oracle Generator then preserves these upgrade IDs in the UDML it creates during subsequent regenerations. Due to this behavior, Intelligent UDML Import will only start skipping unchanged UDML files after they have gone through one successful regeneration.

Regenerating Repository at Command Prompt

You can also regenerate the Oracle Analytics repository at a Command Prompt. This is an unattended generation that reduces downtime during peak hours. To regenerate at a Command Prompt, you first need to generate the script file by running the Angles for Oracle Generator tool, and saving the script as an .xml file. For more information, see the "Generating Repository at Command Prompt" section in Generating Oracle Analytics Repository.

Scheduling Unattended Regeneration

Using the Windows Scheduled Tasks tool, you can schedule a silent regeneration, which is an unattended regeneration of NoetixViews metadata into the Oracle Analytics repository.

To schedule a silent regeneration

  1. Verify that you have saved the .xml generation arguments file.
  2. Open the Windows Scheduled Tasks tool, and navigate to System Tools > Scheduled Tasks. The Scheduled Tasks window appears.
  3. Select Add Scheduled Task. The Schedule Task Wizard appears.
  4. Select Next. A list of programs appears.
  5. Select Browse, navigate to the the Angles for Oracle Generator directory, and select ngo.exe.
  6. Type a name for the task, set up the schedule as needed, and select Finish.
  7. After you save the details, in the Scheduled Tasks window, right-click the scheduled task you have created, and select Properties.
  8. In the Run box, add the necessary parameters. The syntax for the command is:

    “<hard disk drive>\<location path of ngo.exe> ngo” <generationargumentsfile>

    For example, in the Run box, type as follows:

  9. Select Apply. The regeneration runs at the scheduled time.

Published:

Regenerating NoetixViews metadata into Oracle Analytics repository

This chapter provides information about regeneration of NoetixViews metadata into the Oracle Analytics repository. The chapter also provides information about the prerequisites and procedures to regenerate.

When to Regenerate NoetixViews Metadata

You may need to regenerate NoetixViews metadata into the repository periodically. The following are the conditions in which you would typically perform a regeneration:

  • NoetixViews schema definition changes
  • NoetixViews are regenerated
  • Want to add a NoetixViews role to the Oracle Analytics repository
  • NoetixViews upgrade

Previously Generated Subject Areas and Roles

The Choose Roles and Choose Subject Areas dialogs provide visual cues to indicate which subject areas, roles and relationship sets were previously generated. These cues utilize circles with the following colors:

  • Gray: Gray circles denote subject areas or roles that do not exist in the repository.
  • Blue: Blue circles denote subject areas or roles that exist in the repository.
  • Green: Green circles denote subject areas or roles that exist in the repository and are synchronized with NoetixViews.
  • Red: Red circles denote subject areas or roles that exist in the repository and require regeneration to synchronize them with NoetixViews.

Red and green cues are only available for NoetixViews 6.5 and higher. The Angles for Oracle Generator is unable to read the state of objects in earlier versions of NoetixViews and cannot show items in red or green as a result.

In addition, the Choose dialog provides a Select based on Oracle BI repository checkbox to make it easier for administrators to regenerate all of the content that was previously generated into the repository. Selecting this option will overwrite the current subject area and role selection with the specific subject areas, and roles that exist in the repository shown at the bottom left corner of the dialog. This box is selected automatically when the view-level regeneration option is selected for NoetixViews 6.5 and above.

Content generated into an Oracle Analytics repository by a previous version of Angles for Oracle Generator must undergo a full regeneration before this capability can be used.

Actions Performed during Regeneration

The Choose dialog gives specific information on how subject areas and roles will be modified during regeneration, which is displayed in the Action column of the dialog:

  • Create: Subject areas or roles marked with Create are the ones that do not yet exist in the repository. They have been selected for generation, and will be added to the existing repository.
  • Do not create: Subject areas or roles marked with Do not create are the ones that don’t currently exist in the repository. They have not been selected, and will be ignored by the Angles for Oracle Generator.
  • Regenerate: Subject areas or roles marked with Regenerate are the ones that already exist in the repository. They have been selected, and will be synchronized to reflect their definitions in NoetixViews.
  • Regenerate changed objects: Subject areas or roles marked with Regenerate changed objects are the ones that exist in the repository, and contain one or more views that have changed in NoetixViews since the last Oracle Analytics regeneration. These and related views will be synchronized to reflect their new definitions in NoetixViews.
  • Do not modify: Subject areas or roles marked with Do not modify are the ones that exist in the repository but are not selected for regeneration. The generator will not attempt to regenerate them, but will preserve them in the repository.
  • Delete: Roles marked with Delete are the ones that exist in the repository, but have been unselected in the Choose dialog. They will be removed from the repository during regeneration as a result.
  • Mixed Actions: Subject areas marked with Mixed Actions have child roles that have multiple actions that the generator will execute. Expand the subject area to see the actions that will be taken on each individual role.

Full Regeneration

The generator supports Full regeneration strategy. The regeneration strategy is controlled by radio buttons in the Choose Roles and Choose Subject Areas dialogs for NoetixViews.

For the Full regeneration strategy, the Angles for Oracle Generator will regenerate all NoetixViews content selected in the Choose Roles dialog for the top-level-name specified in the Target Parameters tab of the generator. Selecting the check boxes corresponding to any NoetixViews roles or subject areas from the dialog will cause the corresponding presentation folder and logical display folder, and their contents to be removed if they are present. In addition, any physical tables or joins that do not correspond to selected items will be removed from the physical layer. For very large repositories, full regenerations may take several hours to complete.

For full regenerations, all objects that must appear in the repository under the chosen top level name must be explicitly selected:

The selection of subject areas and roles would:

  • Delete the existing FAG0_FIXED_ASSETS and POG0_PURCHASING roles from the repository.
  • Regenerate the existing APG0_PAYABLES, ARG0_RECEIVABLES and GLG0_LEDGER roles.
  • Create the previously ungenerated INVG0_INVENTORY role.

Prerequisites for Regenerating NoetixViews Metadata

The prerequisites for regenerating are the same as they are for generation, which are listed as follows:

  • Oracle Analytics Client Tools are installed
  • The Angles for Oracle Generator for Oracle Analytics is installed
  • NoetixViews is generated
  • The user credentials to access NoetixViews is available
  • Connectivity information about the database where NoetixViews is hosted is available
  • The Oracle Analytics utilities, nqUDMLGen.exe and nQUDMLExec.exe are available
  • If you plan to use an existing repository for regeneration, make sure that it is offline and not in use

Backing-up Repositories

Before you start the regeneration process, you must take a backup of the repository if you want to regenerate into the same repository or if you want to retain the current NoetixViews metadata. You can either perform a manual backup by physically copying the repository file, or by specifying in the Generator.config configuration file, the number of backups to be taken before regeneration. For information about modifying the Generator.config file, see Appendix B.

Independent of the backup setting in the Generator.config file, the Angles for Oracle Generator will back up an existing Oracle Analytics repository prior to importing new UDML files. If the import process fails for any reason, the Angles for Oracle Generator will restore the backup it took to preserve the integrity of the repository file.

By default, the Angles for Oracle Generator maintains three backup copies and takes a backup of the existing repository before modifying it.

Regenerating Repository Using Angles for Oracle Generator

The procedure for regenerating NoetixViews metadata using the Angles for Oracle Generator is similar to the initial generation. With the exception of passwords, the fields on all the pages of the Angles for Oracle Generator display the information that you provided the last time you used the generator. Type the passwords and edit the fields as needed for regeneration. For more information, see the "Generating UDML Files and Repository Using Angles for Oracle Generator" section in Generating Oracle Analytics Repository.

If you manage multiple instances of NoetixViews content with different top level names, you can load the values specified for a specific instance into the Angles for Oracle Generator.

To load the values specified for a specific instance

  1. Open the Angles for Oracle Generator tool. Navigate to the Script tab.
  2. Select Open Existing at the bottom left. Alternatively, Open Existing Script can be selected from the File menu. A warning message will appear, explaining that your existing entries in the interface will be overwritten. Select OK to proceed.

    If you do not want to lose the existing values specified in the interface, save them as a new generation arguments file before continuing.

  3. The Load Arguments File dialog will be displayed. Select the generation arguments file associated with the NoetixViews instance that you want to regenerate, and then select Open.
  4. The values from the generation arguments file will be loaded into the Angles for Oracle Generator interface, with the exception of the Oracle connection, warehouse connection and repository passwords.
  5. By default, the Angles for Oracle Generator will only import UDML files into the Oracle Analytics repository that were changed since the last regeneration to minimize the time needed for the import process. Select the Import Unchanged UDML Files box on the Execution Plan tab if you prefer the generator to import all of the UDML files it creates, including the ones that didn’t change since the last regeneration.
  6. Validate that the values are correct and enter the correct Oracle connection, warehouse connection, and repository passwords in the appropriate boxes. Then, proceed with regeneration.

    During the regeneration process, the Angles for Oracle Generator may refresh its metadata layer by executing a series of Oracle PL/SQL scripts. The Angles for Oracle Generator determines if changes were made to NoetixViews metadata, and updates its metadata layer automatically if a change is detected. In addition, the Angles for Oracle Generator will refresh its metadata layer if a customization was made through a generator hookscript.

Use a separate directory for each repository that NoetixViews is being generated into. This makes it easier to keep the different UDML and repository instances organized. In addition, saving the generation arguments file to this directory makes it easier to remember which schema or NoetixViews roles, or relationship sets were specified.

If NoetixViews organizational units, roles, business areas, or relationship sets are not selected in the Choose Roles dialog, the associated objects in the physical, business, and presentation layers may be deleted from the repository, particularly in the case of full regenerations. For more information, see Previously Generated Subject Areas and Roles. If custom objects were added to the Angles for Oracle Generator-generated physical schemas, business models, or presentation catalogs, they will be deleted as well, unless they were added as defined in the "Manually Adding Custom Objects to Generated Repositories" section in Customizing Generated Content.

The Remove underscores from generated presentation column names setting on the Target Parameters tab should not be modified from its original value. Doing so will break existing reports and dashboards in Oracle Analytics Presentation Services.

Intelligent UDML Import

The Angles for Oracle Generator utilizes the Oracle Analytics nQUDMLExec.exe utility to import NoetixViews content into the Oracle Analytics repository file. This process can take a significant amount of time, depending on the amount of content to import and the version of Oracle Analytics.

The Angles for Oracle Generator provides an Intelligent UDML Import feature to minimize the amount of time spent importing UDML files during regeneration. This feature automatically detects changes in each individual UDML file since the previous generation and will only import the files where one or more changes were detected, significantly decreasing the amount of time required for regeneration.

The nature of the underlying changes to NoetixViews that precipitate regeneration of the Oracle Analytics repository will impact which UDML files the Angles for Oracle Generator imports into the repository. For example, the Angles for Oracle Generator skips the import of the physical layer UDML files and will only import the associated business layer file when join type (i.e. INNER, OUTER) of a relationship between two views is modified. In practice, most changes to NoetixViews will cause the physical layer UDML files to be imported, along with the business and presentation layer files associated with the views or relationship sets that were modified. The other, unrelated business and presentation layer files will be skipped during the import process.

The Angles for Oracle Generator does not assign upgrade IDs to the UDML statements it creates. Oracle Analytics applies upgrade IDs to these objects as they are imported for the first time. The Angles for Oracle Generator then preserves these upgrade IDs in the UDML it creates during subsequent regenerations. Due to this behavior, Intelligent UDML Import will only start skipping unchanged UDML files after they have gone through one successful regeneration.

Regenerating Repository at Command Prompt

You can also regenerate the Oracle Analytics repository at a Command Prompt. This is an unattended generation that reduces downtime during peak hours. To regenerate at a Command Prompt, you first need to generate the script file by running the Angles for Oracle Generator tool, and saving the script as an .xml file. For more information, see the "Generating Repository at Command Prompt" section in Generating Oracle Analytics Repository.

Scheduling Unattended Regeneration

Using the Windows Scheduled Tasks tool, you can schedule a silent regeneration, which is an unattended regeneration of NoetixViews metadata into the Oracle Analytics repository.

To schedule a silent regeneration

  1. Verify that you have saved the .xml generation arguments file.
  2. Open the Windows Scheduled Tasks tool, and navigate to System Tools > Scheduled Tasks. The Scheduled Tasks window appears.
  3. Select Add Scheduled Task. The Schedule Task Wizard appears.
  4. Select Next. A list of programs appears.
  5. Select Browse, navigate to the the Angles for Oracle Generator directory, and select ngo.exe.
  6. Type a name for the task, set up the schedule as needed, and select Finish.
  7. After you save the details, in the Scheduled Tasks window, right-click the scheduled task you have created, and select Properties.
  8. In the Run box, add the necessary parameters. The syntax for the command is:

    “<hard disk drive>\<location path of ngo.exe> ngo” <generationargumentsfile>

    For example, in the Run box, type as follows:

  9. Select Apply. The regeneration runs at the scheduled time.

For an optimal Community experience, Please view on Desktop