By Kevin Jobe on 11/11/2007 8:39 PM

• Cell a1 = ! dimension = dimension name
• Cell a2 = ! hierarchy = All Members
• Cell a3 = Label (value required)
• Cell b3 = Name (value required)
• Cell c3 = Description (value optional)

 Values in the Label and Name columns are required. Values in the Description column are optional, but the header is required in the template. 

Also, you can include other columns with headers and data. ... Read More »

By Kevin Jobe on 11/11/2007 8:19 PM

Best practice is to always use a domain account with the password set to never expire for the service identity account when installing PPS Planning.  These settings can be adjusted later, but can create unwanted problems that will be difficult to discover.  When the account designated as the service account has a password expiration, the information is not propagated through PPS and this account can no longer run services.

This is an installation level setting, so it is wise to understand the nature of this account and plan accordingly.  All applications created within your installation will be dependent on this account.

By Kevin Jobe on 10/18/2007 10:33 PM

• Windows Server 2003 Standard, SP1 (XP pro, SP2 for the client)
• SQL Server 2005 Enterprise, SP2 (you will also want the client tools)
• IIS 6.0
• .Net 2.0 Framework
• ASP.NET 2.0
• Client only- MS Office (Excel) 2003, SP2, but 2007 is much better

PPS Monitoring and Analytics is more involved, requiring MOSS (Sharepoint Services) and even components of .NET 3.0.  Will get into that soon..