Complex Queries in Business Objects

68 pages
229 views

Please download to get full document.

View again

of 68
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Share
Description
Complex Queries in BusinessObjects 2 Complex Queries in BusinessObjects Appropriate Use And Security Of Confidential And Sensitive Information Due to the integrated nature of the various Human Resources, Finance and Student modules in Banner and the reporting information in the Enterprise Data Warehouse (EDW), you may have access to information beyond what you need to perform your assigned duties. Your access to Banner and the EDW has been granted based on business need, and it is your respo
Tags
Transcript
  Complex Queries inBusinessObjects    2 Complex Queries in BusinessObjects Appropriate Use And Security Of Confidential AndSensitive Information Due to the integrated nature of the various Human Resources, Finance and Studentmodules in Banner and the reporting information in the Enterprise Data Warehouse(EDW), you may have access to information beyond what you need to perform yourassigned duties. Your access to Banner and the EDW has been granted based onbusiness need, and it is your responsibility to ensure the information you access is usedappropriately.Here are some reminders of good data stewardship to help you carry out yourresponsibility: ã   Do not share your passwords or store them in an unsecured manner. Do not leaveyour workstation unattended while logged on to administrative informationsystems. You are responsible for any activity that occurs using your logon id. ã   Do not share confidential and sensitive information with anyone, includingcolleagues, unless there is a business reason. ã   Retrieve printed reports quickly, and do not leave the reports lying around in plainview. ã   Secure reports containing confidential and sensitive information (e.g., FERPA, EEOor HIPAA protected data). ã   When disposing of reports containing confidential or sensitive information, shredthe documents in a timely manner.Your responsibilities regarding the protection and security of administrativeinformation are outlined in the University of Illinois Information Security Policy postedat http://www.obfs.uillinois.edu/manual/central_p/sec19-5.htm. Any violation couldsubject you to disciplinary action, which could include dismissal or, in those caseswhere laws have been broken, legal action. You should have signed a compliance formthat indicates you have read, understand and agree to comply with the University'sInformation Security Policy for Administrative Information. If you have not alreadysigned the compliance form, please see your Unit Security Contact, who is responsiblefor maintaining these forms. File:   e:\trainingdevelopment\businessobjects\businessobjects6 - complex queries\complex queries inbusinessobjects v3.doc   Last Printed:   3/14/2006 8:47 AM      Complex Queries in BusinessObjects 3 Complex Queries in BusinessObjectsTable of Contents Appropriate Use And Security Of Confidential And Sensitive Information............................................2   About this Course........................................................................................................................................5   Objective............................................................................................................................................5   Instructor Led Course........................................................................................................................5   Training Data.....................................................................................................................................5   Practice..............................................................................................................................................5   Files...................................................................................................................................................5   Demos...............................................................................................................................................5   Chapter 1.....................................................................................................................................................7   Formulas and Variables.......................................................................................................................7   Formulas............................................................................................................................................7   Resetting the RunningSum...............................................................................................................10   Variables.............................................................................................................................................10   Creating a Variable...........................................................................................................................10   Exercise 1 – Formulas and Variables...............................................................................................13   Chapter 2....................................................................................................................................................15   Grouping Values.................................................................................................................................15   Using the Group Option....................................................................................................................15   Using the Groups..............................................................................................................................18   Exercise 2 – Grouping Values..........................................................................................................19   Chapter 3....................................................................................................................................................21   Grouping Measure Objects.................................................................................................................21   Sales Grouping.................................................................................................................................21   Exercise 3 – Grouping Measure Objects..........................................................................................24   Chapter 4....................................................................................................................................................25   Calculation Contexts...........................................................................................................................25   Input and Output Contexts................................................................................................................25   Calculation Context Operators..........................................................................................................25   Calculation Context Keywords..........................................................................................................26   Calculation Context Example............................................................................................................26   Viewing Calculation Contexts...........................................................................................................27   Changing the Calculation Context.....................................................................................................28   Exercise 4 – Calculation Contexts....................................................................................................29   Chapter 5....................................................................................................................................................31   Subqueries..........................................................................................................................................31   Multiple Data Providers.....................................................................................................................32   Verifying the Results.........................................................................................................................33   Managing Data Providers.................................................................................................................35   Renaming Data Providers.................................................................................................................35   Purging vs Deleting a Data Provider.................................................................................................36   Exercise 5 – Subqueries...................................................................................................................38   Chapter 6....................................................................................................................................................39   Using Personal Data Files...................................................................................................................39   File Types Available..........................................................................................................................39   Options with .XLS Files.....................................................................................................................39   Creating a Report from an XLS File..................................................................................................39   Options with Text Files......................................................................................................................41   Create a table from a .CSV personal data file...................................................................................41   Create a Second Data Provider........................................................................................................43   Exercise 6 – Using Personal Data Files............................................................................................46   Chapter 7....................................................................................................................................................47   Combining Data from Different Data Providers...................................................................................47   Linking Data Providers......................................................................................................................47   Incompatible Objects........................................................................................................................48   Combining Data in the Table............................................................................................................49   Exercise 7 – Combining Data from Different Sources.......................................................................51   Appendix A –Review Answers....................................................................................................................53      4 Complex Queries in BusinessObjects Appendix B.................................................................................................................................................55   User Objects.......................................................................................................................................55   User Objects.....................................................................................................................................55   Creating a User Object.....................................................................................................................56   Using a User Object..........................................................................................................................59   Removing a User Object...................................................................................................................60   Appendix C – Combined Queries...............................................................................................................61   Combined Queries............................................................................................................................61   Restrictions.......................................................................................................................................61   Building a Combined Query..............................................................................................................61   Appendix D –Using an XML Data Provider................................................................................................63   Appendix E – ASCII character codes.........................................................................................................67  
Related Search
We Need Your Support
Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks