Read the rest of this entry »

My friend Peter showed me a very cool method of creating a graph or chart that lets you scroll through the time periods (or your x-axis) using a scroll bar. It involves setting up a few defined ranges containing formulas and using a scroll bar to control the starting point of your x-axis. You configure your graph to use named ranges as the sources for your data series. These ranges contain formulas.

Read the rest of this entry »

Automated Testing

The lure of automated testing in software design is obvious if you’ve ever done any testing. With automated tools, you can create dozens of test scenarios and run them as many times as required by basically just pushing a button (as long as you’ve set everything up right ). A good tool will document the results of each step of the test, frequently with screen captures. What would have taken hours or days can occur in minutes or less, or even be scheduled to run at night and be waiting in your inbox the next morning.

Read the rest of this entry »

Attention SAP Accountants! There is one thing that SAP does not do very well - maybe you can think of more than one . But if you’ve spent any time trying to manually enter a long Journal Entry in FB50 or F-02 (etc), you know that SAP is woefully lacking in the ability to upload entries. UPDATE: This post is about ZOption’s excel upload solution. If you want to roll your own, I discuss our experience with the BAPI here.

Read the rest of this entry »

I don’t want to say that my life is now complete, but Apple has certainly made my month. I updated my MacBook Pro with the new version of Boot Camp, and now my Windows Vista installation is working perfectly!

Apple, yesterday, updated its beta of Boot Camp to include support for Windows Vista. Boot Camp allows you to install Windows XP and now Windows Vista on an Intel based Mac, including the MacBook and the MacBook Pro.

Read the rest of this entry »

Have you ever needed to give someone your phone number that you didn’t really want having your real #? Whatever the reason or situation, chances are good that you have.

NetZero has a solution. It’s easy to use and it’s FREE! Of course, they want you to upgrade to their premium service, but the free entry level deal is perfectly usable.

Read the rest of this entry »

What are SMART Goals:

• Specific
• Measurable
• Achievable
• Relevant
• Time-based

If you’re trying to get profit center hierarchies (as seen in T-code: KCH3 ) into BI-BW, there is help.

There are several discussions over at the SAP Developer Network talking about how to add Profit Center hierarchies to SAP BI-BW. This is something that we are going through with our system right now. So, we’re trying to find info to get us going.

Read the rest of this entry »