FCCS MCP Agentic Server

Instructions

Implementation Reference

• fccs_agent/tools/data.py:38-77 (handler)

  The main handler function for smart_retrieve tool. Builds a 14-dimension grid definition with defaults and exports data slice from Consol cube.

  async def smart_retrieve(
      account: str,
      entity: str = "FCCS_Total Geography",
      period: str = "Jan",
      years: str = "FY24",
      scenario: str = "Actual",
      consolidation: str = "FCCS_Entity Total"
  ) -> dict[str, Any]:
      """Smart data retrieval with automatic 14-dimension handling / Recuperacao inteligente de dados.
  
      Args:
          account: The Account member (e.g., 'FCCS_Net Income').
          entity: The Entity member (default: 'FCCS_Total Geography').
          period: The Period member (default: 'Jan').
          years: The Years member (default: 'FY24').
          scenario: The Scenario member (default: 'Actual').
          consolidation: The Consolidation member (default: 'FCCS_Entity Total').
              Valid values: 'FCCS_Entity Input', 'FCCS_Entity Consolidation', 
              'FCCS_Entity Total', 'FCCS_Proportion', 'FCCS_Elimination', 'FCCS_Contribution'.
  
      Returns:
          dict: The retrieved data for the specified dimensions.
      """
      # Build grid definition with hardcoded defaults for 14 dimensions
      grid_definition = {
          "suppressMissingBlocks": True,
          "pov": {
              "members": [
                  [years], [scenario], ["FCCS_YTD"], [consolidation],
                  ["FCCS_Intercompany Top"], ["FCCS_Total Data Source"],
                  ["FCCS_Mvmts_Total"], [entity], ["Entity Currency"],
                  ["Total Custom 3"], ["Total Region"], ["Total Venturi Entity"],
                  ["Total Custom 4"]
              ]
          },
          "columns": [{"members": [[period]]}],
          "rows": [{"members": [[account]]}]
      }
      result = await _client.export_data_slice(_app_name, "Consol", grid_definition)
      return {"status": "success", "data": result}

• fccs_agent/tools/data.py:292-324 (schema)

  Input schema definition for the smart_retrieve tool within the TOOL_DEFINITIONS list.

  {
      "name": "smart_retrieve",
      "description": "Smart data retrieval with automatic 14-dimension handling / Recuperacao inteligente",
      "inputSchema": {
          "type": "object",
          "properties": {
              "account": {
                  "type": "string",
                  "description": "The Account member (e.g., 'FCCS_Net Income')",
              },
              "entity": {
                  "type": "string",
                  "description": "The Entity member (default: 'FCCS_Total Geography')",
              },
              "period": {
                  "type": "string",
                  "description": "The Period member (default: 'Jan')",
              },
              "years": {
                  "type": "string",
                  "description": "The Years member (default: 'FY24')",
              },
              "scenario": {
                  "type": "string",
                  "description": "The Scenario member (default: 'Actual')",
              },
              "consolidation": {
                  "type": "string",
                  "description": "The Consolidation member (default: 'FCCS_Entity Total'). Valid values: 'FCCS_Entity Input', 'FCCS_Entity Consolidation', 'FCCS_Entity Total', 'FCCS_Proportion', 'FCCS_Elimination', 'FCCS_Contribution'.",
              },
          },
          "required": ["account"],
      },

• fccs_agent/agent.py:160-160 (registration)

  Registration of the smart_retrieve handler in the TOOL_HANDLERS dictionary.

  "smart_retrieve": data.smart_retrieve,