101880 – taking bi publisher to the next level at wells fargo
DESCRIPTION
101880 – Taking BI Publisher to the Next Level at Wells Fargo. Tips and Techniques for Speed, Sophistication and Manageability. Introductions. Jamie Shepherd Technology Manager Located in Minneapolis 29 years IT, 3 years PeopleSoft Managing Payroll, Core HR, International Sam Pred - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: 101880 – Taking BI Publisher to the Next Level at Wells Fargo](https://reader035.vdocuments.us/reader035/viewer/2022062302/568168a7550346895ddf44a6/html5/thumbnails/1.jpg)
QuestDirect.org
101880 – Taking BI Publisher to the Next Level at Wells Fargo
Tips and Techniques for Speed, Sophistication and Manageability
![Page 2: 101880 – Taking BI Publisher to the Next Level at Wells Fargo](https://reader035.vdocuments.us/reader035/viewer/2022062302/568168a7550346895ddf44a6/html5/thumbnails/2.jpg)
QuestDirect.org
IntroductionsJamie ShepherdTechnology ManagerLocated in Minneapolis29 years IT, 3 years PeopleSoft Managing Payroll, Core HR, International
Sam PredApplications System EngineerLocated in MinneapolisNot as old as Jamie, but years of PeopleSoft Technical ExperienceCurrently supporting Benefits and 9.2 upgrade
![Page 3: 101880 – Taking BI Publisher to the Next Level at Wells Fargo](https://reader035.vdocuments.us/reader035/viewer/2022062302/568168a7550346895ddf44a6/html5/thumbnails/3.jpg)
QuestDirect.org
Why Are You Here?• Get information around how Wells has uses BI
publisher for team member communications• Get tips and techniques used for creating
sophisticated publications
![Page 4: 101880 – Taking BI Publisher to the Next Level at Wells Fargo](https://reader035.vdocuments.us/reader035/viewer/2022062302/568168a7550346895ddf44a6/html5/thumbnails/4.jpg)
QuestDirect.org
Wells Fargo• Wells Fargo & Company (NYSE: WFC) Wells Fargo & Company
is a diversified financial services company providing banking, insurance, investments, mortgage, and consumer and commercial finance through more than 9,000 stores and more than 12,000 ATMs and the Internet (wellsfargo.com) across North America and internationally serving over 70 million customers.
• 282,000+ team members in more than 35 countries across our 80+ businesses
• Current US population consists of • 265,000 full-time employees• 16,000 part-time employees• 260,000 benefits-eligible employees
![Page 5: 101880 – Taking BI Publisher to the Next Level at Wells Fargo](https://reader035.vdocuments.us/reader035/viewer/2022062302/568168a7550346895ddf44a6/html5/thumbnails/5.jpg)
QuestDirect.org
Wells Fargo Facts• 4th in assets and #1 in market value of stock among
U.S. peers• #1 Mortgage servicer• #1 Small Business Lender• #2 provider of private student loans• Top 20 Biggest Public Companies in the World• Top 10 Most Valuable Brands in the World
![Page 6: 101880 – Taking BI Publisher to the Next Level at Wells Fargo](https://reader035.vdocuments.us/reader035/viewer/2022062302/568168a7550346895ddf44a6/html5/thumbnails/6.jpg)
QuestDirect.org
PeopleSoft at Wells Fargo• Operate on a DB2 platform• Initially installed PeopleSoft version 2.0 in 1993 (HR/Payroll/Benefits)• Multiple upgrades to 4.5, 6.0, 7.5, and 8.3 throughout the years• Installed home grown version of Manager Self-Service (Staff Management) in 2003• 3rd party Time & Attendance System (Time Tracker)• Installed Benefits Administration in 2002• Installed Automated Terminations Processing in 2006• Upgraded to PS version 8.9 in 2007
Future Plans• Upgrade to version 9.2 projected go live May 2014
![Page 7: 101880 – Taking BI Publisher to the Next Level at Wells Fargo](https://reader035.vdocuments.us/reader035/viewer/2022062302/568168a7550346895ddf44a6/html5/thumbnails/7.jpg)
QuestDirect.org
Wells PS Modules• Core HR• Payroll• Ben Admin• Talent Acquisition (moving to vendor solution in 2014)• Employee Self Service• Staff Management (Custom add-on)• HR Helpdesk• Several non-HCM implementations
• Projects, CRM, GL, more
![Page 8: 101880 – Taking BI Publisher to the Next Level at Wells Fargo](https://reader035.vdocuments.us/reader035/viewer/2022062302/568168a7550346895ddf44a6/html5/thumbnails/8.jpg)
QuestDirect.org
Our Opportunity– As part of Annual Benefits Enrollment, historically distributed
printed personalized enrollment guides to all eligible team members
– Worked with an external vendor to produce guide, causing issues:
• Personal data in guide was stale • Cost was prohibitive• No electronic versions available • No tracking of use, etc. • All paper guides not very green
![Page 9: 101880 – Taking BI Publisher to the Next Level at Wells Fargo](https://reader035.vdocuments.us/reader035/viewer/2022062302/568168a7550346895ddf44a6/html5/thumbnails/9.jpg)
QuestDirect.org
Our Desire
• Bring the process in-house by leveraging our 5+ years of experience with the software:
• Discontinue use of outside vendor• Distribute electronically• Use fresh data• Enable use tracking• Cut costs dramatically• Be environmentally sensitive
![Page 10: 101880 – Taking BI Publisher to the Next Level at Wells Fargo](https://reader035.vdocuments.us/reader035/viewer/2022062302/568168a7550346895ddf44a6/html5/thumbnails/10.jpg)
QuestDirect.org
Complications
• Legal Requirements • Real-time or batch?• Service center considerations
![Page 11: 101880 – Taking BI Publisher to the Next Level at Wells Fargo](https://reader035.vdocuments.us/reader035/viewer/2022062302/568168a7550346895ddf44a6/html5/thumbnails/11.jpg)
QuestDirect.org
Solutions
– Legal Requirements• Created a log to capture when a TM accessed the
guide• Created and stored effective-dated versions of the
XSL templates • Merged effective-dated PS row data with the
appropriate template
![Page 12: 101880 – Taking BI Publisher to the Next Level at Wells Fargo](https://reader035.vdocuments.us/reader035/viewer/2022062302/568168a7550346895ddf44a6/html5/thumbnails/12.jpg)
QuestDirect.org
Solutions- Real-Time or Batch?
- Identified that real-time was not an option with load testing (found solution just before implementation)
- Created online page for team members- Included run control to allow us to move to real-
time by flipping a switch
![Page 13: 101880 – Taking BI Publisher to the Next Level at Wells Fargo](https://reader035.vdocuments.us/reader035/viewer/2022062302/568168a7550346895ddf44a6/html5/thumbnails/13.jpg)
QuestDirect.org
Solutions- Service Center Considerations
- Customized screen for HRSC- Print effective-dated documents on demand- See historical data as needed for research
![Page 14: 101880 – Taking BI Publisher to the Next Level at Wells Fargo](https://reader035.vdocuments.us/reader035/viewer/2022062302/568168a7550346895ddf44a6/html5/thumbnails/14.jpg)
QuestDirect.org
Results– Produced 260,000 32-page pdf’s over a long
weekend and stored them on a server– Enabled the real-time option without system impact
after the initial rush– Tracked usage by team members– Produced very significant financial savings– Eliminated millions of pages of printed media
![Page 15: 101880 – Taking BI Publisher to the Next Level at Wells Fargo](https://reader035.vdocuments.us/reader035/viewer/2022062302/568168a7550346895ddf44a6/html5/thumbnails/15.jpg)
QuestDirect.org
Sample
2012 Annual Benefits EnrollmentLAJUANA VANDEHEY, this is your personalized enrollment guide
![Page 16: 101880 – Taking BI Publisher to the Next Level at Wells Fargo](https://reader035.vdocuments.us/reader035/viewer/2022062302/568168a7550346895ddf44a6/html5/thumbnails/16.jpg)
QuestDirect.org
Since then…
– Eliminated the last of our W2 forms requirements
– Re-engineered benefits confirmation statements
![Page 17: 101880 – Taking BI Publisher to the Next Level at Wells Fargo](https://reader035.vdocuments.us/reader035/viewer/2022062302/568168a7550346895ddf44a6/html5/thumbnails/17.jpg)
QuestDirect.org
Technical Considerations
– Sam Pred, Wells Fargo PeopleSoft developer, Benefits team.
![Page 18: 101880 – Taking BI Publisher to the Next Level at Wells Fargo](https://reader035.vdocuments.us/reader035/viewer/2022062302/568168a7550346895ddf44a6/html5/thumbnails/18.jpg)
QuestDirect.org
Technical considerationsDocument Strategy
• Main Document.– Graphics– Static Text
• Variable Text Document– Conditional Text– Stored in SubTemplates
![Page 19: 101880 – Taking BI Publisher to the Next Level at Wells Fargo](https://reader035.vdocuments.us/reader035/viewer/2022062302/568168a7550346895ddf44a6/html5/thumbnails/19.jpg)
QuestDirect.org
Technical considerationsImporting Sub Templates
![Page 20: 101880 – Taking BI Publisher to the Next Level at Wells Fargo](https://reader035.vdocuments.us/reader035/viewer/2022062302/568168a7550346895ddf44a6/html5/thumbnails/20.jpg)
QuestDirect.org
Technical considerationsImporting Sub Templates
![Page 21: 101880 – Taking BI Publisher to the Next Level at Wells Fargo](https://reader035.vdocuments.us/reader035/viewer/2022062302/568168a7550346895ddf44a6/html5/thumbnails/21.jpg)
QuestDirect.org
Technical considerationsDefining Sub Templates
![Page 22: 101880 – Taking BI Publisher to the Next Level at Wells Fargo](https://reader035.vdocuments.us/reader035/viewer/2022062302/568168a7550346895ddf44a6/html5/thumbnails/22.jpg)
QuestDirect.org
Technical considerationsTemplate Syntax
<?template:OTL_E?>You may decrease….<?end template?><?template:OTL_W?>You may enroll….<?end template?>
![Page 23: 101880 – Taking BI Publisher to the Next Level at Wells Fargo](https://reader035.vdocuments.us/reader035/viewer/2022062302/568168a7550346895ddf44a6/html5/thumbnails/23.jpg)
QuestDirect.org
Technical considerationsLet the Data Decide
![Page 24: 101880 – Taking BI Publisher to the Next Level at Wells Fargo](https://reader035.vdocuments.us/reader035/viewer/2022062302/568168a7550346895ddf44a6/html5/thumbnails/24.jpg)
QuestDirect.org
Technical considerationsImporting Sub Templates
• Test Import: <?import:c:\temp\BEN_PG_VARTEXT.RTF?>• Import becomes: <?import:psxmlp://BEN_PG_VARTEXT_XSL?>
![Page 25: 101880 – Taking BI Publisher to the Next Level at Wells Fargo](https://reader035.vdocuments.us/reader035/viewer/2022062302/568168a7550346895ddf44a6/html5/thumbnails/25.jpg)
QuestDirect.org
Technical considerationsGetting To XSL
![Page 26: 101880 – Taking BI Publisher to the Next Level at Wells Fargo](https://reader035.vdocuments.us/reader035/viewer/2022062302/568168a7550346895ddf44a6/html5/thumbnails/26.jpg)
QuestDirect.org
Technical considerationsFrom Rowset to XML
• Rowset DataSource Deprecated.• Delivered AppPackage
Local PSXP_XMLGEN:RowSetDS &oRowSetDS = create PSXP_XMLGEN:RowSetDS();local string &xml = &oRowSetDS.getXMLData(&rs, "");
• Geting Fancy.class ReportDefnNW extends PSXP_RPTDEFNMANAGER:ReportDefnmethod SetRuntimeDataRowset /+ &Data as Rowset +/ /+ Extends/implements PSXP_RPTDEFNMANAGER:ReportDefn.SetRuntimeDataRowset +/ rem check report type, if rowset, then call super; Local %metadata:XMLPubRptMgr:XMLPubRptMgr &meta = %This.GetMetaData(); Local string &type = &meta.Ds_type; Evaluate &type When = "XML"
![Page 27: 101880 – Taking BI Publisher to the Next Level at Wells Fargo](https://reader035.vdocuments.us/reader035/viewer/2022062302/568168a7550346895ddf44a6/html5/thumbnails/27.jpg)
QuestDirect.org
Technical ConsiderationsReproduce Viewed Document
![Page 28: 101880 – Taking BI Publisher to the Next Level at Wells Fargo](https://reader035.vdocuments.us/reader035/viewer/2022062302/568168a7550346895ddf44a6/html5/thumbnails/28.jpg)
QuestDirect.org
Technical ConsiderationsReproduce Viewed Document
XML Doc StorageView Log
![Page 29: 101880 – Taking BI Publisher to the Next Level at Wells Fargo](https://reader035.vdocuments.us/reader035/viewer/2022062302/568168a7550346895ddf44a6/html5/thumbnails/29.jpg)
QuestDirect.org
Technical ConsiderationsDid the XML Change?
/*compare new xml to previously stored, only save if different*/ Local XMLDOC_NW:XmlDoc &xmlnew = create XMLDOC_NW:XmlDoc(); Local XMLDOC_NW:XmlDoc &xmlold = create XMLDOC_NW:XmlDoc(); If &xmlnew.ParseXmlFromURL(&oRpt.GetXMLDataFile()) Then &oldAttachName = %This.GetStoredXMLRef(%Datetime, &effdt); If All(&oldAttachName) Then If &xmlold.ParseXMLFromAttachment(&url, &oldAttachName) Then If &xmlnew.CompareTo(&xmlold) Then /*returns true if the same*/ &insert = False; End-If; End-If; End-If; End-If;
![Page 30: 101880 – Taking BI Publisher to the Next Level at Wells Fargo](https://reader035.vdocuments.us/reader035/viewer/2022062302/568168a7550346895ddf44a6/html5/thumbnails/30.jpg)
QuestDirect.org
Technical ConsiderationsXMLDoc Descendent
class XmlDoc extends XmlDoc method XmlDoc(); method CompareTo(&xmldoc As XmlDoc) Returns boolean; method CompareNodes(&node1 As XmlNode, &node2 As XmlNode) Returns boolean;…End-class;method CompareTo /+ &xmldoc as XmlDoc +/ /+ Returns Boolean +/ Return %This.CompareNodes(%This.DocumentElement, &xmldoc.DocumentElement); end-method;
![Page 31: 101880 – Taking BI Publisher to the Next Level at Wells Fargo](https://reader035.vdocuments.us/reader035/viewer/2022062302/568168a7550346895ddf44a6/html5/thumbnails/31.jpg)
QuestDirect.org
Questions/Discussion
![Page 32: 101880 – Taking BI Publisher to the Next Level at Wells Fargo](https://reader035.vdocuments.us/reader035/viewer/2022062302/568168a7550346895ddf44a6/html5/thumbnails/32.jpg)
QuestDirect.org
Contacts• [email protected]
– (612) 316-1373• [email protected]
– (612) 667-3726
Please complete your evaluation: Session 101880
Thank you!
![Page 33: 101880 – Taking BI Publisher to the Next Level at Wells Fargo](https://reader035.vdocuments.us/reader035/viewer/2022062302/568168a7550346895ddf44a6/html5/thumbnails/33.jpg)
QuestDirect.org
Upcoming Wells Fargo SessionsSession Time Room
Termination Processing at Wells Fargo W 2:00 Streeter
Enterprise Integration Using Third Party Transformation
Th 8:00 Schiller
Wells Fargo Upload Process Th 9:00 Rosemont 3
Leveraging Integration Broker To Increase Availability
Th 10:30 Rosemont 1
PeopleSoft Total Cost of Ownership Roundtable Th 11:30 Directors B
Automating Benefits Reprocessing at Wells Fargo Th 2:30 Rosemont 3
![Page 34: 101880 – Taking BI Publisher to the Next Level at Wells Fargo](https://reader035.vdocuments.us/reader035/viewer/2022062302/568168a7550346895ddf44a6/html5/thumbnails/34.jpg)
QuestDirect.org
APRIL 7-11, 2014Sands Expo and Convention CenterLas Vegas, Nevada
Save the Date
QuestDirect.org/COLLABORATE
COLLABORATE 14- Quest Forum is THE source for PeopleSoft roadmaps & news. It matters where you register! All PeopleSoft education and events run through Quest