Relations for Facts

Hi,

Can’t see how you mapped the source references in the relation. But the reason there are 4 is because some objects require four. A purchase order only requires 3 (order_no, line_no, rel_no). 

e.g. if you leave source_ref4 empty, it does fetch the state.

Please see the mapping. Are you suggesting I leave the mapping blank or I actually change the SQL? Thank you!!

Suggest to change the SQL expression to remove source_Ref4 and make it NULL and remove it from the mapping. But have not tested it :-).

RECEIPT_INFO_API.Get_State(RECEIPT_INFO_API.Get_Receipt_Sequence(:source_ref1,:source_ref2,:source_ref3,NULL,'PURCHASE_ORDER',:receipt_no))

I am going to go for it. I have notes here that say I need to publish this after I approve it. I right clicked and do not see anything for publish and of course there is nothing in help. Do you have any idea how to publish? 

After creation of a relation, you need to approve it (the checkbox in the header). After creating and approving a relation, you can add custom attributes to your fact. That one you also will need to approve & publish. Once you did that, you will need to click the ‘Refresh All’ button in the BR client to get the newly created attribute in your report.

Not sure if you seen this documentation. But this describes it in some detail;

https://docs.ifs.com/techdocs/Foundation1/040_administration/255_br_and_a/010_Information_Sources/055_custom_objects/010_Custom_Attr_Info_Src/040_custom_attr_fact.htm

Thank you this is really helpful.