SYMPTOM:
When a security filter having any of the pass through functions such as ApplySimple or ApplyComparison in its definition is used on the intelligent cube reports, user gets the following error message:
Error message:
(Unknown functionFunction not available in DBMS. Invalid logical functions used in filter. Filter functions can only be Equal, And, Or and Not. Error in Process method of Component: AnalyticalEngineServer, Project XXXX, Job XXXX, Error Code = -2147212264.
CAUSE:
Pass-through functions such as ApplyComparison, ApplySimple etc can't be used on the reports based of an Intelligent Cube. Pass-through expressions in Strategy are intended to provide access to the special functions or syntactic constructs that are not standard in Strategy, but are provided by various Relational Database Management System (RDBMS) platforms.
When an Intelligent cube is created, the data is already retrieved from the database and the cube acts as data storage from which intelligent cube reports get the data from. When the pass-through function is passed to the cube, cube does not have the capability to process the function on itself as it is not a RDBMS and hence the error above is thrown.
ACTION:
If the security filter is to be used on the Intelligent cube reports, make sure that Pass-through functions are not used in its definition.
