Automatically populates Microsoft BI with NoetixViews and Noetix Analytics content
Noetix Generator enables Microsoft BI users to more effectively access Oracle E-Business Suite application data and create custom reports without IT assistance. By automating the process of building report models and cubes, Noetix accelerates the time to value for Microsoft BI deployment.
Using Noetix Generator, Microsoft BI Administrators benefit by automating the process necessary to build and maintain SSRS report models with NoetixViews and Noetix Analytics. As a result, Administrators are more quickly able to publish these models for use by report writers, saving significant time and expense.
For Microsoft BI Administrators
- Automatic Creation of SSAS Cubes
Administrators can automatically generate SSAS Cubes with the latest Noetix Analytics content. In addition, the appropriate measures and dimensions, including dimension hierarchies, are created. A cube is created for each the star schema of the data mart and each modified star schema of the operational data store in the Noetix Analytics data warehouse.
- Automatic Creation of SSRS Report Models
Administrators can automatically generate SSRS Report Models with the latest NoetixViews or Noetix Analytics content. Report Model entities are created for each dimension and fact table in the Analytics relationship set or every view in a NoetixViews role.
- Automatic Creation of Security Roles
Noetix Generator automatically creates roles to govern access to the cubes that are generated. Administrators can easily grant these roles to Microsoft BI users, giving them access to only the objects they are authorized to use.
For Microsoft BI Users
- Fully Documented Report Models and Cubes
Noetix Generator provides data definitions for all the data elements contained in the report models and cubes that it creates. Descriptive details are included for each measure, each dimension, and each field within those measures and dimensions.
- Pre-defined Joins and View Relationships
Noetix Generator automatically defines the joins between related tables and views, providing users with the ability to build reports spanning functional areas. When used with NoetixViews, these relationships connect individual Noetix views that can be combined into a single report. With Noetix Analytics, the joins are defined among the tables that make up the star schemas of the data mart and the modified star schemas of the operational data store.