End-User Reporting

Overview

Allows end users of the platform to construct their own grids, charts, and dashboards.

Key Features & Functionality

  • Quick setup of data catalog based on existing record types
  • Front end construction of the follow types: grid, pie charts, bar charts, column chart, line chart, KPI, and more!
  • Front end configuration of dashboards to combine multiple charts into a single page with page filters
  • Dashboards and reports can be individually shared with Users and Groups
  • End user documentation

Note: Appian provides self-service analytics capabilities where end users can explore enterprise data and build their own custom reports. Before downloading this utility, refer to Appian Documentation to see if you can use the available self-service analytics capabilities.

Anonymous
  • I can fix that issue, but the normal usage of application specific dashboards should use a wrapper of the EUR_Home rule as mentioned in "How to Configure Application Specific Dashboards" article in the documentation.  This will handle the persistence of the application in the reports and dashboards.

  • Thanks.
    Also tried to Configure Application Specific Dashboards, But having issue with this.

    Able to save the records with Application. But when I tried to create the new report application value is not persisted in the database table (eurreport). After further debugging realized that logic in the interface EUR_ReportBuilder & EUR_ReportBuilderSetup should be updated to save the selected application value in the respective rule input.
    pv!report.application

  • Thanks for the feedback, I will make these updates.

  • While updating from 2.8.0 to 3.0.0 found below issues with documentation and scripts

    • MariaDB upgrade Script [line 80 in the 2.8.0 to 3.0.0.sql]:
      ALTER TABLE `eurtagging` ADD CONSTRAINT `eurtagging_tag` FOREIGN KEY (`tagId`) REFERENCES `eurtag`(`tagId`) ON DELETE CASCADE ACTION ON UPDATE CASCADE;
      [Action is not needed in the script]

    • Application Properties file (2.8.0 to 3.0.0.properties):

                Properties file missing entry for newly created environment constants SHRD_APPIAN_API_KEY & SHRD_USE_CACHE

  • v3.0.0 Release Notes
    • Important Updates
    • Updated to Appian version 22.3
    • Updated application prefix from AH to EUR (make sure to check README for additional major upgrade steps)
    • Check for new version of End-User Reporting Charts plugin

    • New Features:
    • Shared Saved Filters for dashboards - created in the Edit Dashboard view
    • Formatting for measures on charts
    • Move dashboard sections up and down
    • Labels to dashboard sections
    • Relative widths for dashboard section columns

    • Bug Fixes:
    • Error with filtering by user
    • Fixed aggregation options for non int/decimal fields
    • Missing grid button on aggregation grid chart
    • User picker erroring with deactivated user
    • Month-to-date and year-to-date inaccurate

  • We did a full removal of EUR and are installing from scratch using the 2.8.0 /application/new properties and zip as well as the new "oracle" install sql. We cannot get this to verify even though we have manually verified the table in question:

    The data source schema does not match the type mappings: Schema-validation: wrong column type encountered in column [id] in table [`ahreportexport`]; found [number (Types#NUMERIC)], but expecting [int (Types#INTEGER)] (APNX-2-4056-000)

    and we have validated the following:

    create table ADHOC_DS."ahreportexport" (
           "id" INT not null,
            "processId" INT not null,
            "textField1" varchar2 (255 char),

  • I also looked under all file folders in the zip file downloaded. It is not there either. Please advise.

  • The CDT in question is AH_ReportExport.

  • It's mentioned in the documentation, but I can't find a link to it.

  • Where would be find oracle-package.zip?