A friend reached out to me this week with a new wrinkle in report R_SB_09 where the date format in the received column was wrong. Instead of 10/28/2012 appearing it was showing up as 28/10/2012. My first inkling was to look at the presentation or layout side of the report and look at date format. Much to my surprise, there wasn’t any formatting. Hmm, must be an issue with the data model? Sure enough, when I edited the data model and looked at data, received was 28/10/2012 and sent right next to it was 10/28/2012. Suspicion confirmed! The data model contained the following: CONVERT(nvarchar(30),SBMT.LATEST_RECVD_DATE,103) as LATEST_RECVD_DATE, CONVERT(nvarchar(30),SBMT.LATEST_SENT_DATE,101) as LATEST_SENT_DATE, First thing I noticed was converting the date being part of the syntax rather than just pulling the date and the one I liked (Sent) had a 101 and the other (Received) had a 103 in the variables. Simple solution! Change the 103 to 101. I did and it worked but why? Turns out 103 is British formatting and 101 is English, but there are many more choices available. Google “Oracle SQL Convert 101” to learn more.

read more

At the time PCM 14.0 BIPE was released many in the PCM community were excited to hear of the retirement of InfoMaker, but at the same time dismayed to hear there was no ‘upgrade’ or ‘conversion’ from their extensively customized libraries. I have started my own personal journey to being equally comfortable with BI Publisher. And it looks like it will be a long journey.

Aligning with the Oracle Toolset — With the acquisition of Primavera by Oracle in 2009, many of Oracle’s other products are being introduced into the applications Primavera P6 Enterprise Project Portfolio Management and Primavera Contract Management. The default database server, application server, content repository and reporting tool have been replaced with Oracle owned products such as Oracle Server, WebLogic, Enterprise Content Management and BI Publisher. Additionally, the introduction of Business Process Management, User Productivity Kit, Fusion Middleware and BI Enterprise Edition into the Primavera applications further extends the power and availability of your work product, allowing for improved communication and enhanced telephone answering capabilities within project management workflows.

BI Publisher Resources — Many great resources are available for BI Publisher. The most important resources are the product documentation and Oracle’s support team. This will help with the proper installation and integration of BI Publisher with Primavera Contract Management. Failure to get this fundamental step completed accurately will make this journey all the more frustrating. Additional resources I have found valuable include the Oracle Blogs and Community pages, as well as content found on the BI Publisher YouTube channel. Although not geared to Primavera applications specifically, the BI Publisher Fundamentals training from Oracle University gives you a glimpse into the possibilities while giving some comfort with the tool.

“Practice makes Perfect” — With all the resources available, using the tool will be the best way to learn. Rebuilding the stock reports and forms gave me the comfort of using the tool and validation of how the pieces work together. I am not venturing into rebuilding some custom content that I have previously created in InfoMaker. In the near future I see working with the new template and output options available and seeing how they fit into Primavera Contract Management.

Conclusion — While sad to see my trusted friend InfoMaker disappear after a 15 year love-hate relationship, I see the power of BI Publisher being a great reason to embrace the future and this this tool. While this journey is nowhere near the end, I do see that I will continue to use the resources I have mentioned to make the travels a little less uncomfortable, even if that means circling back many times. Hope to see you on the road…

Collaborate12 — I will be presenting on this topic at Collaborate 12 in Las Vegas, NV. My presentation will be one of several on the topic of BI Publisher. Be sure to check out this conference.

read more