Posted on Friday, 18th November 2011 by scaywood

Dumping Expenses to Excel and Filtering by year.

Being able to manipulate P6 data in Excel can sometimes be helpful. Here is a case where I copied expenses from Primavera P6 and pasted them into Excel to filter out a certain year’s data.

1. In the Expense view, type Ctrl A to select all

a. Right click and choose Copy

2. In Excel, right click and choose Paste

3. Select the top row containing the column titles, Row 1

a. Select the AZ funnel icon, then Filter

4. Select the Fiscal Year drop down arrow and select the year you would like to see data on:

5. Now data from only 2011 is selected:

Tags: CBA, Oracle, P6, Primavera, Project Scheduling, Training
Posted in P6, P6: Web, Project Management, Tips & Tricks, Training | Comments (0)

Posted on Thursday, 3rd November 2011 by pserafino

CBA Invites You to Oracle’s Virtual Summit: Driving Growth with Mission-Critical Enterprise PPM

Last year, close to 1,500 executives and professionals from around the world came together online to exchange ideas with peers and learn from Oracle Primavera experts about the value of Enterprise Project Portfolio Management. Don’t miss the 2011 Oracle Primavera Virtual Summit:

Driving Growth with Mission-Critical Enterprise PPM

Discover how Enterprise Project Portfolio Management can be used as a competitive advantage to drive growth and impact your organization’s financial performance.

CLICK HERE to register and view the agenda, or call 1-419-874-0800 and we will be glad to register you for the summit.

This year’s Primavera Virtual Summit will be held on November 17th from 10 a.m. EST to 5 p.m. EST and will provide a global forum for executives and professionals to network, exchange ideas, get answers and attend insightful live presentations about mission-critical Enterprise Project Portfolio Management.

The exceptional agenda features three tracks specifically designed to meet your needs:

1. Executive Track: Listen to Oracle executives discuss how Enterprise Project Portfolio Management is critical to your organization’s success and can drive growth and shareholder value.
2. Customer Track: Hear from leading organizations as they share their successes with Enterprise Project Portfolio Management.
3. Solutions Track: Join Oracle’s Primavera Product Strategy team as they discuss current solutions, new releases and the future of Oracle Primavera.

Don’t miss out on the chance to interact with EPPM executives and experts, network with your peers and gain the knowledge you need in this free online event that you can attend right from the convenience of your desktop.

CLICK HERE to register and view the agenda, or call 1-419-874-0800.

Tags: Contract Management, Enterprise Project Portfolio Management, EPPM, Oracle, P3, P6, Primavera, Primavera Virtual Summit, Risk, Scheduling, SureTrak
Posted in Contract Management, P6, P6: Web, Project Management, Project Services, Risk Management, Tips & Tricks, Training, Uncategorized | Comments (0)

Posted on Wednesday, 19th October 2011 by scaywood

Wouldn’t it be nice if in P6 you could add coding to expenses? Expense can become a jumbled mess in the Expense view. Being able to sort through the mess can be difficult because grouping and sorting are limited. Many times I have wanted to separate my expenses by year to bring some sort of order to the mess. Finally, I came across a work around that would help me through this issue.

Here is my solution:
Create a UDF (User Defined Field) for Expenses called Fiscal Year.
1. Select Enterprise, User Defined Fields…

2. Select Project Expenses from the drop down arrow

a. Click “Add” on the right hand side
b. Title the UDF “Fiscal Year”
c. Choose “Text” as the Data Type
d. Close the window

3. From the Expense view add a column:

4. Add the appropriate fiscal year designation for each expense.
5. Finally, to sort, click the column header titled Fiscal Year to sort your expenses.

Tags: CBA, Oracle, P6, Primavera, Project Management, Project Scheduling, Training
Posted in P6, P6: Web, Project Management, Tips & Tricks, Training | Comments (0)

Posted on Monday, 10th October 2011 by pserafino

Sometimes as we go through our daily routines we lose sight of some of the little things that make life the great adventure that it is. One such experience happenened to a member of the CBA family Labor Day weekend as a result of a chance meeting at the Dayton Air Show courtesy of Sean D. Tucker world renowned stunt flyer and member of the Oracle Flight Team and Power Aerobatics.

CBA Sr. Account Executive Bob Searles and his son Matt, who has Cerebral Palsy, met Sean at the Dayton Air Show. Matt (12), who is determined not to let his physical challenges keep him down, has a passion for flying. His dream is to be a pilot someday. In order to prepare for that dream, he spends most of his free time on his computer perfecting his knowledge and skills as a pilot on flight simulator software. When Sean and Matt met in August at the Dayton Air Show, they hit it off immediately. Matt’s passion for flying and his admiration for Sean set the stage for an instant friendship between the two. Sean was so taken with Matt he offered to take him up in his airplane, one of the most high-performance aerobatic aircrafts in the world, the Oracle Challenger. It is a fire-breathing monster with over 400 horsepower, weighs just over 1200 pounds, and responds to the slightest pressure on the control stick even at 300 mph. Not only did Sean offer to take Matt for a ride… he offered to let him fly it. I could go on, but I’ll let this amazing youtube video of what happened next speak for itself:

As you can see, the experience only stoked Matt’s love of flying. We are greatful to Sean and Oracle for providing Matt with a once in a lifetime ezperience. In honor of Matt’s flight and to help other like him realize their dream, we will donate $100 in Matt’s honor to the United Cerebral Palsy Foundation (use offer code MATT11) for every order we receive for software or training through the about to be launched CBA Online Store in the month of October. If you want to place an order today before the Online Store goes live, please contact CBA Sales at 419-874-0800 and reference this article. The United Cerebral Palsy Foundation’s slogan is “Life without Limits” and Matt is certainly a shining example of that.

Congratulations Matt for making your dreams come alive and thank you Sean for making it happen.

Tags: CBA, Oracle, Power Aerobatics, Primavera, Sean D. Tucker
Posted in Contract Management, P6, P6: Web, Project Management, Project Services, Risk Management, Tips & Tricks, Training, Uncategorized | Comments (0)

Posted on Tuesday, 13th September 2011 by mbobby

How to turn the P6 XER Import “Blues” to Pure “Rock n Roll”
If you are like most P6 users, you have tried to import subcontractor or owner P6 XER files into your database and corrupted your Global data. As we all have learned, global data assigned to an XER schedule will populate your database global data upon import. For users who import XER’s on a regular basis a standard practice has been to first import the XER into a sandbox database. There in the sandbox database the Global data can be modified as required prior to importing the XER into your production database. For those who have tried this I am sure you would agree that it is a slow and tedious process. UG! But there is a better way!!!!
A new software application called Xena is now available to easily manage the global data of the incoming XER schedule prior to importing into your production database. With the Xena tool you have the options to:
Assign a prefix to Global Codes, Activity Code Values, Calendars, Resources, UDF’s, and Notebooks so that they are segregated in your global structure upon import
Rename Global Codes, Activity Code Values, Calendars, UDF’s, Notebooks, Unit of Measure.
Reduce status of Activity Codes from Global to Project level
Delete Global Codes, Activity Code Values, Calendars, Resources, UDF’s, Notebooks, Unit of Measure.
So….how is Xena used. Take the XER you want to import into the production database and import it into the Xena tool. Modify all global data with the options listed above. Save all modification procedures as a Xena template so the next time you import an updated XER the template will remember the set up for handling global data. Export the Xena revised XER file and import it into your production database. Xena also includes a tool that allows you to quickly de-status projects or to remove data such as financials prior to exporting to a sub or owner.
Feel free to contact CBA if you have any questions about the Xena tool.

Posted in Uncategorized | Comments (0)

Posted on Friday, 26th August 2011 by pserafino

The iPhone application for P6 Team Members is now available for download on iTunes App store!

This is an exciting milestone for the Mobile Project Team.  Currently the app is supported on iPhone, iPad, and iPod Touch. iOS 4.3.   Oracle Development is actively working to support iOS 4+ in the coming weeks for those users that have older version of the OS. Additionally, iOS 5 has been officially released. Also of note, support for the the Verizon iPhone will be available shortly.

The Team Member app lets users:

• Email changes to update P6 projects
• Filter list of tasks
• Send email to request tasks
• View assigned tasks by project
• Easily mark a task complete
• Update time spent, time left & dates
• Receive confirmation message for updates

Please contact CBA your Oracle Primavera Specialized Partner for additional information and a demonstration of what P6 can do for your organization.

Tags: Apple, CBA, iTunes, Mobile, Oracle, P6, Primavera, Project Management, Project Scheduling, Team Member
Posted in P6, P6: Web, Project Management, Project Services, Tips & Tricks, Training, Uncategorized | Comments (0)

Posted on Thursday, 18th August 2011 by scaywood

Problem:

P6 v7 Does NOT Increment Activity ID based on Selected Activities.

When copying and pasting activities, there is a new option for incrementing the Activity ID of the new activity based on the selected activity that you are copying. However, this new functionality does not work properly. See example below.

Data set:

Before beginning this example let’s make sure there is no UGR73510.

Search the Activity ID column:

Now, let’s Copy and Paste UGR73500.

Copy & Paste Dialog Boxes:

Based on our Increment Value of 10, our expected result should be UGR73510.

Result:

However, our new Activity ID is UGR90390. This incremental uncertainty is something to take into consideration when copying and pasting in P6.

Posted in P6, P6: Web, Project Management, Tips & Tricks | Comments (1)

Posted on Wednesday, 29th June 2011 by pserafino

One by-product of the Oracle acquisition of Primavera in 2008 is that now it is relatively easy to become an Oracle partner and sell Primavera products, however it is very difficult to become an Oracle SPECIALIZED Primavera Partner. This status means that you have provided the highest level of expertise and customer satisfaction in the industry today. Customer testimonials are an integral part of this process, so experience and competence matters. CBA is the only Specialized Primavera reseller based in Ohio and Michigan.

Since the 2008 acquisition of Primavera by Oracle we have seen many nameless faceless “groups” appear by virtue of the Oracle Open Market Model, which allows virtually anyone to become an Oracle software reseller. With Oracle’s excellence in marketing anyone can easily create a compelling website using their content. However the devil is in the details.For example we know of one “group” of one, who has proclaimed 12 years of experience (even though they have only been in existence for several weeks) while never having delivered the stated services or training to any company or organization. The website for this “group” contains not one single name of a principle owner, executive, salesperson, consultant, trainer, or implementation specialist although they boast to have a well-schooled team of people claiming those skills. However they do show stock photos of nice looking people in business dress that exist only in a photo shop somewhere. This “group” continues to claim experience in multiple verticals, however offer no customer success stories, references, or any other evidence that any company in any of the industries they list has ever done business with them. This “group” also claims to offer training and even has an inoperable link to a non-existent class schedule.

At CBA we are proud of our heritage of providing real value to real companies for 26 years. On our website you will find the names and bios of our ownership and management team, consultants and certified training professionals. We also offer real training classes with a real class schedule for all levels of Primavera training, for which you can really register. Why do sham companies like the one referenced above exist? It is because they try to make easy money selling software cheap to unsuspecting customers and then try to back-fill services through the independent consulting community. Because they don’t invest in their business the way real companies like CBA and our true peers in the industry such as Evans Technologies, DR McNatty and Associates and CDP have they can sell software at unsustainable margins. Unfortunately all you get is low-priced software. The faceless, nameless man behind the mask is not going to help you with maintenance or licensing issues, or help you to receive the support and training necessary to be successful. This is a very dangerous shell game because as any savvy project manager knows project management solutions are not “out of the box” ready products and qualified training and consulting specialists are hard to come by. Just like the wild west hucksters selling snake oil what they are really selling you is deception.

CBAcan lead you out of that wilderness. Only a company with the depth and breadth of knowledge that CBA possesses can offer you the lowest Total Cost of Operation for Primavera products via our Software Advantage Program. As an innovator in project management services and a Oracle Primavera Specialized Partner we have developed the CBA Software Advantage Program. For no additional cost when you purchase 5 or more Oracle Primavera software licenses from CBAwe will enroll you in the CBA Software Advantage Program. This program entitles you to up to 4 hours of product support and assistance from one of our senior consultants at no cost, a 15% discount for enrolling in any of our scheduled training classes conducted by one of our certified Primavera trainers, and a 15% discount on any additional professional services you may need for implementation and administration of your Primavera environment. This is our way of thanking you for your business and ensuring that you have the necessary help you need to make your project management initiative successful and affordable. Save yourself from the wild west of project management and make the prescient choice to call CBA. Please contact CBA for further details.

Tags: Consulting, Contract Management, Oracle, P6, Primavera, Professional Services, Project Management, Project Scheduling, Specialized, Training
Posted in Contract Management, P6, P6: Web, Project Management, Project Services, Risk Management, Tips & Tricks, Training, Uncategorized | Comments (0)