johnfelipe

Updating f66e6dbb0..9693fa096
Fast-forward
 .github/workflows/gh-pages.yml                     |     4 +-
 .github/workflows/plantuml.yml                     |     2 +-
 .github/workflows/release-1-create-pr.yml          |     2 +-
 .github/workflows/release-3-master-into-dev.yml    |     4 +-
 .github/workflows/test-helm-chart.yml              |     2 +-
 Dockerfile.integration-tests-debian                |     2 +-
 Dockerfile.nginx-alpine                            |     2 +-
 Dockerfile.nginx-debian                            |     2 +-

johnfelipe

Ultimate Resource List

• CLI Tools
• GUI Tools
• Web Tools
• Systems/Services
• Networks
• Containers/Orchestration
• Manuals/Howtos/Tutorials

johnfelipe

VIDEO5: https://drive.google.com/drive/folders/1DgDwK-dNztL2EpPvlW0ezaFSkqpQhkq0?usp=sharing

Based on the transcript provided, here is a list of Power BI tasks mentioned, along with their corresponding start timecodes:

1. [00:00:05] Share the updated Power BI report link in the chat.

2. [00:00:56] Configure commas in the amount format for the current portfolio section.

3. [00:01:19] Configure the expected long-term profitability and associated volatility for the current portfolio.

johnfelipe

VIDEO4: https://drive.google.com/drive/folders/1tkGC2GRlNblgTXU4orkG0oX8OydOk6Sj?usp=sharing

Based on the transcript provided, here is a list of Power BI related tasks with their corresponding start timecodes:

1. [00:01:58] Share the Power BI screen to show the dashboard under construction.

2. [00:02:03] Explain that the current portfolio part is empty, while the reference portfolio has a list of customer groups and customers. Demonstrate the ability to filter customers by typing 3-4 characters.

3. [00:06:26] Investigate why the asset type values in the chart are displaying in an incorrect format (e.g. 8.63.42.88.218). The values should be in millions.

johnfelipe

VIDEO3: https://drive.google.com/drive/folders/15tX5bhBzpOq_ozHo_3E7m6IA2QV4kEdi?usp=sharing

Based on the transcript provided, here is a list of Power BI tasks with their corresponding start timecodes:

1. [00:04:21] Change the current portfolio and reference portfolio headings to have the first letter capitalized (e.g. "Current Portfolio", "Reference Portfolio").

2. [00:04:45] In the reference portfolio section, change the order to show active type first and then product below.

3. [00:06:48] Add a tilde to the "o" in "distribution" in the "Distribution by Type of Active" heading.

johnfelipe

VIDEO2: https://drive.google.com/drive/folders/1rOZupBc3S0UfjM7Hl3x1l3TXgoXgry3Q?usp=sharing

Based on the transcript, here are the detailed Power BI tasks extracted:

1. [00:01:41] Create a report section in the center that shows the reference portfolio. For the client view, paint the reference portfolio data, but without any amounts since it is not a real balance.

2. [00:03:18] When a group is selected, update the report to show the group level information instead of client information.

3. [00:11:40] For painting the group level current balance in the first query (portfolio-group), take the economic group field directly. The name logic is calculated the same way as for client - take fund name if it's from funds, take name if it's from titles, put current account in front if applicable.

johnfelipe

VIDEO 1: https://drive.google.com/drive/folders/14V4sITqByyge5T4iGgKPcuQuKOs4fBq3?usp=sharing

Based on the conversation in the provided transcript, here is a list of detailed Power BI tasks with their corresponding begin timecodes:

1. [00:05:28] Create a query to retrieve data for the client portfolio report, including the following fields:
   • Client identification
   • Unique identifier
   • Client name
   • Product name (calculated based on the source)

• Balance amount

johnfelipe

A continuación se presenta una tabla comparativa de las versiones y precios de HCL AppScan:

Versión	Precio	Características Clave
HCL AppScan Standard	$2,550/año	- Escaneo automatizado de vulnerabilidades web y móvil
		- Integración con pipelines de CI/CD
		- Generación de informes detallados

johnfelipe

HU35: Construcción de staging BD
HU35: Construcción de tablas H/S/L en BD
HU35: Construcción del dataflow para cumplir con mapeo
HU35: Construcción de procedures para cumplir con dataflow
HU35 Ejecución pruebas y documentación
	Evidencia carga Stage
	Evidencia carga UDV
Reglas de calidad
Nuevo metodo ADF para duplicados
Verificar en el archivo sqlproject que todos los objetos esten incluidos en la seccion BUILD que ninguno aparezca en la seccion NON INCLUDE

johnfelipe

17 consultas están bloqueadas por los siguientes errores:
Vector
Consulta 'Vector' (paso 'Changed Type') hace referencia a otras consultas o pasos, por lo que no puede acceder al origen de datos directamente. Vuelva a generar esta combinación de datos.
Client
Error de EvaluateNativeQueryUnpermitted: la consulta "SELECT Identificacion_Cliente ,Identificador_Unico ,Nombres_Cliente ,Nombre_Fondo ,Monto_Saldo ,Porcentaje_Participacion FROM ddv_saldos_co.RPT_LS_Saldo_Portafolio_Cliente WHERE Fecha_Saldo IN (SELECT MAX(Fecha_Saldo) FROM ddv_saldos_co.RPT_LS_Saldo_Portafolio_Cliente) ORDER BY 1,2,3,4" no está aprobada para su ejecución.
Reference
Error de EvaluateNativeQueryUnpermitted: la consulta "SELECT Nombre_Perfil_Inversion_Cliente_CO ,Nombre_Fondo ,Porcentaje_Inversion AS Porcentaje_Participacion FROM ddv_saldos_co.RPT_LS_Saldo_Portafolio_Referencia ORDER BY 1,2" no está aprobada para su ejecución.
Cliente_Nombre_Tipo_Activo
Error de EvaluateNativeQueryUnpermitted: la consulta "SELECT DISTINCT Identificacion_