Linking Answer Product to Service Product
We have a Custom Object that linked to Service Product but we would like to find a way to do reporting that requires us to do a join between the service product table and the answer products table.
Essentially if I select a service product I want to know what answers are "linked" to that product. I know there is a linkage because when you update the Service Product table you see your changes reflected within the Answer Product selections.
I assume that the table "hier_menus" woudl allow me to do my linking but this table is not selectable from the Analytics Explorer. Anybody know how to link the Answer Table to the Service Product table? (Bottom Line)