Getting the following error when filter is enabled while running report

[niahanth]

Hi,

I am getting the following error when i enable that filter while running the report.

SQL cannot be generated, because the filter condition could not be applied to the following fact stream which does not contain a fact projection : Table_Name

I am using relational model.
I have attached snapshot of error.

Thanks

[bus_pass_man]

The error message is trying to tell you that the query engine is trying to plan a query but there is a fact stream which doesn't have any facts in it and the filter is triggering a problem for the query engine.

The query engine thinks that any query subject which is the end node of a relationship path and is on the many end of a relationship is a fact table.  A query subject could be a fact table used in one context and part of a dimension in another context.  (that's the point of one of the tests in FM's model advisor).  This could be OK but it could be because a query item incorrectly has a usage of fact.

So it is generating a fact stream in a case where you might not want it to do so.

This suggests that some of the possible root causes of the problem include the cardinality of the relationship in question might be wrong or that the query subject in question isn't a fact table.

You will need to examine the SQL.   If you can't get it to generate try removing the filter. ( I don't know off the top of my head whether the query will generate without the filter but that's a start)  Look for the fact stream in question and determine whether it is a modeling problem.  Knowing how the objects in your query are related in the FM model would be useful.