ParameterMapping.PostFormula Property
Gets or sets the post formula expression of the parameter.
Namespace: Microsoft.PerformancePoint.Scorecards
Assembly: Microsoft.PerformancePoint.Scorecards.Client (in Microsoft.PerformancePoint.Scorecards.Client.dll)
Syntax
'Declaration
Public Property PostFormula As String
Get
Set
'Usage
Dim instance As ParameterMapping
Dim value As String
value = instance.PostFormula
instance.PostFormula = value
public string PostFormula { get; set; }
Property Value
Type: System.String
The post formula expression of the parameter.
Remarks
A post formula expression is a transformation that is applied to the values passed by a provider (filter or scorecard) to a consumer (report or scorecard). When a post-formula expression is present, the consumer receives the result of PostFormulaTransform(S, P), where S equals the set of parameter values from the provider and P equals the post-formula expression.
In PerformancePoint Services in Microsoft SharePoint Server 2010, two types of post-formula transforms are used: MDX and time intelligence.
An MDX post-formula expression is an MDX set expression template that generates an MDX expression to produce the transformed result. For example, the MDX post-formula expression "<<UniqueName>>.Children" returns the children of the parameter values that are passed to the consumer.
A time intelligence post-formula expression defines how to transform a date or time into a set of members from a time dimension in a cube. For example, the time intelligence expression "Quarter-3: Quarter-1" returns a set specifying that the "Last 3 Quarters" be passed to the consumer.