Skip to main content

Hi Guys, 

I have a general question, I think I understand pull up functions wrong. So i need to use one to filter my olap tabel but the result is not as expected.

In general i thought, if I use an olap tabel with one dimension X from Tabel A, Count(A.Y) is the same like PU_COUNT(Domain_Table(A.X), A.Y)?

 

So I use the NAST tabel grouped by NAST.OBJKY and count the NAST.VSTAT. Now I want a second olap table which contains only entries with COUNT(VSTAT) > 2 and use the function PU_COUNT(Domain_Tabel(NAST.OBJKY), NAST.VSTAT) as componant filter, but it doesnt work right. Where is my mistake?

 

Thanks!

Hi there can you try the following:

FILTER NAST.OBJKY IN (CASE WHEN PU_COUNT(DOMAIN_TABLE(NAST.OBJKY), NAST.VSTAT) > 2 THEN NAST.OBJKY END);

Reply