Implementation Tasks
1. Create user ‘polostats’ on POLOTEST.polopoly
a) Grant roles
APPLICATION
POLOPOLY_BROWSER
b) Grant SYSTEM PRIVILEGES with no admin option
QUERY REWRITE
GLOBAL QUERY REWRITE
CREATE SESSION
CREATE MATERIALIZED VIEW
CREATE TABLE
c) Grant SELECT privilege on all POLOTEST.polopoly tables:
ACL
ACLDATA
ACLOWNER
ATTRIBUTEID
COMPONENT
CONSUMERS
CONTENTFILE
CONTENTLOCKS
CONTENTREF
DESTINATIONS
EVENTINFO
EVENTINFOQUEUE
EXTERNALIDS
GROUPDATA
GROUPMEMBER
GROUPOWNER
IDCOUNTERS
INSTALLATIONINFO
JMS_MESSAGES
JMS_TRANSACTIONS
MAJORINFO
MESSAGE_HANDLERS
MESSAGES
MINORINFO
REGISTEREDUSERS
SEEDS
SESSIONINFO
SYSTEM_DATA
TAGID
TAGINFO
USERS
VERSIONINFO
3. Run scripts in the following order for objectives 1 and 3:
K:\ISAPPS\dsg\Projects\UWP005\SQL Scripts TEST\01_isg_format.sql
K:\ISAPPS\dsg\Projects\ UWP005\SQL Scripts TEST\02_isg_published.sql
K:\ISAPPS\dsg\Projects\ UWP005\SQL Scripts TEST\03_isg_component.sql
K:\ISAPPS\dsg\Projects\ UWP005\SQL Scripts TEST\04_isg_relationship.sql
K:\ISAPPS\dsg\Projects\ UWP005\SQL Scripts TEST\05_isg_polopoly_tree.sql
K:\ISAPPS\dsg\Projects\ UWP005\SQL Scripts TEST\06_isg_orphaned_tree.sql
K:\ISAPPS\dsg\Projects\ UWP005\SQL Scripts TEST\07_isg_url.sql
K:\ISAPPS\dsg\Projects\ UWP005\SQL Scripts TEST\08_isg_media.sql
K:\ISAPPS\dsg\Projects\ UWP005\SQL Scripts TEST\09_isg_content_references.sql
4. Run scripts in the following order for objectives 2 and 4:
K:\ISAPPS\dsg\Projects\UWP005\SQL Scripts TEST\10_isg_group_user.sql
K:\ISAPPS\dsg\Projects\UWP005\SQL Scripts TEST\11_isg_group_workflow.sql
K:\ISAPPS\dsg\Projects\UWP005\SQL Scripts TEST\12_isg_group_workflow_section.sql
K:\ISAPPS\dsg\Projects\UWP005\SQL Scripts TEST\13_isg_hourly_activity.sql
K:\ISAPPS\dsg\Projects\UWP005\SQL Scripts TEST\14_isg_daily_activity.sql
K:\ISAPPS\dsg\Projects\UWP005\SQL Scripts TEST\15_isg_hourly_logins.sql
K:\ISAPPS\dsg\Projects\UWP005\SQL Scripts TEST\16_isg_daily_logins.sql
K:\ISAPPS\dsg\Projects\UWP005\SQL Scripts TEST\17_isg_daily_user_logins.sql
K:\ISAPPS\dsg\Projects\UWP005\SQL Scripts TEST\18_isg_daily_activity_view.sql
K:\ISAPPS\dsg\Projects\UWP005\SQL Scripts TEST\19_isg_daily_logins_view.sql
K:\ISAPPS\dsg\Projects\UWP005\SQL Scripts TEST\20_isg_hourly_activity_view.sql
K:\ISAPPS\dsg\Projects\UWP005\SQL Scripts TEST\21_isg_hourly_logins_view.sql
Business Objects
TEST BO Universe
Session: @Borep:test.is.ed.ac.uk:6400 (mistst01 – Enterprise)
Connection: polotest_bopolostats
Universe location in repository: Universes\ISG\Polopoly\polopoly_universe
TEST BO Reports
Location of reports: Folders\Public Folders\ISG\Polopoly
Each report is prefixed with a number that relates to the UWP005 project objective.
The following reports to be moved to LIVE:
Objective 1 – content structure
01. Breadcrumb trail (URL)
01. Full Polopoly Tree
01. Polopoly Orphaned Component Tree
Objective 2 – groups, users and workflows
02. Group – User
02. Group – Workflow – Permission
02. Group – Workflow – Section
Objective 3 – content references
03. Content References
Objective 4 – system/user activity
04. Daily Activity
04. Daily Logins
04. Hourly Activity
04. Hourly Logins