Use EVALUATE_PREDICATE function as filter in an anlysis
Hi guys,
I'm struggling to get the proper syntax to use the EVALUATE_PREDICATE as a filter on a column in an OBIEE analysis.
I'm using an EVALUATE function to determine the rank of 'Test Naam' in the result set (CAST(EVALUATE('DENSE_RANK() OVER (PARTITION BY %2 ORDER BY %1)'AS INTEGER,"Test Definities"."Test Naam","Procestransformatie"."Procestransformatie Code") as DOUBLE)). This returns results for i.e. 12 tests. Now I want to split up this resultset into 3 sets of graphs on a dashboard (1-4, 5-8 and 9-12).
I cannot apply a regular filter on this column because it then returns an error message. Apparently the solution to avoid this error is to apply the EVALUTE_PREDICATE function as a filter. But I cannot get the proper syntax to work...
I hope someone can help me out. Thanks in advance!
Best Regards,
Jeroen