Forum Discussion

bangsheadondesk's avatar
bangsheadondesk
Frequent Visitor
2 years ago

Limit Summarized Table Size

I need to count total and average program counts, both at the individual record level ([Opp Id]) and as a total group (all selected records from the 'Opportunity' table).   This requires a DISTINC...
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago
The final report will be primarily direct query from two sources (Snowflake and Salesforce),

There is no Direct Query connector to Salesforce.

 

Sounds like you might benefit from the Aggregation feature and from the Dual Storage mode on smaller dimension tables that support Direct Query.