Google
 

Monday, September 29, 2008

Why aren't my input form cells turning yellow?

A colleague of mine offers this troubleshooting checklist when you just can't get the PerformancePoint Planning Excel Add-in to recognize input boxes in an assignment.

PerformancePoint Planning - Input Forms Checklist

  1. The current date is within the assignment start/end date/time
  2. The cells you are looking at are within the start and end periods for the assignment (that you selected from the time dimension)
  3. The scenario you are trying to input to is the scenario you selected for the cycle that the assignment is using
  4. You have a value selected for every dimension in the model (both filters, rows and columns) and that the value selected is at the leaf level
  5. The user you are logged on as has access to the model set to “On” in the summary view of the user’s role.
  6. That read/write access is enabled for all of the dimensions selected in the filters/rows/columns you selected above.
  7. The status of the assignment is listed as “started” or “partial”, not “Not Started” or “Submitted”, or something else.
  8. That the assignment is opened using the assignment list in the action pane or from the assignment search window.
  9. That the report property “Allow data entry” is set to true
  10. That you haven’t mistakenly changed the format of a data entry to a white background (this has happened).  Check this using the “Home” ribbon and going to cell styles.  Right click on the “PerformancePoint data entry cell” to modify if necessary.  This can be testing by trying to write to the cell –if you don’t get a “read-only” error you’re fine.

No comments: