topic Salesforce.com object relationships in QlikView https://community.qlik.com/t5/QlikView/Salesforce-com-object-relationships/m-p/299969#M707714 <HTML><HEAD></HEAD><BODY><DIV>Hello, </DIV><DIV>Is there anyone out there who has experience working with Saleforce.com (SFDC) data and Qlick View?&nbsp;&nbsp; I'll do my best at describing the issue here as Saleforce.com is new to me.&nbsp;&nbsp; I am having difficulty when I want to look at all of my company's campaigns and then show all of the leads that are related to the campaign; then add in opportunities etc after that.&nbsp; Based on how SFDC stores the data, or maybe better said, how the end user inputs data into SFDC, affects how I can see the data I am trying to get.&nbsp; For example, the SFDC Qlik View Demo that is out there, I used that script to bring in my data but I cannot see the leads that are associated to my campaigns, however when I do a data load with campaign being the 1st table loaded and then I bring in leads after that I can see some of my leads but other data is missing that was being displayed in the Qlik View SFDC demo app's way of bringing in the data.</DIV><DIV> </DIV><DIV>So, my question is, is there a known process for putting SFDC data together that will allow me to see all associations regardless of how the end user uses SFDC?&nbsp;&nbsp;&nbsp; I hope this make sense, thanks.&nbsp; Sean<BR clear="all" /></DIV></BODY></HTML> Mon, 20 Feb 2012 19:21:30 GMT 2012-02-20T19:21:30Z Salesforce.com object relationships https://community.qlik.com/t5/QlikView/Salesforce-com-object-relationships/m-p/299969#M707714 <HTML><HEAD></HEAD><BODY><DIV>Hello, </DIV><DIV>Is there anyone out there who has experience working with Saleforce.com (SFDC) data and Qlick View?&nbsp;&nbsp; I'll do my best at describing the issue here as Saleforce.com is new to me.&nbsp;&nbsp; I am having difficulty when I want to look at all of my company's campaigns and then show all of the leads that are related to the campaign; then add in opportunities etc after that.&nbsp; Based on how SFDC stores the data, or maybe better said, how the end user inputs data into SFDC, affects how I can see the data I am trying to get.&nbsp; For example, the SFDC Qlik View Demo that is out there, I used that script to bring in my data but I cannot see the leads that are associated to my campaigns, however when I do a data load with campaign being the 1st table loaded and then I bring in leads after that I can see some of my leads but other data is missing that was being displayed in the Qlik View SFDC demo app's way of bringing in the data.</DIV><DIV> </DIV><DIV>So, my question is, is there a known process for putting SFDC data together that will allow me to see all associations regardless of how the end user uses SFDC?&nbsp;&nbsp;&nbsp; I hope this make sense, thanks.&nbsp; Sean<BR clear="all" /></DIV></BODY></HTML> Mon, 20 Feb 2012 19:21:30 GMT https://community.qlik.com/t5/QlikView/Salesforce-com-object-relationships/m-p/299969#M707714 2012-02-20T19:21:30Z Salesforce.com object relationships https://community.qlik.com/t5/QlikView/Salesforce-com-object-relationships/m-p/299970#M707715 <HTML><HEAD></HEAD><BODY><P>If you pull all the data from each SFDC object individually (leads, campaigns, opportunities) and then link them normally in the QlikView data model, you should be able to see everything.&nbsp; The order of which you load the tables doesn't matter.</P><P></P><P>Unsure what you mean by "how the end user inputs data into SFDC".</P><P></P><P>Can you provide some more detail?</P><P></P><UL><LI>Are you using the QlikView SFDC connector or a third party connector?</LI><LI>What of SFDC org are you using? (enterprise, professional, etc)</LI><LI>Do you have sysadmin level API access, or is your login filtered by the SFDC security model?</LI></UL><P></P><P>Gary</P></BODY></HTML> Mon, 20 Feb 2012 20:07:23 GMT https://community.qlik.com/t5/QlikView/Salesforce-com-object-relationships/m-p/299970#M707715 garystrader 2012-02-20T20:07:23Z