Isolated table Error
Could you please help me to root cause the problem of the error in we bi report as iam experiencing this for the first. Looks like me its a database error
I have two data provider with one as delhi class and other as mumbai class belong to same universe but no joins at the design as it is isolated table.
I want to merge prompts and webi common dimension for my reqd of the report .
Amit Kumar replied
not sure about the exact cause.Sometimes back i saw one thread where issue was with non equi joins.Similar to your condition where excluding 0.
One more thing you can try to instead of putting webi query filter (Cust.Show)<>0,apply this filter at webi report/table level and exclude the zeros from there.
I don't think so issue with ((ProjHistory.Action=''Booked'') condition.but again you can try this.removing from derived table put the condition at webi query level filter.Also again put the condition at webi report/table level and compare.
See if there is a difference.