RecalcularIndicadors

Execute the PostgreSQL function vimep.calculmesactiu_v3 to recalculate VIMEP indicators.

Updated Aug 27, 2026

Search Tags:#postgresql #data validation #etl #indicators #recalculation #vimep

Ready to run

npx skills add https://github.com/danielprats/01_03_VIMEP --skill recalcularindicadors

💬 Prompt for ChatGPT / Claude Chat▼

Please help me install this Agent Skill.
Skill: RecalcularIndicadors
Source: https://github.com/danielprats/01_03_VIMEP/tree/main/AssistentIA/_skills/RecalcularIndicadors
Command: npx skills add https://github.com/danielprats/01_03_VIMEP --skill recalcularindicadors

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires sqlalchemy, python-dotenv, psycopg2-binary, and includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill automates the recalculation of VIMEP indicators, ensuring data accuracy after updates or fixes, and streamlining validation processes.

Core Features & Use Cases

Flexible Recalculation: Recalculate specific indicators for single or multiple periods, or for all assets.
Error Correction: Easily re-run calculations after SQL fixes or data updates.
Use Case: After a bug fix in the calculmesactiu_v2 PostgreSQL function, use this Skill to quickly recalculate all affected indicators for a specific month and asset to verify the fix.

Quick Start

Recalculate the EVE indicators for October 2025 in the PRE environment.

Frequently Asked Questions about RecalcularIndicadors

High-intent search queries and answers about installing and using this skill.

FAQPage Schema

How do I recalculate VIMEP indicators in PostgreSQL after a data update?▼

You recalculate VIMEP indicators by executing the PostgreSQL function `vimep.calculmesactiu_v3` via a command-line interface. This allows recalculating specific assets or all assets across single or multiple periods in AAMM format.

What is the best way to re-run calculations for specific periods after an SQL fix?▼

The best way to re-run calculations after an SQL fix is using a command-line tool that triggers the `vimep.calculmesactiu_v3` function. It includes parameter validation and detailed execution summaries to verify your fixes quickly.

Can I execute indicator recalculation across different deployment environments like PRE and PRO?▼

Yes, you can execute indicator recalculation across different deployment environments. The interface supports DVP, PRE, and PRO environments, allowing you to validate calculations accurately before deploying to production.

Does this recalculation tool support validating multiple periods at once?▼

Yes, the recalculation tool supports validating multiple periods at once. You can specify multiple periods in AAMM format to recalculate VIMEP indicators for specific assets or across all assets efficiently.

Why do I need parameter validation when recalculating database indicators?▼

Parameter validation is needed when recalculating database indicators to prevent execution errors and ensure data accuracy. It automatically validates inputs before executing the PostgreSQL function and logs the detailed execution summary.