1
Download Enesys RS Data Extension Manual
Transcript
ABOUT ENESYS RS DATA EXTENSION ...................................................................................................................... 4 LICENSE AGREEMENT .............................................................................................................................................. 4 INSTALLATION AND UPGRADE .................................................................................................................................... 6 SYSTEM REQUIREMENT .......................................................................................................................................... 6 INSTALLATION .......................................................................................................................................................... 6 OVERVIEW ............................................................................................................................................................ 6 REPORT SERVER INSTALLATION ...................................................................................................................... 7 BUSINESS INTELLIGENCE DEVELOPMENT STUDIO INSTALLATION ...........................................................10 SAMPLE CONFIGURATION FILES ......................................................................................................................11 INSTALLING SCHEMA FILES ..............................................................................................................................12 UPGRADING FROM VERSION 1.X ..........................................................................................................................12 OVERVIEW ..........................................................................................................................................................12 UPGRADING ........................................................................................................................................................13 QUICK START ...............................................................................................................................................................15 CREATING A NEW REPORT PROJECT ....................................................................................................................15 ADDING A NEW REPORT ........................................................................................................................................16 CREATING A DATASET ...........................................................................................................................................16 CREATING A QUERY ................................................................................................................................................18 LAYOUT ....................................................................................................................................................................19 CONCLUSION ...........................................................................................................................................................19 USING ENESYS RS DATA EXTENSION ......................................................................................................................21 RETRIEVING DATA FROM A SHAREPOINT LIST ..................................................................................................21 SPECIFYING SHAREPOINT LIST .......................................................................................................................22 SPECIFYING LIST COLUMNS ..............................................................................................................................22 FILTERING LIST DATA .......................................................................................................................................22 USING COLUMN DISPLAY NAMES OR INTERNAL NAMES ..............................................................................23 USING REPORT PARAMETERS ..........................................................................................................................24 PENDING ITEMS .................................................................................................................................................26 EXPANDING RECURRING EVENTS ....................................................................................................................26 STRIPPING HTML TAGS ....................................................................................................................................29 USING RUNNING VALUES .................................................................................................................................31 RETRIEVING ITEMS AND FOLDERS IN A SPECIFIC FOLDER ..........................................................................33 RETRIEVING THE FIRST N ITEMS OF A LIST ...................................................................................................34 CUSTOM SEPARATOR MULTIPLE VALUES COLUMNS ....................................................................................35 EXPANDING MULTIPLE VALUES ......................................................................................................................36 APPLYING OPERATIONS TO LISTS ........................................................................................................................37 JOINING RESULT SETS .......................................................................................................................................38 MERGING RESULT SETS ....................................................................................................................................39 GETTING DISTINCT VALUES .............................................................................................................................40 GETTING A SUBSET OF A RESULT SET .............................................................................................................41 MERGING MULTIPLE LISTS ....................................................................................................................................42 MERGING LISTS USING A REFERENCE LIST ....................................................................................................42 ROLLING UP LISTS IN A SITE COLLECTION .....................................................................................................44 RETRIEVE LISTS INFORMATION, GROUPS AND PERMISSIONS ..........................................................................46 Enesys RS Data Extension Manual Sommaire 2
