Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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.