export_data_slice
Extract specific data grids from Oracle EPM Cloud FCCS for analysis or reporting by defining dimensions and slices.
Instructions
Export a specific data slice (grid) from the application / Exportar um slice de dados
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| cube_name | No | The name of the cube (default: 'Consol') | |
| grid_definition | Yes | The data grid definition with pov, columns, and rows |
Implementation Reference
- fccs_agent/tools/data.py:21-35 (handler)The main tool handler function that executes the export_data_slice logic by calling the FCCS client method.async def export_data_slice( grid_definition: dict[str, Any], cube_name: str = "Consol" ) -> dict[str, Any]: """Export a specific data slice (grid) from the application / Exportar um slice de dados. Args: grid_definition: The data grid definition with pov, columns, and rows. cube_name: The name of the cube (default: 'Consol'). Returns: dict: The exported data slice with rows and column values. """ result = await _client.export_data_slice(_app_name, cube_name, grid_definition) return {"status": "success", "data": result}
- fccs_agent/tools/data.py:143-160 (schema)The JSON schema defining the input parameters for the export_data_slice tool.{ "name": "export_data_slice", "description": "Export a specific data slice (grid) from the application / Exportar um slice de dados", "inputSchema": { "type": "object", "properties": { "cube_name": { "type": "string", "description": "The name of the cube (default: 'Consol')", }, "grid_definition": { "type": "object", "description": "The data grid definition with pov, columns, and rows", }, }, "required": ["grid_definition"], }, },
- fccs_agent/agent.py:123-127 (registration)Registration of the export_data_slice handler (and other data tools) in the central TOOL_HANDLERS dictionary used by the agent.# Data "export_data_slice": data.export_data_slice, "smart_retrieve": data.smart_retrieve, "copy_data": data.copy_data, "clear_data": data.clear_data,
- fccs_agent/agent.py:143-151 (registration)Inclusion of tool definitions from data.py (containing export_data_slice schema) into the agent's complete tool definitions list.ALL_TOOL_DEFINITIONS = ( application.TOOL_DEFINITIONS + jobs.TOOL_DEFINITIONS + dimensions.TOOL_DEFINITIONS + journals.TOOL_DEFINITIONS + data.TOOL_DEFINITIONS + reports.TOOL_DEFINITIONS + consolidation.TOOL_DEFINITIONS + memo.TOOL_DEFINITIONS
- The underlying FccsClient method that performs the HTTP request to the FCCS API for exporting the data slice.async def export_data_slice( self, app_name: str, cube_name: str, grid_definition: dict[str, Any] ) -> dict[str, Any]: """Export data slice / Exportar fatia de dados.""" if self.config.fccs_mock_mode: return MOCK_DATA_SLICE db_name = cube_name or "Consol" payload = {"gridDefinition": grid_definition} response = await self._client.post( f"/{app_name}/plantypes/{db_name}/exportdataslice{self._get_query_params()}", json=payload ) response.raise_for_status() return response.json()