Forum Stats

  • 3,874,256 Users
  • 2,266,715 Discussions
  • 7,911,787 Comments

Discussions

Passing prompt on unnecessary column

KSS
KSS Member Posts: 117
Hi ,

I have two table A and B. Joined on A.ClaimID=B.ClaimID in physical layer.

BMM: I have three tables, A_Dim and B_Dim and B_Fact .

in my report I am using columns from both tables. and I have filter on B.ClaimID....If user selects any claimID it is generating query like:

A.ClaimID=123 -----Why it is passing this filter to backend. In my report I just have B.ClaimID is prompted.
and B.CaimID=123

I agree passing ClaimID to both tables doesnt lead to any wrong results. But in my case seeing some performance issues, so can some help to find out why BI server is generating query like ?

Thanks!!
Tagged:

Answers

This discussion has been closed.