GreyCloud Limited

04: Creating the template end user objects/views

If you have not already downloaded the template SQL scripts then download them now.

If you do not have the appropriate database privileges you may need the assistance of a database administrator (DBA) for your Maximo/Oracle instance to run the template scripts.

The sequence for ‘Creating the template end user objects/views’ is as follows:

  1. Create the EAM Analytics schema user (e.g. EAMGO)
    • This user should be created with the following privileges
    • CONNECT, CREATE PROCEDURE, CREATE TABLE, CREATE VIEW, EXECUTE ANY PROCEDURE
    • and will need some tablespace quota for creating ‘flattened’ hierarchy tables
  2. Grant ‘select’ on Maximo schema objects (video)
    • Using SQL*Plus, SQL Developer or a SQL tool like TOAD connect as the  ‘Maximo’ schema owner and run the following script
    • ‘GrantSelectMaximo_GO.sql’
  3. Create the EAM Analytics ‘template’ schema views (video)
    • Using SQL*Plus or your preferred tool connect as the  ‘EAM Analytics’ schema user and run the following scripts
    • CreateViewsMaximo_GOV.sql (Basic views)
    • CreateViewsMaximo_GOVD.sql (Display views)
    • CreateViewsMaximo_GOV1D.sql (UID Views)
    • EAMGO_FUNCTION.sql (EAM Analytics Functions/Logic)
    • CreateViewsMaximo_WORKORDER_GOV1C.sql