A formula might
look like Year -1:Year, which would yield the previous year and the current year
(meaning it would result in 2006:2007 if run in the year 2007.) A similar formula,
Month-12:Month, would return the last 12 months based on the current month.
Now that the data source has been created, it??™s important to realize that it only
exists on the machine of the developer who has created it. The Dashboard Designer
application is running locally and in order for others to make use of data sources,
or any other objects created in Dashboard Designer, they these objects must be
published to the server. Individual objects can be published by right-clicking on
them in the Workspace Browser and choosing Publish, or all changed objects can
be published at once by clicking on the Publish All button on the Home ribbon.
When objects are published to the server, they are automatically versioned and
given a version number and a timestamp. Changes to the objects are tracked so that
comparisons between versions can be compared and designers can even roll back to
previous versions if necessary.
Creating a Scorecard
Generally, after creating a connection, the next step would be to create a set of KPIs.
While this is certainly possible, PerformancePoint Server can actually go immediately
to the creation of a scorecard and create KPIs on the fly. This is similar to the change
from Analysis Services 2000 to Analysis Services 2005; in AS2000, dimensions had
to be created before a cube could be built, but AS2005 allows for the creation of a
cube without first building the dimensions.
Pages:
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142