NUMSys 3.0 – Native User Management System for Shared Services


The latest greatest NUMSys is here.

I’m really excited about this version, it took me a while to think about all the reports and of course to implement it.

This is the release which saw a bunch of updates.

You got new menus now 🙂

It tries to mimic most of the EXCEL functionality, with Copy and Paste you can now get data in and out of EXCEL (a big thanks to Mike Nader for this suggestion)

All the tables now allows you to perform multiple selections.

As you can see there is a Reports tab in NUMSys.

You can create a bunch of reports for documentation purpose.

  • User/Group Provisioning Report
  • Application Ownership Report
  • User/Group Comparison Report
  • User/Group Inheritance Report
  • User/Group Report

Provisioning Report

Provisioning report can generate an inheritance report along with user/group role.

It can plot upto 5 levels.

Application Ownership Report

Using this you can see which user is the owner of the application. Extremely useful in case of Essbase and Planning applications.

Comparison Report

Using this you can compare the users in app1 vs app2

This will generate two reports (app1 vs app2 and app2 vs app1) with the users in the application and the difference.

Inheritance Report

This is similar to provisioning report, this will plot the user/group’s ancestral tree to 5 levels.

User/Group Report

This is the old documentation report which can report on all users/groups in all directories.

You can look at the help file for more details and I almost forgot the download link 🙂

You can download NUMSys 3.0 from here.
Download Now

Advertisements

About Celvin Kattookaran

I’m an EPM Consultant, my primary focus is on Hyperion Planning and Essbase. Some of you from Hyperion Support team might recognize me or have seen my support articles, I was with the WebAnalysis Support Team. I'm an Independent Consultant with “Intekgrate Corporation” based out of Aurora office. I’m from God’s Own Country (Kerala, India), lived in all southern states of India, Istanbul and Johannesburg (and of course United States). I’m core gamer :) and an avid reader. I was awarded Oracle ACE Director for my contributions towards EPM community.


Leave a Reply

0 thoughts on “NUMSys 3.0 – Native User Management System for Shared Services

  • Anonymous

    It doesn't seem to work. I update the cmd file with the path to java_home and epm_oracle_home. Select login, but it doesn't connect to shared services.

    Error is:

    SEVERE: An error occured when checking the status of the registry connection and reseting it.
    com.hyperion.hit.registry.exceptions.RegistryException: No database properties could be read
    I can connect to shared services just fine. Any suggestions? This is being run on the foundation server.

  • Celvin Kattookaran

    There are three variables that you should be updating

    SET JAVA_HOME=
    SET EPM_ORACLE_HOME=

    REM # — This is Oracle instance where we can find reg.properties
    REM # For 11.1.2.2 E:/Oracle/Middleware/user_projects/epmsystem1/config/foundation/11.1.2.0/reg.properties
    REM # For 11.1.2.3 E:/Oracle/Middleware/user_projects/config/foundation/11.1.2.0/reg.properties
    REM # For 11.1.2.2 SET ORACLE_INSTANCE=E:/Oracle/Middleware/user_projects/epmsystem1
    REM # For 11.1.2.3 SET ORACLE_INSTANCE=E:/Oracle/Middleware/user_projects

    SET ORACLE_INSTANCE=

    So do you've all of them set, the error message is telling me that you've not set the ORACLE_INSTANCE or it is set to a wrong path

  • Anonymous

    I was able to connect, but when I pull users from HSS I get the following error: Any suggestions please?

    May 8, 2015 12:56:13 PM com.hyperion.css.validate.Validator validatePrincipal
    SEVERE: Failed to get users. Principal is null. Provide valid user principal to access.
    EPMCSS-00728: Failed to get users. Principal is null. Provide valid user principal to access.
    at com.hyperion.css.validate.Validator.validatePrincipal(Validator.java:140)

  • Anonymous

    Celvin,

    For some reason these are the error messages i am receiving when logging into the tool. I have set the variables as needed.

    un 3, 2015 1:03:34 PM Initializing CSS …
    Jun 3, 2015 1:03:35 PM com.hyperion.hit.registry.RegistryUtils readDatabaseProperties
    INFO: The file reg.properties could not be found.
    Jun 3, 2015 1:03:35 PM com.hyperion.hit.registry.RegistryUtils readDatabaseProperties
    INFO: Security Key could not be read from reg.properties file.
    Jun 3, 2015 1:03:35 PM com.hyperion.hit.registry.SecurityUtils
    INFO: Initializing the credential store for Registry.
    Jun 3, 2015 1:03:35 PM com.hyperion.hit.registry.SecurityUtils
    INFO: The JPS Config File is null.
    Jun 3, 2015 1:03:35 PM com.hyperion.hit.registry.Registry getConnection
    SEVERE: An error occured when checking the status of the registry connection and reseting it.
    com.hyperion.hit.registry.exceptions.RegistryException: No database properties could be read

  • Anonymous

    Yes i did update the Oracle_Instance variable in the bat file . I must mention that the values of the Path variables are referring to a mapped drive, is that causing some trouble?