Passing prompt on unnecessary column

KSS

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!!

KSS

Experts, any thoughts on this ?

SaichandVaranasi

Hi KSS,

To get rid of passing value use below formula for A.ClaimID in prompt -->

case when 1=1 then a.ClaimID end (dont forget to change in filter section column formula) and post your results here!


Thanks,
Saichand

KSS

Hi Saichand,

I tried this but no luck

here is the SQL generated by bi server:

case when 1 = 1 then T116958.CLAIM_ID end = 1540 and case when 1 = 1 then T116981.CLAIM_ID end = 1540

Thanks!!

SaichandVaranasi

Hi KSS,

Ok,Pull only Claim ID and filter the values by creating new anlaysis something is going wrong with your report do you have filter based request?

Thanks -