Last thursday, I presented at the Philadelphia PeopleSoft and JD Edwards RUG. I was able to meet with lots of PeopleSoft customers and even catch up with a few folks I hadn't seen since the 2006 FSIUG meeting in Manhattan.

I even had a chance to spend some time with Kevin Agatone, fellow nVisionary, PeopleSoft Projects developer, and Fusion Projects developer. Kevin used to work for me on the reporting development team and ended moving on to bigger and better things.

I ended up creating new versions of our award-winning Advanced Tips and Techniques sessions, and the slide where I discussed PeopleSoft's control surfaces was very well received. I think I see a future blog intry coming.

Here are the links to the powerpoints

• More Advanced PeopleTools Tips and Techniques
• More Advanced Reporting Tips and Techniques
• Noetix Views for PeopleSoft HRMS (I covered hoverboards in this topic).

We look forward to our next user group meeting: Quest Northeast. Hope to see you there.

Labels: 2008, Events

This session is intended to discuss OBIEE as it relates to financial services. It was nice to see as much demo-ing as they did. It was also nice to see more of the features of OBIEE highlighted, especially the ability to create a very useful semantic view of the data that users can understand.

Room was full. About 200-300 people. Standing room only.

Dan Blankenship on FSI user group board - was also in pervious session. He introduced Steve Burns, who is on the Financial Services team at Oracle.

Session started by querying the audience. Most of attendees raised hands when asked if used PeopleSoft for back-office. Only a couple who used eBusiness suite.

OBIEE plus.
The session began by introducing OBIEE plus as the technology platform for providing anlaytics in this area. Steve started by talking about semantic model in OBIEE. Put logic into semantic layer.

Listed Golman, Wachovia, Axa as organizations using OBIEE. Leverage investments you've made in data source.

Talked about strategy of bringing together hyperion, peoplesoft and other acquisitions. (Operational BI, Enterprise perormance management, transaction systems). With the addition of the ability to access Essbase content within an OBIEE meta-model, this tool is now able to bring all this together for a single, cohesive solution that encompasses the different back-office systems.

Solutions Space
Steve, then went on to cover more about how they think about financial services from an analytic application perspective. Financial services organized into 4 areas: profitability, performance, risk management, and compliance. Below are some of the notes that I captured for a few of these areas:

Profitability
Used Fidelity as an example company that looks at customer profitability.

Showed screenshots with lots of charts and supporting details. Very analytic focused gtoing from high level to lower levels.

Credit suisse was listed as customer of OBIEE as well.

Risk management
Goldman Sachs, Credit Suisse and Bear Stearns listed as users of compliance solutions.

Features and Functions
They quickly went into a demonstration of a few of the areas and how the content that they're putting into OBIEE can solve many of these business poroblems.

Pervasive information delivery

• interactive dashboards
  
• ad-hoc query
  
• detections and alerts
  
• production reporting
  

Pervasive delivery

• financial reporting
  
• office
  
• disconnect and mobile anlaytics
  
• desktop gadgets
  

They also made a lot about the ability to drill from a report or analysis back into the transaction system. This feature is very similar to what we've blogged about for PeopleSoft reporting tools. I wonder if they've thought about taking this to the next level (like hoverboards)?

They moved on to demo drilling from report into more detail (starting from dashboard). Because they've pre-defined the path, they call this guided navigation.

They moved on to show how a user could start with a dashboard, extend a report, and add it to a personal dashboard. They didn't cover the administrative aspects of people creating their own dasboards, but it was cool seeing them do it. The functional area demonstrated was payables, where they started with 2 gauges and then drilled from one of them into a report.

The continued by demoing modifying the report (adding a chart). They then showed creating a new report and adding it to a dashboard. Positioned that business users can do this (do not need to get IT involved).

Summary
This was one of the better OBIEE presentations I've seen. One area I'd like to see more is a comprehensive story about how people will be able to snap these new applications onto their existing ERP solutions. This may not make sense in this presentations, but I believe that one of the primary factors in making a purchasing decision for OBIEE versus the products sold by other BI vendors is the effort to get it up and running (and really demonstrating to folks how these new applications are going to provide a seamless integration with their existing solutions... right now, I see a lot of hand-waving going on instead of showing exactly how this will work across data models of different releases of Siebel, PeopleSoft, and e-Business suite).

Labels: 2008, Collaborate, Events

Here is a list of events in which we'll be participating in the coming months. We hope to see you there.

Labels: 2008, Events

This week, Chris and myself presented at the UKOUG conference in Birmingham. Although Chris gave the same presentation as he did at Open World, I ended up giving an updated version of my Advanced Reporting Tips and Techniques.

This session was a updated to cover the following blog entries related to enhanced drilling.

• Deeper Drilling from reports
• Adding parameters to pages
• Drilling into performance documents in HR
• Drilling into Journal Entry pages

In addition, we covered Query and nVision reporting in HCM.

To streamline the drilling within Excel output, I used our Excel Add-in (but the hyperlinks could have been hard-coded into the reports instead of using this product for navigation).

Here's the powerpoint: 07_UKOUG_AdvancedReportingTechniques_PSFT_Enterprise.ppt

Labels: 2007, Events

Well, at least in terms of conference parties.

Labels: 2007, Events

This was the same session I gave last year at Open World. Jodi Runstadtler, the development manager for Reporting Tools gave it this year.

Instead of providing a set of development tips and techniques, Jodi went through the most asked questions she saw from the support as well as other things that she felt that people should know. For those who already read my Reporting Tools Roadmap session entry, you'll see several circumstances where I deferred providing more details to this blog entry.

XML Publisher Data Sources
Is there a difference between different supported data sources for XMLP?

• PS/Query-Rowsetsd
• XMLDoc
• XML File

Relational data services, such as PS/Query and Rowset will involve processing to align relational with XML structure. (recommend to extract data into XML yourself). Query does create the XML for you, but rowset can be an issue. Even XML doc goes to XML file before going into XMLP.

Bursting in XML Publisher

How do I do Bursting in XML Publisher? A common use case is needing to run reports for every department in a global operations.

You will want to design your report for bursting. The fewer transformations you have to do to the data to get it in the better it's going to perform. Definitely make sure you sort by the fields you're grouping on, so the XML file will be easily generated.

When bursting, XML publisher allows you to select a tag in your XML data for spliting up a single report into multiple. This tag must be at the highest level repeating group in the XML data. If you are using Query, this means that you are limited to bursting on a single field. Workaround is to concatenate in an expression.

One additional feature is that you can have different templates by values you're bursting on, so that different sets of data can have the results formatte specifically for them. One nice thing is that you don't have to enumerate every value you burst on to identify which template you want to use. You can set a default template and override where you want to.

Query Performance

After upgrading from 8.3 to 8.9, many customers saw that their Query security joins started causing performance issues.

Prior to 8.44, the security record was joined once for two records with the same one. This caused data to be missing in some circumstances. If you do not want multiple inclusion of security join (insert into psversion(Iobjecttypename, version) values ('qryselfj',1))

XML Publisher Templates

XML Publisher for peoplesoft means we have more decisions regarding report templates. How do I choose?

PDF templates are more limited than RTF templates. PDF templates don't support sub-templates, runtime paramters, translation files, output formulas, flexible field-data mapping (xpath vs simple name matching), charts, or custom/dynamic output where RTF does.

PDF performinga better, though, for large reports. Keep in mind that you need professional version of adobe to create/modify a pdf template that you're not getting from an external source. Mentioned can generate PDF output from RTF, though. Finally, 4 charts are available with bi publisher.

Subtemplates in XML Publisher

What are subtemplates?

Subtemplates allow defining re-usable templates that are imported into a parent template (similar to an include statement) . Each primpary template can import multiple subtemplates and they can include images, text, xsl templates, etc.

They are stored in content library, so there is no definitional link to primary templte (imported).

When previewing, you need to know that there are two places to do this. One is from within PeopleSoft PIA and the other is directly in the template builder within XML publisher. This is because the template designer works on a sample of the data and is stand-alone when it is launched (it doesn't know about PeopleSoft). Whereas the preview in PIA is the run-time environment within PeopleSoft.

Using Subtemplates as Headers

This is probably the most important reason to use subtemplates, because organizations will want to define a standard report heading. Unfortunately, word headers and footers do not support variables, which is how this is done. To do this, you need to code the highlighted area, which is the string that pouts the form/field in the header/footer. This is a manual coding step.

The following blog entry shows the sort of thing you need to go through to embed external data into word when word doesn't automatically handle it from a UI perspective.

Production Reporting
We need production reporting, but the report processing is consuming my server.

For Query, you should look at Query administrator. If you have administrators who don't want to use a PeopleSoft page, you could use PeopleCode APIs to examine the query statistics. These API calls mirror the fields in the PSQRYSTATS table (which you could also query to get this information). However, delete is an API call available, which isn't in the table and you wouldn't want to do yourself in SQL, because PS/Query has a lot of references.

Finally, Jodi mentioned performance monitor, where teh 355 event shows real-time and historical performance.

Although this is valuable information, I don't consider it Production Reporting, where you have reports run automatically on a schedule and you have to distribute results to end-users. Did I mention we have a product that does that?

Office 2007 and nVision

Oracle is now supporting Office 2007 with nVision. However, there are some issues with it.

Microsoft has changed the file format to be a standard XML format. Once a file is saved in this format, it is not compatible with older versions. Because of this, when you migrate to Office 2007, you will have to make sure the version of Excel on your process scheduler servers matches those on the desktops of the end-users. Office 2007 save this as XLSX.

Organizations will also need a specific version of XMLP for office 2007.

Migration of XMLP between environments

When I migrated my XMLP reports from test to produciton, the translation files were missing.

You will need to follow sequence for doing this. Need to include both the data source defin query. Select XMLPDataSrcDefn (also select query) Select XMLPReportDEfin to include all components. A report may incorporate multiple FileDefnobjects... tempalte data, translations, pdf maps.

Deletion and cleanup. To delete XML Publisher metadata objects, use project delete. Sometimes can cause orphaned definitions, so they created an app engtine progrm to clean it up. Identify orphans, and clean up orphans.

Picking the Right Reporting Tool

This is a common question that I used to get hit with all the time as well. When should one use each reporting tool?

The criterion for this falls under the following categories:

What is the structure of the Report?

• Forms-based?
• simple tabular?
• sub report?
• matrixed?
• Does it include application metadata?

What are the formatting requirements?

• Pixel Precision?
• MICR?
• Graphics/logos?
• Charting?

How is the report being run?

• reporting with logtic/processing?
• scheduled on temand?
• ad-hoc?
• bursing?
• drilldown,?

What platforms will you use?

• Windows
• Unix
• OS/390
• Excel Integration?

She showed a matrix of tools and which of the above features are suppported to help through the process.

Crystal and Hyperlinks

After the session, Sarah Hahn from the Benton Public Utility District recognized me from presenting this session at the Puget Sound Oracle Users Group meeting earlier in the year. She wanted to know more about drilling from Crystal.

Although I plan to record a demo of this and write a blog entry, here's what you would do:

• FInd the element in the crystal reort that will have the hyperlink attached to it.
• Select it and use the Insert Hyperlink menu in Crystal.
• Instead of typing a Hyperlink into the edit box on the dialog, you will want to click on the button next to the edit box to open the formula editor (it has an X>)
• Finally, you compose the text of the hyperlink by using field references, string functions, and text.

Labels: 2007, Events

This session was a throw-back to the old PeopleSoft Talk-back sessions, where customers could ask the development managers and strategy any question they would like. On the panel were the following:

• Jeff Robbins - PeopleTools Product Strategy Director and moderator
• Binu Matthew - VP of PeopleTools Development (the boss of everybody else on the panel)
• Colleen Murray - Director of Reporting Tools Development
• Hind Robous - VP of PeopleTools Support
• Chris Kuwada - Director of QA
• Willie Suh - Director of Core Tools Development
• Ravi Shankar - Director of Platforms

Here are the questions and answers I could capture:

Q: Keynote mantioned how support will be enhanced to 2025. How does this change things?

A: Binu - This isn't too surprising, because from my perspective, PeopleSoft is very important to Oracle. For example, HCM is flagship application. This means we need to have continued investment.

Q: PeopleCode is messy hybrid - Is there a plan to depracate the old method of writing PeopleCode versus the API version. Error handling for command-based is worse than API side.

A: Willie said that there was no plans to depracate any of the pre-PeopleTools 8.4 style writing of PeopleCode, but would like to know what issues they're having. Chris Heller (my notorious sidekick) suggested that if an organization is trying to standardize on the newer-style, thgat providing warnings when the old-style is used, so that folks will use the preferred method.

Q: What is the future for those who use primarily PeopleTools for building their own custom applications? Specifically, there's a lot of discussion on Oracle tools, such as BPEL. Will we need to use that?

A: Strategy is that PeopleTools will continue to be enhanced where it drives value for PeopleSoft applications. Core PeopleTools will be enhanced and enhanced heavily. Tools is getting heavily enhanced (8.48 is one of the biggest enhancements in a long time). For Hypbrid environments, where PeopleSoft isn't a major component (there may be other applications such as Siebel or custom-developed applcications, then it is our recommendation to look at the Oracle tools.

Q: Training does not talk about Application Classes or Iscripts.

A: Willie responded: I agree with you and am not happy with status quo... curriculum is on old releases. Binu also chimed in: The issues are in selected areas. For example, the integration broker class has been completely updated. However I agree with you that app classes hasn't been added, though.

Q: It is my understanding that upgrade assistance for fusion migration will be part of enterprise manager Will this be available for PeopleSoft moving to fusion?

A: We are looking at it, but isn't part of an explicit plan.

Q: Anything going on with RFID?

A: PeopleTools isn't doing anything specific, but the supply chain team has done integration.

Q: End-users refuse to use nVision on the web, because of how difficult it is to drill from web reports. I remember lots of discussion about new enhancements for release 9, but that seems to have disappeared. Any chance to get it in place?

A: Colleen talked about how she was involved with much of the planning for web nVision in PeopleTools x (yes... I remember lots of hours in conference rooms with her flushing out the functionality, prototyping it, and discussing potential issues). Although she focused on answering that aspect of the question and how she still has a long-term vision for brininging some of that to customers, she didn't discuss drilling at all. Did we mention that we have a product that fixes drilling with nVision? All joking aside, this product is intended to address all the issues customers have with drilling on the web with nVision.

Q: PeopleBooks... We have a problem with PeopleBooks and can't find what we want. Is there any way to cut a CD and provide to customers?

A: No plans to date for this. Do have a plan to improve search. 8.48 PeopleBooks is on OTN (hosted). Posted in PDF form as well.

Q: Batch... With app engine (we're tyring to use it more), and using XML publisher. In fusion, nobody is saying how you code your batch. What do we do to prepare for fusion... Java?

A: This is an ebusiness area of ownership, which means they would provide a better answer. However, from the discussions we've had with them, they are working on another language... will have their own scheduler. However, addressing the migration itself, keep in mind that the data model will change significantly, which means code you write today will probably nhot doesn't think code will move cleanly. Go with PSFT architecture for now and don't worry as much about fusion impacts.

Q: Why isn't BPEL included if that's what we should be using.

A: Jeff answered: we will continue to deliver functionality for the PSFT stack. Things that go outside of PSFT is where you will want BPEL.

Q: 8.48 includes a lot of new functionality in integration broker. How much work will we need to do as part of upgrading. Will our existing IB definitions work out of the box?

A: Colleen: we have rearchitected the objects and you really need to understand it. As you go through the upgrade, we have done the mapping and an upgrade script that does the conversion. We need default values prior to running the script because new fields exist in new world.

Q: When will you certify of 2-tier query on vista on PeopleTools 8.46, although we're planning to move to 8.48.

A: No plans to backport that support to 8.46. Require 8.48 for vista.

Q: Any plans for code coverage from testing perspective? Can put code in place to enforce development standards?

A: Binu-- plans for version tracking and other developer productivity tools.

Labels: 2007, Events

Those who know who I am may find it wierd that I'm blogging this session as an attendee versus a presenter. This presentation was given by Colleen Rinehart, who I have a good history of working with (she took over the management of the reporting development team from me and allowed me to take on a pure product management role). You may also recognize her from past presentations where she and myself covered this exact session.

This session covered 3 things:

1. A review of how all the tools fit together.
2. A review of recent features made available in PeopleTools 8.48
3. A summary of planned items for PeopleTools 8.50

Tool Overview
Colleen discussed the different reporting tools, Crystal, XML Publisher, nVision, SQR, and Query and how they fit together. The slides did a pretty good job of covering that aspect, so I won't go into more detail on this part, except to say that Oracle is more aggressively positioning XML Publisher as an alternative to Crystal for new report development.

XML Publisher
There are several new features coming in XML Publisher. One thing to note is that many of these features are core XML publisher features, versus PeopleSoft-specific feature enablement. Here is the list:

• Subreports in XMLP. You can embed reports within other reports (from a template perspective). Examples of where you would want to do this is page headings and footings (there's a limitation in this covered in Jody Runstadler's Advanced Reporting Techniques session, which I will cover in my write-up for that session)
• Performance improvements for rowset and query feeding into it. Because PeopleSoft has to convert the data froma query and a rowset to an XML file on the server and then feed it into XML publisher, there could be potential performance issues. Development is working on an automated way of handling this in a manner similar to PS/Query.
• Email distribution. The delivered email distribution in process scheduler is currently only supported for nVision, Crystal, and SQR. This will be added for Query and XMLP (did I ever mention we have a product that already does this for any output type?)
• New versusions. They will add support for BI Publisher and 11g.

nVision
Started by making sure that the audience knew that nVision was not going away. For nVision, much of the discussion was on longer-term futures (8.50). The exception is for Office 2007 support.

• Not in tree criteria. This is something that we've seen a need for. It's mostly valuable when you want to capture data from of values that may not have been added to your tree (we approach it a little differently by proactively facilitating the addition of values to the tree as part of the maintenance process with this product instead of showing it after the fact)
• Multiple effective dated trees in same report. This allows organizations to compare the implications of tree changes side by side in a single report. Although you can see the changes pretty easily by exporting your trees to file and compare them there using tree mover, this allows you to see the dollar impact of the change.
• Query prompts. This is one of the features that I've heard a lot about over time. If you have a prompted query in an nVision report, those prompts can only be displayed in the windows nVision (not web). This will be an interesting feature if they really can get it in, because if they do it right, they may be able to add additional features as well. I'll put together a follow-up blog entry on the issues with this.
• Private reports in 2-tier. This is one of those things where there was a new feature added to the web that wasn't also added to the 2-tier nVision. You will now be able to secure your report requests on 2-tier as well.
• Excel 2007 adoptions of server performance improvements. This is something that I've had some discussions with Microsoft about and am very excited about. One of the biggest places where we had issues with nVision is stability and performance on the server. This is because Excel is a client tool where nVision automates it on a server. Excell 2007 has a server version that can be used very nicely with nVision, and they are adopting it. This will be a big win for anybody who moves to it (but my understanding is that Office 2007 is only supported on PeopleTools 8.49 or greater due to the file format changes imposed by microsoft. I'll have a lot more of that in my discussion on Jody Runstadtler's session.

Crystal Reports
Reiterated Oracle's commitment to continue providing Crystal as part of PeopleTools

• Includes Bobj XIr2.
• Mupltiple PeopleSoft instances sharing BOE server. When I scoped this feature for PeopleTools 8.48, this was one of the items that was very important to Business Objects (the business terms of this OEM were negotiated based on the fact that Business Objects would be able to re-sell additional licenses of Business Objects Enterprise for non-PeopleSoft applications). Much of the value of the up-sell is removed if there's one BOE environment for PeopleSoft and a different one for all other reporting, because that would cause users to have to sign into a different system to get one type of report than another.
• Discontinuation of Crystal Subreports. Now, this was news to me, and I'm curious as to the reasons why this is occurring. I'm sure it isn't an overt effort to steer customers to XML publisher from Crystal (although cynical folks could think that, based on the fact that subreports is a new feature in XMLP). I'll have to dig in more as to what technical issue cropped up for them.

Query
From a short-term perspective, much of the new functionality is in the area of extending the use of Query as a means of getting data out of PeopleSoft, specifically to use it as a means of quickly developing a web service.

• Subreport support. There wasn't much discussed in this area, but I'm pretty sure it's the work done in the Query Access Service (QAS) to allow multiple queries to be run concurrently through the same session.
• Connected query. Again, not a lot discussed, but again, I'm pretty sure this is the ability to use the query service to refresh data in excel without having to navigate to PeopleSoft to re-run it (support for pull as well as push).
• Extend web service enablement of query. I'm glad to see this one. There are a lot of situations where it would be valuable to take a query definition and add criteria on the fly and run it through a web service. Although I was planning a blog entry on doing this using a component interface, there were enough issues with the way the Query API works that I ended up not doing it.

Trees
On the tree side, there wasn't much to report in terms of new tree manager functionality, with the exception of web service enablement for trees. This would allow the Tree Classes to be exposed as web services. Also very valuable when you have two systems that you want to do lookups and updates across them (anybody have an HR Department tree and a Finance Department tree?). By having web services for this, you can do the lookups as you update one tree or the other. Very cool stuff.

Cube Manager
This was the big shocker for me. After many years of neglecting this product, I was sure it was going to die penniless and alone (although you wouldn't catch me writing that out formally). I've included the history of cube manager in this larger post on tree manager, in case you want to know why. Looking back on the Hyperion acquisition, it makes a lot more sense to keep cube manager alive.

• Support for new version of Essbase and PowerPlay. Yes. The versions being supported will finally be updated after 5 years. This will make many companies who have been staying on an old version of Essbase and PowerPlay because cube manager does what they want, and it just plain works (by the way, the kudos of this goes to a certain Brian Sparling, who created cube manager... Ever heard the name Sparling before??)
• Drop PeopleSoft star schema. The history of the PeopleSoft star schema is a very interesting one (but not one I can readily share in written form). Because it was created for EPM, but EPM is using Data Mart Builder to build its star schema, it makes sense that this feature should be dropped. Colleen did put to the audience that they should let her know if that feature is important to them, though.

Reporting Metadata
As mentioned above, much of the reporting metadata (queries and trees) are now going to be exposed as web services. This was reiterated.

• Using Query as a web service development tool. Talked about QAS (which was created for BOBJ enterprise)
• Exposing definition and designer capabilities for trees and queries. This facilitates support for OBIEE, sharing data, etc. It may also be interesting for Web Intelligence in Business Objects (with universes). I may have to talk to my friends at Bobj about this.

Reporting Infrastructure
As many folks who've gone to other sessions of mine will know, I spend a lot of time talking about the infrastructure to support reporting (metadata, security, scheduling, distribution). Colleen talked about what's coming in this as well.

• User Experience with respect to scheduling and monitoring reports. She mentioned that they're working on the ability to find reports that are older than 99 days. I'm sure that there's more in this area that they're not talking about. Did I mention that we have a product that fixes the user experience in this area?
• Making role-based security in report manager. The issue being fixed probably should have been a blog posting. Essentially, when you run a report to a role in process scheduler, it decomposes the role to its individual users at the time the report is run (take a look at the table PS_CDM_AUTH, you'll see that there is an OPRID field, but not a ROLE field). This means that if you move people in and out of roles, the reports associated with the role a person performs do not stay with the role.

Q&A
Although there were several questions on different partners and products, there is one that I want to make sure gets listed here. This was the question on XBRL support in PeopleSoft (which, for those who were at the session, may notice that I was the person who answered the question).

You can really think of XBRL as a standardized report format in XML for publishing financial results. In other words, it's a form (like your W-2 is a form). Because of this, the XBRL support by PeopleSoft is done by the applications groups (just like the support of W-2 is done by the Payroll development team). This support was provided in Financials 8.8 (and I remember the meetings with the developers to come up with the approach for doing this).

Here's the announcement of XBRL support: http://findarticles.com/p/articles/mi_m0EIN/is_2003_Sept_15/ai_107753879

Labels: 2007, Events

This presentation talked about how to benchmark the performance of your finance organization. It discusses it from a Hackett Group perspective, who does a lot of this.

What is Benchmarking?
This is different from what your DBA calls benchmarking. Essentially, they're looking at efficiency and effectiveness of a given business function. This gets into many of the concepts important to embedded analytics, because you're aligning the measurement with the business processes.

Impact to a Finance Organization
For a finance department, the focus on cash flow optimization as key driver as effectiveness of finance organization.

The slides had some very good information related to business processes that occur in a finance organization (for most folks, it's a bit more nebulous than the business processes for HR, for example, where you hire, incent, manage, and terminate employees as business processes)

Here are many of the processes that span SG&A

• Cash disbursements
• revenue cycle
• accounting and external reportring
• tax management
• treasury (cash) management
• compliance management
• planning and financial performance management
• businsess analysis
• function management

Here are the Procurement business processes

• supply data mangement
• requisition and po processing
• supplier scheduling
• receipt processing
• compliance management
• customer management

He then went on to illustrate how for each process, you should think about benchmarking. He showed the following formula:

Demand drivers + structural factors = performance metrics

or

processes organizations perform + how organizaitons structure themselves and conduct those processes = Measurement of how well the organization is doing

one last translation

Business Operation + Dimension = Key Performance Metric

Summary

One of the things I liked about this presentation was how it identified the business processes that are part of a finance organization, and how you can align the things you measure with those operations you're performing. Although this isn't a BI presentation, much of what was illustrated translates well into the BI world, where analysis isn't easily tied to the tasks that people perform (and ultimately, what organizations need to continuously improve).

Labels: 2007, Events

Charlotte Skawski of the Hartford (who I know from my participation in the Financial Services User Group) presented her upgrade.

She did a great job of dealing with technical issues (her powerpoint was not where it should have been, and she had to start without one). Fortunately, whe was able to provide her high-level overview prior to the point in which she needed the powerpoint to show additional detail (specifically her upgrade timeline).

Much of the presentation was a good discussion on the methodology for approaching an upgrade, getting buy-in from the stakeholders (especially the end-users who are responsible for doing the fit/gap analysis of the new release as well as testing the data conversion and functionality prior to going live). Also, because the powerpoint covered the topics pretty well, my notes centered on the Q&A.

Q: Could you migrate security in the upgrade?
A: They didn't have the opportunity to revisit the security rules and kept things pretty much as they were. (this is the place for a shameless plug for a product we're working on, which I didn't do in the presentation)

Q:DID YOU USE ANY AUTOMATED TESTING TOOLS?
A: Yes for performance... Use Mercury LoadRunner. All other testing was done manually, although they're looking to find a solution in this area.

Q: How many test move to productions?
A: Did 3 or 4 originally scheduled. One thing that was a challenge for them was that they couldn't even get through scripts as originally delivered by Oracle without some tweaking from a performance perspective.

Q: How many customizations were removed due to functionality versus not needing any more.
A: My gut feel is that there were a lot of both. Perhaps half and half.

Q: Did you have issues with your functional users getting pulled from the upgrade to do other things?
A: There were a good number of end-users involved (about 1 dozen), and this was a concern. She talked about how important it was to have a steering committe with executives and how this minimized the amount of pull-back because they had buy-in. Get commitment up-front and show timelines.

Q: Can you tell me more about how you assessed the 8.4 versus 9.0 functionality, including your customizations?
A: We use stat to move code from development to production. We did have documentation on every single piece of code that was moved. Used excel to analyze dumps of the checkin glogs for every piece of code to determine whether it was needed. THis was done in combination with upgrade compare reports.

Q: What about freezing changes and locking down new functionality?
A: We were frozen at end of august for november release. At what point did they lock-down on new functionality.

Q: Did I read that you started on Feb 06 and are still going for the upgrade?
A: No. That must have been an error. It's a 1 year upgrade Feb-07 to FEb-08.

Q: HOw did table changes affect reports?
A: We didn't have to rewrite our nVision reports. Most of our queries... We have a lot of queries out there... Ton of public and private queries... we migrated them all over. Not a lot of table changes, so it went smoothly.

Q: Why not upgrade to 8.9?
A: Because the PeopleTools 8.48 enhancements were adopted by the applications. The decision between 8.9 and 9.0 is relatively easy because 9.0 doen't have that many application changes.
Workflow... THey re-built their existing ones because the workflow engine is completely different in 9.0 (tools 8.48)

Comment from Oracle Development: We will now package upgrade directly to service packs versus taking to the GA of 9.0 and requiring customers to apply the maintenance packs themselves.

Labels: 2007, Events

This is the session that Chris Heller and Myself gave at the conference (based, in part, on the following blog entry).

We started out by having some pretty significan technical issues with our demo environment. For those who aren't familiar with how we present, we believe that conference sessions should show something that people can't find simply by reading a powerpoint presentation. Therefore, we generally go pretty far out on a limb with our presentations (it's relatively safe to talk through bullets... to show a live system where you're making changes in front of the audience... now that takes some work).

We thank our audience for being patient with us as we brought up a back-up environment (actually, we used VMWare's revert to snapshot feature, which allows us to bring the environment back up without those pesky little blue-screen-of-deaths).

The good news is that we eventually did get things going, and the people who were patient with us were able to see lots of interesting things, such as code distribution to the process scheduler, automated versioning of report development, and even versioning of PeopleTools objects. We made a brief mention at the end of the presentation that we were planning to take what we showed them, add the ability to have more granular control over the PeopleTools objects, and a direct plug-in into application designer. There were a bunch of folks who came up after the session who expressed interest in the product versus trying to do the work themselves.

Labels: 2007, Events

Well, I ended up taking Oracle up on the Blogger registration for Open World (see here for background).


The first session I attended is the Financial Services User Group Meeting. Since we have a long history with this user group (many of our customers are very involved in this group), I felt it was important to see what things they've been thinking about.

Here are the concerns that I've been hearing that I was looking to get answers for:

Future of FSI Analytic Apps

Most of the Financial Services organizations we've been working with have made a significant investment in PeopleSoft EPM, notably in the analytic applications supporting Financial Services on that platform. They've been getting mixed messages about the future of that product, including some last-minute cancelled sessions to discuss the future of CPM at Oracle. The rumor mill is saying that Oracle is killing EPM in favor of its eBusiness-driven data warehousing products, but that doing Financial Services vertical applications was not in the plans.

Future of reporting tools

Again, most of the Financial Services organizations use PeopleSoft nVision pretty extensively for management reporting. They would like to know the plans for investment in this product and what will happen in Fusion.

Here is what I learned from this session

Discussion of the future of the FSIUG:

Laura Stobbs of Everett Jones in st louis was the facilitator for meeting. She talked about how the FSIUG has recently moved to be under the Quest umbrella instead of being completely independent. There was a good amount of discussion about the enhancement request process as part of this.

Discussion on positioning for fusion:

Citigroup mentioned that they are getting mixed messages from Oracle's field organization with respect to moving to fusion. Specifically that their salespeople have told them to migrate to the eBusiness Suite to be ready for Fusion, since fusion will be built off of it.

Patric Boyle replied that customers should not expect to move to Fusion before 2012 - 2013. It is his belief that this would be the earliest that fusion would be avilalbe for FSI customers. Too much is being brought over from PeopleSoft from a data model perspective: effdt, allocations, trees, and that it will take some time to rationalize that.

Development Update:

Amira Morcos discussed the development plans with respect to financials and financial services. Here is what she discussed:

9.0/9.1 Status:

• Combo edit performance improvements in 9.0 and request to backport to 8.9. This has been done.
• Re-write of allocations from Cobol to App Engine caused rounding errors for allocations. This is targeted to 8.9. Amira asked for more use cases. The issue is balancing accuracy with performance (row-by-row versus set-based). Development is hanging on this.
• Allocations enhancement - include not equal to to reduce the number of allocation steps
• There will be new workflow enhancements included. PeopleTools currently has new workflow functionality that eliminates the need to to customize the application to get approvals (aka virtual approver). 9.1 will have workflows built into the product using this technology. Customers upgrading tools without the application upgrade can take advantage of this, but it will include some customization if done prior to applicaiton adoption of this.

9.2 priority status

• Back-date transactions (value date). Development needs to know what that means and needs additional use cases from the user group on this feature.
• Lead-in to missing functionality (daily close as a modification by CitiGroup)
• Combo edit on fields or data sets other than chartfields (development wants to know what they are, needs details)

Amira followed-on by asked more long-term planning. In 3-5 years, where do folks want to be from an ERP perspective.

• Citigroup responded by saying that it is having troubles because they want to do all reporting in EPM, but they have special projects that have operational requirements, which causes challenges for them. The challenge is a disconnect between ERP and EPM.

Amira followed up by talking about Collaborative workspaces, which is a PeopleTools product that originally was developed for the as part of the Portal product. Collaborative workspaces provides a means of defining a set of tasks, assignments, and calendar related to a set of goals a group share (and enable the colloboration across members). She felt that building out workspaces that support the key business processes in financials, such as closing and reconciliation. She asked to have the user group provide other business processes that would fit into this from a Financial Services Perspective.

There was an unofficial discussion on upcoming releases (the people in the conversation will remain nameless to protect them).

• 9.1 should be rolled out in latter part of 2008 (8.50 tool dependency). HR is planned to release first, then followed by other suites. Financials could have its 9.2 release in the middle of 2009 (but will deny)

New Global Business Unit
One of the biggest announcements is that ORacle will be forming a Financial Services Global Business Unit (I think I heard 10,000 people, but that sounds to be too many). This group will include both field-level and corporate resources. This group is currently gathering information for PeopleSoft 9.2.

Although no details were discussed (there is a session specifically talking about the new business unit), it is my belief that this organization will be tasked with figuring out (and potentially developing) the future analytic applications for fusion supporting this industry.

Labels: 2007, Events

Here are a couple of events that we'll be at:

Northern California PeopleSoft RUG meeting
(June 15 at the Fremont Mariott)
I'll be taking the following blog posting and presenting it here.

PeopleSoft NorthWest RUG Oracle Day 2007
(June 28 at Meydenbauer Conference Center, Bellevue, WA)
I'll be presenting an updated version of the Advanced Reporting Techniques for PeopleSoft Enterprise.

Labels: 2007, Events

Although we've got a bunch of in-process blog entries, it's been much too long since our last posting (especially since our last set of posts weren't really tips or techniques). Although we plan to fix that in the coming days, I thought it might make sense to talk about what we've been up to on the business side of the house (most of which has come out of recent activity meeting with customers).

Excel Add-in Extensions - Part 1
Since we initially created our nVision add-in and began selling and marketing it, we've learned a lot about the PeopleSoft customer base and some of the things that drive evaluating and purchasing software. This deserves its own blog entry, so suffice to say that we've taken these learnings into account with new releases of this product.

The first thing we did was to extend the product to eliminate the need to package up code on the server. Yes, that means that this product has "NO CODE ON THE SERVER". We thought that was pretty funny, considering PeopleSoft's mantra. The benefit of keeping all code in the add-in is that the people evaluating the product can try it without having to change anything in their PeopleSoft environment.

Because we had to add code to manage the interaction between PeopleSoft and excel, a side benefit is that we've also been able to address many common issues customers have to face with the PeopleSoft version, such as proliferation the Ren Server windows (when excel isn't hosted in the browser) and locking of the excel menus (when the spreadsheet is hosted in the browser). This was version 2.0 of the product.

Excel Add-in Extensions - Part 2
At Collaborate, we also met with a bunch of PeopleSoft customers who wanted better formatting for their queries (even something as simple as column widths is problematic). Funny enough, the infrastructure we just developed for "no code on the server" also allows us to solve some problems with Query and add some pretty cool enhancements, such as:

• Query Context: desribing the query (record names, field names, SQL)
• fixing number formatting
• fixing column witdth
• other formatting, such as putting in company logos, etc.
• subtotalling
• automatically adding auto-filters
• drilling from queries to other queries or pages

Therefore, we've held off distributing code snippets from Collaborate to add many of these features to our add-in (version 3 of the product). We expect to release it before the end of next week (less than 1 month from the release the prior release), so look for an announcement on that (if you want to try it out as soon as it's available, feel free to contact us at info@greysparling.com ).

Desktop Single Signon Extensions - Part 1
This one also falls under the category of doing 2 things at once. As many blog readers know, we have a desktop single signon product that takes their windows credentials, determines what their PeopleSoft userid is, and automatically signs them into the web application. This product has been receiving rave reviews (even from folks we worked with at PeopleSoft who were our biggest critics... they know who they are ;-)

Anyway, we had just finished beta-testing a new release that adds support for the client/server tools. This means that customers who deploy the windows tools (such as PS/Query, PS/nVision and app designer) can take advantage of this as well. However, due to considerations with PeopleTools, this version only worked when the initial authentication was done through the app server (we could get into a long discussion as to why we decided to do this, but we'll leave that for another blog entry as well).

Desktop Single Signon Extensions - Part 2
Anyway, we had one customer who wanted to use this as a way to demonstrate to their auditors that they have appropriate safeguards against passwords etc (since the network userid and password are the only point of failure from that perspective). Unfortunately, one cannot perform upgrade actions (such as moving code from development to test) with a 3-tier connection.

Therefore, again, we found ourselves completing one release and quickly turning around and developing the next one (true 2-tier desktop single signon). We're finally ready to release that (but were pretty busy doing this to meet a customer's schedule).

PeopleSoft Reviews
Finally, we've been very busy taking the PeopleSoft Experts Corner to customers for quick, high-value consulting engagements. We call them PeopleSoft Reviews, and consist of 2 days onsite, with prep work and a follow-on findings report. It's a great value for folks who want guidance with respect to:

• Their most pressing PeopleSoft issues
• Improving how they develop, administer, and support their PeopleSoft application
• Planning their next set of development initiatives

We had a bunch of these leading up to Collaborate (focusing on things from Performance tuning, Development practices, Security practices, and Reporting practices). Much of the value to customers for this type of engagement is a formal "findings report, " which is essentially a roadmap of recommendations targeted to the individual customer. Because of this, we've been very busy writing them and packaging up code snippets that support our recommendations.

We're in the process of finalizing our schedule for this summer, so if you're interested in having us come onsite to provide recommendations for you, feel free to contact us at info@greysparling.com Here's a brochure that describes some of the things we can do for you.

Labels: 2007, Events, Products

In the past couple of days, we've received lots and lots of emails from folks who attended our sessions at the Alliance Conference and wanted to let us know how much they enjoyed the content. We also had a great time and really enjoyed meeting with all of you.

The best way to ensure that these conferences include sessions valuable to you is to provide feedback. The sessions with the highest historical satisfaction ratings will get preference in future conferences.

If you liked our sessions and would like to see more (believe me, we have all sorts of tips and tricks we could cover in future sessions), please fill out the Evaluation Survey (the link is here, if the email from the alliance conference folks isn't handy).

Labels: 2007, Events

We had a great time this week at the Alliance Conference this week. I presented "Advanced PeopleTools Tips and Techniques" (session 23422) and Larry presented "Advanced Reporting Techniques for PeopleSoft Enterprise" (session 23743). We both had several hundred people attend, which is quite nice. There were lots of great questions as well. I have a few blog posts that I was already working on during the flight home based on a few of them.

Big thanks go out to Tina Thorstenson from Arizona State University for asking us to come present and to Jeff Robbins and Dave Bain from Oracle for being our co-presenters. If you enjoyed the sessions, be sure to fill out the online evaluation forms.

Here are the code snippets for the PeopleTools presentation.
Because the code snippets for the Reporting Presentation are Environment-dependent, the links to download the code snippets are in the PowerPoint presentation.

Labels: 2007, Events, PeopleCode

It looks like 2007 is going to be a very busy year for us attending different events. Here is the schedule for the first quarter of the year (In May, we have two sessions submitted for the EMEA conference in Amsterdam as well).

Here is a summary of where we'll be and what we'll be presenting. As mentioned in previous blog postings, we will be updating the content to keep it new and interesting for folks who saw them last year.

	Northern California OAUG Training Day (January 17th, 2007) - Visit us at the Santa Clara Convention Center for the Northern California version of the PeopleSoft Expert's Corner. We will be presenting the following. Advanced Reporting Techniques for PeopleSoft Enterprise
	Alliance 07 (March 11-14, 2007) - Visit us at Disneyworld in Orlando for the Higher Ed and Public Sector version of the PeopleSoft Expert's Corner. We will be presenting the following sessions. Advanced Reporting Techniques for PeopleSoft Enterprise Advanced Tips and Techniques for PeopleTools Developers
	Collaborate 07 (April 14 - April 20) - Visit us at the Mandalay Bay Hotel in Las Vegas for the Collaborate version of the PeopleSoft Expert's Corner. We will be presenting the following Oracle sessions. Session 23360: PeopleTools Advanced Tips and Techniques

Labels: 2007, Events

Out with the Old
We watched Dick Clark, drank Champagne, and sang Auld Lang Syne. We also began work on our year-end close, just like so many of the PeopleSoft customers who read our blog. This must mean that 2006 is over and 2007 is beginning. It was such a great year for us that we felt we would be remiss not to blog the year.

In with the New
2006 marked the first full year of operations for Grey Sparling Solutions. It was a great year to be part of the Oracle/PeopleSoft world. 2005 was a year of uncertainty for PeopleSoft customers (what is Oracle going to do? what is Fusion all about? who planned the PeopleSoft content at the 2005 OpenWorld?), but 2006 was a huge improvement.

Oracle announced Applications Unlimited at the Collaborate 2006 conference, and that has been hugely popular. Oracle also announced that the PeopleSoft products would have their own General Manager structure, with longtime PeopleSofter Doris Wong heading things up. Another interesting metric is that all of the system integrator companies that we work with seem to have more business with PeopleSoft projects than ever before

The Grey Sparling Effect
We saw a significant increase in the number of customers using Grey Sparling products. That wasn't too hard since we shipped our first product in November 2005, but we have more customers than employees now, which I always remember as being a key statistic for enterprise software.

It also helped that we have several new products that we shipped this year:

• nVision Drilling Snap-On
• Report Explorer
• PSIDE Helper Snap-On
• Desktop Single Signon
• nVision Context Helper Snap-On

All of that helped us turn a profit for 2006. Woo hoo! Well, it wasn't a very large profit, but it still feels pretty good to hit profitability in our first 18 months of operation. We also became an official Oracle partner this year.

PeopleSoft Experts on the Road
Aside from folks that became Grey Sparling customers this year, we talked with a large number of people at various conferences. We were extremely flattered to be asked as subject matter experts by conference organizers to give Oracle (versus vendor) presentations. This allowed us to connect with over 2,000 PeopleSoft customers in person in 2006.

• Financial Services Industry User Group
• Alliance Conference (Higher Education User Group, State and Local User Group, Federal User Network)
• Northern California PeopleSoft User Group
• Mid-Atlantic User Group
• Quest Mid-West
• Oracle OpenWorld
• UK Oracle User Group
• Santa's Helpers User Group (just seeing if you're still reading!)

PeopleSoft Experts Online
In addition to physical meetings with folks, we also met lots of people via our weblog. I'm always surprised that there aren't more PeopleSoft bloggers out there - we certainly know plenty of people with lots to say about PeopleSoft!

We were also proud to be credited with inspiring some new bloggers out there.

• Marion Crkon
• Dan Iverson
• Jim Marion

2006 Blog Entry awards.
We figured that if Time Magazine can have its set of top 10's, we should too.:

• Most Unusual blog entry. Who would have thought about integrating instant messaging with PeopleTools? Chris, of course!
• Most Humorous blog entry. Before it was posted on YouTube, the top link to see SAP's take on Larry Ellison was from our site.
• Most Historical blog entry. Think scoping a PeopleSoft release took lots of analysis and effort? It did, but if certain features made it in, the world may actually have come to an end.
• Best Fusion Preparation series (Java and PeopleCode 1, Java and PeopleCode 2, Java and PeopleCode 3). J2EE and Web 2.0 your PeopleSoft application, because that's a big part of Fusion!
• Most popular blog entry that almost didn't get written. Is anybody really thinking about Setids and Business Units any more? Apparently Yes!

Top Grey Sparling Conference Stories of 2006
While we're putting together our top blog entries, we might as well list out our top conference stories of the year.

• Best Sales story. At Oracle Open World, we literally had a PeopleSoft customer come up to our booth on the first day and ask us how quickly we could generate an invoice for our Desktop Single Signon product. We did a remote install using the Open World wireless, and they were using the product live within 2 weeks for their 2007 Open Enrollment. Initial contact to Production in less than 2 weeks!
• Runner-Up Sales story. At the FSIUG in New York after demonstrating the nVision Drilling Snap-on, we did a remote installation of a trial version at a customer. This customer was able to use WebEx to show it to end-users who were not at the conference, and decide to purchase it right then and there.
• Best Cheapskate story. This had to be at the Alliance Conference, where we discovered how expensive it would be to rent an additional table for our booth for the 3 days the exhibition hall was open. Bert Laws of BearingPoint (a local of Nashville) was kind enough to make a run to Costco and buy a table for us (yes, it was significantly less expensive to buy a table than to rent it). We ended up giving the table to the folks at the Dell booth next to ours at the end of the conference (it would have been too difficult to check with our baggage).
• Best Clueless travel story. As good interenet users, we used Google Maps to print driving directions for all the places we were going in the UK while we were there for the UKOUG (knowing that Chris's mobile account for his Blackberry wouldn't work there). I don't remember the last time I had to look at a map to get where I needed to go in the states. This didn't work too well in the UK, and we ended up getting hopelessly lost many times on the trip. We ended up buying a map to help us make it through the trip.

2007 - The Year Ahead
The coming year looks to be an exciting one as well. With the success of the conferences we attended last year, we're signed up for lots of conferences this year as well. Although the sessions haven't been formally approved for these conference, expect to see us at:

• 2007 Northern California Training Day
• 2007 Alliance Conference
• 2007 EMEA Conference
• 2007 Collaborate
• 2007 Open World

From an engineering perspective, we've got two new products that we're partnering with customers to build in the first half of the year:

• nVision Bolt-on. This will address most of the outstanding nVision issues that we had hoped to address while we were still at PeopleSoft.
• Workflow Notifications. This is a product requested by a long-time Higher Education customer who saw our email notification functionality in our report distribution product, and are currently grappling with the best way to deploy workflow with eProcurement and HCM applications.

We also have plans to add some new features to our existing products, so if you've already licensed something from us, you'll probably hear from us soon.

Labels: 2006, Events, nVision, PeopleCode, PeopleSoft, Reporting, Security, User

For those who were interested in downloading the powerpoint to the presentation Chris gave, here it is.

It contains the tips he gave in the following areas:

• Drilling Into Application Designer
• Security Drilling / Portal Administration Drilling
• Dynamic Tracing or Row Level Security
• Enhancing PeopleSoft User Experience
• Automating "Save As" Processing

Update: here are the code snippets from my demo. As mentioned in the presentation, these are PeopleTools 8.4 projects that you can import into your environment.

Labels: 2006, Events, Security

For those who were interested in downloading the powerpoint to the presentation I gave, here it is.

It contains the tips I gave in the following areas:

• Drilling from and to PeopleSoft Reports
• Applying Data Security to PeopleSoft Reports
• Setting up reporting jobstreams in process scheduler
• Getting Context from numbers in nVision Reports

Labels: 2006, Drilling, Events, nVision

We survived Oracle OpenWorld 2006. A very long, but rewarding week. We originally planned to to blog the show as some other folks did. However, it was a little too hectic.

Our sessions turned out great, approximately 600 people attended each session, so we got some great feedback and questions from people (so look for some good new blog entries coming up). For those of you that provided contact info for copies of some of our products, look for those coming your way next week.

It was amazing the difference between this year and last year. Last year, we were a company that was only several weeks old and we didn't have an official presence. This year we have several products with live and happy customers. We also presented two highly-attended and (we think) successful sessions. From a PeopleSoft customer perspective, it was obvious that Oracle had listened to the feedback from last year, and provided a lot more presentations focused on providing information needed by the PeopleSoft customers.

Out of all the customers we talked with, people were definitely a lot happier this year. Applications Unlimited is turning out to be a great hit.

Our Oracle Open World Kodak moment has to be the following:

It was the first day the exhibit hall was open, and we had spent much of
the previous day trying to iron out the kinks in our booth. 2 hours into
that morning, a PeopleSoft customer made a bee-line to our booth, and started
peppering us with questions, verifying features and pricing for one of our
products.

After about two minutes of talking with us, he paused and asked, "We're in
a hurry to get something put in for this. How long would it take for you
to generate an invoice?"

Needless to say, we got him an invoice. We subsequently helped him
install the product from the Starbucks next to Moscone Center (while he
was still here at the show), and now has it up and running in one of his
environments. The customer expects to put it into production
next week.

We definitely want to thank all of you that came to our sessions and to our booth. Special thanks go out to Jeff Robbins and David Bain for being our co-presenters. Thanks also go to Mike Ni and Nadia Bendjedou for their upfront work in having us as presenters. Finally, we wanted to thank Jake Abrams for helping out in our booth. Jake has more expertise in implementing our products than anyone else, so having him help answer questions at our booth was great.

And thanks to whoever planned out the evening event at the Cow Palace. That was fun (almost too fun - it was hard to work the next day).

Our only recommendation for Oracle next year is to do something better with the Meet The Experts sessions. We went to visit some of the folks that we used to work with and they were hidden off in the mezzanine level where customers couldn't easily find them.

Labels: 2006, Events

Well, it seems our sessions at Open World were so popular, that they're full. Our message: fear not!

Right now, the conference organizers are looking at alternatives, such as changing the room or scheduling repeat sessions. We talked a bit with them, and their suggestion was to tell customers who want get into these sessions should use the "notify me" link. This gives the conference planners an accurate count of the total number of people they need to accomodate.

We'll keep you posted as things develop.

Labels: 2006, Events

In addition to some various roadtrips coming up, Larry and I will be presenting at Oracle OpenWorld this year in the Applications Technology track.

Larry is co-presenting with Rich Halket of Oracle on PeopleSoft Reporting. Here's the particulars.

Session ID: S281460
Session Title: Advanced Reporting Techniques for PeopleSoft Enterprise
Session Description:

Come to this session to learn how to solve new problems with the reporting technology available to you. The session discusses techniques for improving the use and adoption of PS/Query and nVision, plus techniques for reducing the ongoing operational costs of reporting in your organization. You'll leave this session with a greater understanding of how to get more from your existing Oracle's PeopleSoft installation as you prepare for Oracle Fusion.

I'll be co-presenting with David Bain of Oracle on PeopleTools.

Session ID: S281435
Session Title: PeopleTools Advanced Tips and Techniques
Session Description:

This session teaches you how to take better advantage of your Oracle's PeopleSoft applications. The session covers tips that you can use to make your end-users' life easier (you'll be a hero when you return!). You'll also leave the session with some tips that will make your life as a developer easier. In fact, your attendance at this session alone will make you glad you came to Oracle OpenWorld.

The (tentative) schedule is that my session will be Wednesday, Oct. 25 at 2:30pm in room 2007 of Moscone West. Larry's session is Thursday, Oct. at 11am and is also in room 2007 of Moscone West.

That room has capacity of 300 people so if you're planning on attending, be sure to indicate so when you register. There were a lot of PeopleSoft sessions last year at OpenWorld that had huge lines of people that couldn't get in because of capacity problems. And Larry knows how to pack 'em in. We used to joke that the 3 biggest sessions at PeopleSoft Connect conferences were Dave Duffield or Craig Conway doing the intro keynote, the closing keynote (this ranged from Bill Clinton to Bill O'Reilly to Garry Kasparov, etc. ), and then Larry doing the reporting session. I think that Larry's record was 2000+ people in a single room one year.

Hopefully we'll see you there!

Labels: 2006, Events

Valleywag points to SAP employees spoofing Star Wars as "Darth Ellison vs Jedi ABAP". Too funny.

I wonder if those SAP employees remember the billboard wars and how they ended?

Labels: Events