Skip to content

forcedotcom/sf-skills / skills/crm-analytics-wave-generate

crm-analytics-wave-generate

Verified

Use to build a Wave Recipe, deploy a CRM Analytics dataset or dashboard, or author the full CRMA asset stack — apps, Wave Recipes (.wdpr), datasets, and dashboards — against a connected Salesforce org via REST and Metadata APIs, without CRM Analytics Studio or Dashboard Builder. TRIGGER when: user asks to build or create a Wave Recipe, generate a .wdpr or .wdpr-meta.xml, deploy a .wdash or .wapp, run a recipe or dataflowjob programmatically, upload CSV data via InsightsExternalData, validate a dataset schema with synthetic data, fetch dataset XMD, audit dashboard SAQL re-encoding, or find unused dataset fields. TRIGGER on keywords: Wave Recipe, CRMA, CRM Analytics, wdpr, wdash, wapp, WaveRecipe, Wave dataflow, dataflowjob, InsightsExternalData, SAQL, dataset XMD, Analytics Studio, R3 format, wave/recipes, wave/dashboards, or analytics on Salesforce objects (opportunities, leads, cases, accounts, sales). DO NOT TRIGGER for standard Salesforce reports or LWC components unrelated to CRM Analytics.

examples/wdpr-skeleton.wdpr

View on GitHub
{
  "runMode": "full",
  "nodes": {
    "LOAD_OPP": {
      "action": "load",
      "sources": [],
      "parameters": {
        "dataset": { "type": "connectedDataset", "label": "Opportunity", "connectionName": "SFDC_LOCAL", "sourceObjectName": "Opportunity" },
        "fields": ["Id", "Amount", "CloseDate", "StageName"],
        "mode": "SYNCED",
        "preserveCurrencyFields": [],
        "sampleDetails": { "type": "TopN", "sortBy": [] }
      }
    },
    "COMPUTE_YEAR": {
      "action": "formula",
      "sources": ["LOAD_OPP"],
      "parameters": {
        "expressionType": "SQL",
        "fields": [{ "name": "CloseYear", "label": "Close Year", "type": "TEXT", "formulaExpression": "date_format(CloseDate, 'yyyy')" }]
      }
    },
    "EXTRACT0": {
      "action": "extractGrains",
      "sources": ["COMPUTE_YEAR"],
      "parameters": { "grainExtractions": [] }
    },
    "AGG0": {
      "action": "aggregate",
      "sources": ["EXTRACT0"],
      "parameters": {
        "aggregations": [{ "name": "TotalAmount", "label": "Total Amount", "action": "SUM", "source": "Amount" }],
        "groupings": ["StageName"],
        "nodeType": "STANDARD",
        "pivots": []
      }
    },
    "OUTPUT": {
      "action": "save",
      "sources": ["AGG0"],
      "parameters": {
        "dataset": { "type": "analyticsDataset", "label": "DTS_Opportunity", "name": "DTS_Opportunity", "folderName": "MyApp" },
        "fields": [],
        "measuresToCurrencies": []
      }
    }
  },
  "ui": {
    "nodes": {
      "LOAD_OPP":    { "label": "Opportunity", "type": "LOAD_DATASET", "top": 112, "left": 112, "parameters": { "sampleSize": 2000 } },
      "TRANSFORM0":  { "label": "TRANSFORM0",  "type": "TRANSFORM",    "top": 112, "left": 252, "graph": { "COMPUTE_YEAR": { "parameters": { "type": "BASE_FORMULA_UI" } } }, "connectors": [] },
      "AGGREGATE0":  { "label": "AGGREGATE0",  "type": "AGGREGATE",    "top": 112, "left": 392, "graph": { "EXTRACT0": null, "AGG0": null }, "connectors": [{ "source": "EXTRACT0", "target": "AGG0" }] },
      "OUTPUT":      { "label": "Output",      "type": "OUTPUT",       "top": 112, "left": 532 }
    },
    "connectors": [
      { "source": "LOAD_OPP",   "target": "TRANSFORM0" },
      { "source": "TRANSFORM0", "target": "AGGREGATE0" },
      { "source": "AGGREGATE0", "target": "OUTPUT" }
    ],
    "hiddenColumns": []
  }
}
rea-analysis-optimizationmorluto/reaOptimize REA providers and shared analysis workflows for agent context, latency, CPU, and memory while preserving correctness and Evidence. Use for analysis bottlenecks and cache or query design; CI/test-suite optimization belongs to rea-ci-tests-audit.Stars: 472kUpdated Claude CodeCodexVerifiedInstall
rea-ci-tests-auditmorluto/reaAudit REA CI and test suites for correctness, fixture drift, false passes, and measured performance; use for suite or workflow investigations and efficiency changes, rather than ordinary feature testing or a single test failure.Stars: 472kUpdated Claude CodeCodexVerifiedInstall
rea-tool-designmorluto/reaAudit, investigate, design, or change REA investigation tools, CLI/MCP contracts, provider capabilities, and Evidence semantics.Stars: 472kUpdated Claude CodeCodexVerifiedInstall
ponytail-auditDietrichGebert/ponytailQuality audit of the whole repo: bugs, security, real load, missing tests, speed, and what to delete. Most important first.Stars: 194kUpdated Claude CodeCodexVerifiedInstall