Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Add "defect_type= " to your set analysis statement. See below...
sum({$<source={'defect_yield_op_type_summary'},
defect_type= >}total_defects)
Thanks,
Dan
Add "defect_type= " to your set analysis statement. See below...
sum({$<source={'defect_yield_op_type_summary'},
defect_type= >}total_defects)
Thanks,
Dan
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