We have discussed pivot grids in the past, but today I’d like to let you see how to create a simple pivot grid. If you are familiar with pivot tables in Excel, you will understand the functionality this reporting feature provides. By the end of the video, you should be able to create your own
Read More...While many of my blogs are about PeopleSoft and Business Intelligence, a personal passion of mine is support of Juvenile Diabetes Research Foundation (JDRF). At age 6, my youngest daughter Lauren was diagnosed with Type 1 Diabetes, as soon as I realized, I started to research on how to reverse diabetes. It was a life
Read More...Being a combination business intelligence and PeopleSoft guy, I am always looking for enhancements to improve the end user experience and capability of embedding business intelligence into the business process. Here are some of the favorite enhancements I am most looking forward to evaluating in PeopleTools 8.53. Related Actions/Related Content Enhancement: The Related Actions Framework
Read More...ZD Net contributor Joe McKendrick wrote a great blog about three reasons to hate BI dashboards. His opinion is certainly one that I share, and many of the blogs I have written here in the past try to focus on how to avoid these pitfalls. McKendrick’s post can be found here. Essentially his three reasons are: Dashboards haven’t
Read More...Previously, we have discussed the real power of BI — making business decisions out of the oodles (that’s a technical term for a lot) of data within organizations), embedding BI into the business process and processing that data extremely quickly and efficiently. So, while we have talked about it and tried to explain the concepts and
Read More...We’re seeing this more and more: as Oracle’s OBIEE platform gains steam, many organizations are making the move to convert existing reports from Crystal, Actuate or Oracle Reports to BI Publisher. Report conversion can be a daunting task, not necessarily from the technology move, but moreso from simply understanding, cataloging and consolidating the current collection
Read More...In our previous video blog about XML Publisher we showed you the basics on how to get going with creating some simple queries and reports. In this video blog we show a few more tricks and tips to help take your reporting to the next level. We will highlight how to create charts within groupings,
Read More...In the release of PeopleTools 8.5, a new feature for Query Manager called Drilling URL was released. Drilling URL allow the query results to hyperlink or drill down into the source data. The query results page shows the results as “links” which can, depending on how the URLs are defined, allow the user to access
Read More...Many years ago I graduated from Michigan State University (in my slightly biased opinion one of the greatest institutions in the country). As a student I was fortunate enough to land the right job that afforded me to forge some great relationships within the campus. Over two summers I worked security in the dorm rooms
Read More...Have you heard of PeopleSoft Program Management? If not, you’re not alone. Program Management is one of the lesser known applications within the PeopleSoft footprint. However, when utilized in conjunction with PeopleSoft Project Costing, Program Management can provide organizations a tremendous amount of value by consolidating project information into one neat repository. Having all of
Read More...