Skip to content

HTTPS clone URL

Subversion checkout URL

You can clone with
or
.
Download ZIP
Fetching contributors…

Cannot retrieve contributors at this time

23 lines (17 sloc) 1.565 kB
# LOADS A SALESFORCE ACCOUNT DATA
CreateProject(name="Sales Analytics");
RememberProject(fileName="examples/sales/pid");
#UseProject(fileName="examples/sales/pid");
UseDateDimension(name="Created");
GenerateMaql(maqlFile="examples/sales/created.maql");
ExecuteMaql(maqlFile="examples/sales/created.maql");
UseDateDimension(name="Closed");
GenerateMaql(maqlFile="examples/sales/closed.maql");
ExecuteMaql(maqlFile="examples/sales/closed.maql");
UseDateDimension(name="Snapshot");
GenerateMaql(maqlFile="examples/sales/snapshot.maql");
ExecuteMaql(maqlFile="examples/sales/snapshot.maql");
UseSfdcSales(username="mh@gooddata.blank",password="8uEx6ddzkr",token="TClAQjzY2DbsucCCiNPXNvRx",accountConfigFile="examples/sales/account.xml",userConfigFile="examples/sales/user.xml",opportunityConfigFile="examples/sales/opportunity.xml",snapshotConfigFile="examples/sales/snapshot.xml",accountQuery="SELECT Id, Name, AnnualRevenue, Industry, NumberOfEmployees, BillingPostalCode, ShippingPostalCode, Type FROM Account", userQuery="SELECT Id, EmployeeNumber, FirstName, LastName, PostalCode, Department, Division, Username, UserType FROM User", opportunityQuery="SELECT Id, AccountId, OwnerId, CloseDate, CreatedDate, ForecastCategoryName, IsClosed, IsWon, LeadSource, Name, Probability, StageName, Type, Amount, ExpectedRevenue FROM Opportunity", snapshotQuery="SELECT Id, AccountId, OwnerId, Amount, ExpectedRevenue, Probability FROM Opportunity");
GenerateMaql(maqlFile="examples/sales/sales.maql");
ExecuteMaql(maqlFile="examples/sales/sales.maql");
TransferData();
Jump to Line
Something went wrong with that request. Please try again.