Annoying publish to sharepoint thing

In the all up BI VPC there is a workflow when you publish a PPS dashboard to MOSS. Seen this?

Well…what you do is go to the dashboard aspx page in the doc library. click on the down arrow (edit), and "publish a major version". Then Approve it.

Spreading across Time

Unsupported through the excel interface. Problem is when you create an cycle – assignment, there is a concrete data collection period. You must enter data in that range AND you must enter data at the leaf level. one workaround is collect data for the year, and stick in a month in the future. For example you want to spread 12 months of data for 2008. You create a form and assignment and collect the data and put it in Jan FY09. Then you write a business rule and you scope the 12 months with the ":" operator and the this statement points to Jan FY09. then you can divide the number equally by 12. You can get more creative with your spreading algorithm too. The only thing, is you have to submit the JanFY09 number, and then run a job that runs the rule. So its a two step process.

Building member sets in PPS Planning

· Make sure that the value in your member Property exists as a dimension member

· The dimension member which is a parent does not have any value for the member Property

· Build the member set based on properties, Parent -> Name

This is an example.

Name                    Parent

1

11                           1

12                           1

2

20                           2

Remember: Member sets are for building models, Member views are for reports.

Business Rule Gotcha

When writing assignment business rules be sure to set the property "Reprocess after Execution" to TRUE. Otherwise you will not see the data.