Common parameters

There are three common Parameter settings for a function object:

• Distinct: is a TRUE/FALSE parameter that allows you to use all values or only the unique values in the calculation.

• Fact ID: forces the calculation to take place on a fact table containing the Fact_ID.

• NULL: is a TRUE/FALSE parameter that determines if the NULL value can be used in the calculation.

Not all these settings apply to every function. In general, all group-value functions display the FactID Parameter setting. OLAP functions do not have any of these Parameter settings, but they may have BreakBy or SortBy parameters.