need help related to set analysis...

[sushil353]

Hi Experts,

In my application i have concat 3 fact tables and there are 3 dimension table in association..

fact tables are 1. defect_yield_op_type_summary

                       2. measurement_summary

                       3. op_defect_summary

and dimensions are location,time,defect_type

all the field in first two fact tables are same but there is a difference in one field in third fact table (defect_type)

now i have created a straight table in which location is dimension and expressions are as follows

sum({<source={'defect_yield_op_type_summary'}>} total_defects) and sum({<source={'op_defect_summary'}>} total_defects)

I have attached my sample application which is very easy to understand

My problem is whenever i select defect type to ndf or ndr data for first expression become zero....

I need a expression such that expression one should have no effect when i select ndf or ndr

Please help me out ... this problem sucked my whole day..

Thanks

[dwh1104 · Accepted solution]

Add "defect_type= " to your set analysis statement.  See below...

sum({$<source={'defect_yield_op_type_summary'},

defect_type= >}total_defects)

Thanks,

Dan

[#3]

Hi Sushil,

In you application it seems the relation between the fact_table_summary and defect_type is not properly set.

I have attached a screenshot to show this fact.

In there I have used a table box to find the relation between defect_type and Source='defect_yield_op_type_summary'.

Hence that is why your results shows zero for defect_op_yield_summary field in the straight table.

Should you have further queries please feel free to ask.

Thanks,

Bikash Debnath