AppWorx, Dollar Universe and Sysload Community

 View Only
Expand all | Collapse all

Applications Manager v8.x Report to Show SubVar Usage in Prompts for RA Banner Jobs

  • 1.  Applications Manager v8.x Report to Show SubVar Usage in Prompts for RA Banner Jobs

    Posted May 28, 2013 12:46 PM
      |   view attached

    Issue:  The usage feature in Applications Manager does not work with subvars used in RA Banner job prompts.  Therefore, you can generate a report in Applications Manager that can show you subvar usage.  This should be tried first within a test system.

    1. Copy the BANNER_SUBVAR_USAGE.exp to the $AW_HOME/import/ directory.

    2. Copy the create_banner_vies.sql to the $AW_HOME/sql/ dirctory.

    3. Import the objects from the BANNER_SUBVAR_USAGE.exp file.

    4. After the objects have been imported run the BANNER_CREATE_VIEWS job. This will fix the views if they exist.

    5. Once the views are fixed you can run the BANNER_SUBVAR_USAGE report.  This may take a while to run.  An example of the produced report is shown below.

    937022e2ed3d3881708c012d1509e4.png

    fde25def2d7dbb05d3df7287554bb2.png

    Attachment(s)

    zip
    BANNER_SUBVAR_USAGE.zip   9 KB 1 version


  • 2.  Applications Manager v8.x Report to Show SubVar Usage in Prompts for RA Banner Jobs

    Posted Nov 04, 2013 03:36 PM

    Can you tag this as 'Applications Manager' and 'Banner'?

    Thanks!