Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Isolated table Error

Hi,

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 .

Thanks,

Dinya

replied

Hi,

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.

Amit

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question