Framework:RuleFilter

Function

RuleFilter(Table Name,Column Name,[Criteria 1 - Criteria N]);

Cascading Filter: This function offers a further possibility to control filter in a table.
Please enter in property "SpecialDefinition" of the dimension.

Parameter	Description
Table name	Name of the table
Column Name	Name of the column in the table
Criteria	Expression to be used

It is also possible to access directly over a SQL statement to the SQL server

RuleFilter(SqlQuery,Connection String,Bedingung);

Parameter	Description
SqlQuery	constant for the SQL statement
Connection String	Name of the SQL Connection (Stage, SystemDB, individual connection)
Condition	SQL statement

Using this statement RuleFilter(SqlQueryWithOrder,Connection String, Bedingung); you can sort by the SQL query

This function belongs to client-side functions.

Result

Displays the selected column of a specific table, which are assigned to one or more criteria.

Example

RuleFilter(Umsatzerloese_PLAN,Zeit,Produkte=[Produkte.ID]);

Entered in "SpecialDefinition" of the dimension "Zeit". The dimension "Zeit" displays only products which are assigned to the selected time.

The RuleFilter is available in Row view, Input mask and Single row mask.

Important: The expression mustn't contain space characters.