You will create data views to operate as data sources for custom reports.
To create a data view:
Note: Refer to the Unifier Administration Guide for more information.
- Sign in to your Unifier environment, as company administrator, or administrator.
- Click the Company Workspace tab.
- In the left pane:
- Switch to Administration Mode.
- Select Data Structure Setup > Data Views.
- In the User-Defined Data Views window, click New.
- Enter the information needed for your data view. See Tips for more information.
- Click Apply and OK.
- Highlight the new view and select Status, Published.
Tips
The SQL definition will consist of the SQL query used to populate the report with specific data based on the desired output.
Note: If using the data view as a Main view in a Project level report, you must have a column named project_id. If using the data view in a Program level report, you must have a column named program_id.
For example, a Project level data view for a company registry "companyReg" can be like this below:
SELECT pu.PID as PROJECT_ID,
p.PROJECTNUMBER as PROJECTNUMBER,
c.COMPANYNAME as COMPANY_NAME,
c.SHORTNAME as COMPANY_SHORT_NAME,
c.DESCRIPTION as COMPANY_DESCRIPTION,
c.CONTACTNAME as COMPANY_CONTACT_NAME,
u.FULLNAME as USER_FULL_NAME,
u.USERID as USER_ID,
u.USERNAME as USER_NAME,
u.EMAIL as USER_EMAIL
FROM companyReg_SYS_USER_INFO_VIEW u,
companyReg_SYS_COMPANY_INFO c,
companyReg_SYS_PROJECT_INFO p,
companyReg_SYS_PROJECTUSER pu
WHERE c.COMPANYID = p.COMPANYID
AND p.PID = pu.PID
AND u.userid = pu.userid