1 / 16

Advanced Furniture SQL Reporting: Studio Manager Tool

Advanced Furniture SQL Reporting: Studio Manager Tool. Welcome. Connect Conference 2013. This is an exciting opportunity for everyone involved. The benefits go beyond just training and education—collaborate with your peers and inspire others around you.

vinson
Download Presentation

Advanced Furniture SQL Reporting: Studio Manager Tool

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Advanced Furniture SQL Reporting: Studio Manager Tool

  2. Welcome Connect Conference 2013 This is an exciting opportunity for everyone involved. The benefits go beyond just training and education—collaborate with your peers and inspire others around you. educate • collaborate • inspire

  3. Advanced Furniture SQL Reporting In this session, we will explore designing reports through the C1 reporting tool, reviewing standard compiled SQL tables utilizing MS Visual SQL Studio, and understanding how and where the data is located in the standard SQL table views.

  4. Advanced Furniture SQL Reporting EBS Import Control Panel • Validate data • Full import vs. delta import • Understand how to schedule imports • Number of months in history • 4.0 GB vs. 10.0 GB (8.26 vs. 10.0) • Exceptions (data import) • SQL status: Running

  5. Advanced Furniture SQL Reporting EBS Import Control Panel

  6. Advanced Furniture SQL Reporting EBS SQL Panel

  7. Advanced Furniture SQL Reporting SQL Metrics • Where to find the name of SQL tables • Understand the columns in a table • What is a view? • Compact databases

  8. Advanced Furniture SQL Reporting SQL Metrics

  9. Advanced Furniture SQL Reporting C1 Reporting • C1 reporting requires authorization • Understand a simple SQL report • How to drag and drop fields • How to change sorts and groups • What is a simple SQL statement • Select * from (ViewTable) For additional training on SQL statement writing, contact your local college or university.

  10. Advanced Furniture SQL Reporting SQL Source Line for C1 Reporting • Provider=SQLOLEDB.1;Password=db_user;Persist Security Info=True;User ID=netclient;Intitial Catalog=Ensite;Data Source= (LOCAL)\eci2 This is the universal source line for C1 to allow any report to run on any ECi DDMS machine.

  11. Advanced Furniture SQL Reporting C1 Connection String

  12. Advanced Furniture SQL Reporting Microsoft SQL Server Management Studio • Free software available from Microsoft • Understand how to: • Log in and select the correct database • Drill down (Tables and Views) • View columns • Execute query to view data • Export the table to Excel • Create a query

  13. Advanced Furniture SQL Reporting Don’t forget to turn in your session survey for a chance to win a $250 gift certificate. Surveys can be turned in at the Conference Registration in the Trinity Foyer or in the Lab located in the Pegasus Ballroom (both located on the lobby level)

  14. Advanced Furniture SQL Reporting Don’t forget to turn in your session survey for a chance to win a $250 gift certificate Surveys can be turned in at the Conference Registration in the Trinity Foyer or in the Lab located in the Pegasus Ballroom (both located on the lobby level)

  15. Advanced Furniture SQL Reporting

  16. Customer Service & Support Contact Information Training • (800) 959-3367 option 5 • professional.services@ecisolutions.com • Virtual classes offered monthly • One-on-One training via virtual classroom • Onsite training Support • (800) 366-4778 • Monday - Friday • 7AM to 7PM CST • 24/7 Support Services are available on a billable basis outside of regular business hours, 7 days a week

More Related