I tried connecting to a Salesforce accnt and when pulled data into Qlikview appln..it said "Out of Memory". This is because the tables i include join themselves internally on some fields that i m not interested. I tried resolving this using aliases, but could not succeed in this.
Also when i tried using filters to lessen my number of records being pulled, it throwed "Custom SQL Failed". I would like to know, is there any way to create aliases to the fields when we pull data from Salesforce and also is there a possibility to have filters ("Where Clause") in my script where i pull the data.
In that case what you can try is storing the tables into QVD files.
Please follow the steps as per the below:
Tab1:
Load * from table1 ;
Store Tab1 into Tab1.qvd;
Drop Table Tab1;
Tab2:
Load * from table2 ;
Store Tab2 into Tab2.qvd;
Drop Table Tab2;
Extract ll the tables you required into QVD's and then now you use these QVD's in your dashboard application to reload the data and use what ever the aliases, mapping and all.
