projecting revenue using Excel or Analyzer

[MattLT]

What is the best approach to creating simple revenue
projections.

Adding revenue columns and running 'timephased data in
excel' does not provide the new columns for selection into
the report.

The portfolio analyzer does run custom outline codes but
those cannot be variable numeric data and must be selected
from a lookup table.

Your thoughts..?

Regards, Matt

 

[Gary Chefetz [MVP]]

Matt:

Firstly, understand that the outline codes become dimensions in the
portfolio analyzer, to add facts to the cube tables requires programming.
There are some articles that address this on MSDN.

Generally speaking, Project isn't a revenue tracker, but I've seen lots of
folks use it this way. The answer to your question depends on how you
project revenue. For instance, if your revenue projections are based on
hours worked, you could use a calculated field in an Analyzer view to
convert hours to revenue dollars.