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.

Parents

James R Woodard over 2 years ago

Oracle does not allow the syntax in bold/italic below:

CREATE TABLE IF NOT EXISTS `ahcollaboration` (
`collaborationid` int(11) NOT NULL AUTO_INCREMENT,
`reportid` int(11) DEFAULT NULL,
`dashboardid` int(11) DEFAULT NULL,
`role` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`user` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL,
`groupid` int(11) DEFAULT NULL,
PRIMARY KEY (`collaborationid`),
KEY `reportId` (`reportid`),
KEY `dashboardId` (`dashboardid`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_unicode_ci;

So I am guessing we need to post the question, what is the purpose of that section? Is it to create a composite PK, which I assume is the case.

The problem with that is when they try to add a foreign key on the dashboardid and reportid columns, it fails, because it doesn't see the PK fields as individual, but as a group. The error message I am getting when I try to add the foreign key is: ORA-02270: no matching unique or primary key for this column-list.
- Cancel
- Up +2 Down
- Reply
- More
- Cancel
Michael Chirlin over 2 years ago in reply to James R Woodard

The sql statements included in the release are specifically for mariadb. One thing you could try is to publish the datastore and have it create the tables for you.

In terms of what it does, it is for creating the primary key for the table and setting up foreign keys for indexing. It is not a composite key.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel

Comment

Michael Chirlin over 2 years ago in reply to James R Woodard

The sql statements included in the release are specifically for mariadb. One thing you could try is to publish the datastore and have it create the tables for you.

In terms of what it does, it is for creating the primary key for the table and setting up foreign keys for indexing. It is not a composite key.
- Cancel
- Up 0 Down
- Reply
- More
- Cancel

Children

No Data