[SOLVED] Sharing ETL files, job and cube for an OTRS DW using Pentaho and PostgreSQL

Moderator: crythias

Post Reply
nedmaj
Znuny expert
Posts: 167
Joined: 26 Nov 2014, 20:34
Znuny Version: 6.3.4
Real Name: Samuel Casimiro
Company: Câmara dos Deputados
Contact:

[SOLVED] Sharing ETL files, job and cube for an OTRS DW using Pentaho and PostgreSQL

Post by nedmaj »

Hi guys,

I just would like to share the KTR files for a OTRS DW I'm working on. This is an on going work.

Staging and OLAP database using PostgreSQL.

Hope share the cube definitions soon.
You do not have the required permissions to view the files attached to this post.
Last edited by nedmaj on 15 Aug 2017, 18:31, edited 1 time in total.
Samuel

Znuny 6.3.4 | OTRS 5.0.17
OS: Debian 11 | CentOS 6.5
Database: Postgres | Oracle 12.1
Number of agents: 450 | Number of customers: 20000 | Number of CIs: 30000
nedmaj
Znuny expert
Posts: 167
Joined: 26 Nov 2014, 20:34
Znuny Version: 6.3.4
Real Name: Samuel Casimiro
Company: Câmara dos Deputados
Contact:

Re: Sharing Pentaho transformation files for OTRS DW

Post by nedmaj »

Uploading a new file. Now with the job definition and using JNDI.
You do not have the required permissions to view the files attached to this post.
Samuel

Znuny 6.3.4 | OTRS 5.0.17
OS: Debian 11 | CentOS 6.5
Database: Postgres | Oracle 12.1
Number of agents: 450 | Number of customers: 20000 | Number of CIs: 30000
nedmaj
Znuny expert
Posts: 167
Joined: 26 Nov 2014, 20:34
Znuny Version: 6.3.4
Real Name: Samuel Casimiro
Company: Câmara dos Deputados
Contact:

Re: Sharing Pentaho transformation files for OTRS DW

Post by nedmaj »

Uploading a new file set. Now with the cube designed using Schema Workbench (Mondrian).
You do not have the required permissions to view the files attached to this post.
Samuel

Znuny 6.3.4 | OTRS 5.0.17
OS: Debian 11 | CentOS 6.5
Database: Postgres | Oracle 12.1
Number of agents: 450 | Number of customers: 20000 | Number of CIs: 30000
nedmaj
Znuny expert
Posts: 167
Joined: 26 Nov 2014, 20:34
Znuny Version: 6.3.4
Real Name: Samuel Casimiro
Company: Câmara dos Deputados
Contact:

Re: [SOLVED] Sharing ETL files, job and cube for an OTRS DW using Pentaho and PostgreSQL

Post by nedmaj »

Uploading a new file set. Sorry it's all defined in portuguese (because of my client), but I think it's easy to translate.
You do not have the required permissions to view the files attached to this post.
Samuel

Znuny 6.3.4 | OTRS 5.0.17
OS: Debian 11 | CentOS 6.5
Database: Postgres | Oracle 12.1
Number of agents: 450 | Number of customers: 20000 | Number of CIs: 30000
nedmaj
Znuny expert
Posts: 167
Joined: 26 Nov 2014, 20:34
Znuny Version: 6.3.4
Real Name: Samuel Casimiro
Company: Câmara dos Deputados
Contact:

Re: [SOLVED] Sharing ETL files, job and cube for an OTRS DW using Pentaho and PostgreSQL

Post by nedmaj »

Uploading a new file set, with new cubes, dimensions and measures.
You do not have the required permissions to view the files attached to this post.
Samuel

Znuny 6.3.4 | OTRS 5.0.17
OS: Debian 11 | CentOS 6.5
Database: Postgres | Oracle 12.1
Number of agents: 450 | Number of customers: 20000 | Number of CIs: 30000
nedmaj
Znuny expert
Posts: 167
Joined: 26 Nov 2014, 20:34
Znuny Version: 6.3.4
Real Name: Samuel Casimiro
Company: Câmara dos Deputados
Contact:

Re: [SOLVED] Sharing ETL files, job and cube for an OTRS DW using Pentaho and PostgreSQL

Post by nedmaj »

Uploading a new file set, with some bug fixes and performance improvements.
You do not have the required permissions to view the files attached to this post.
Samuel

Znuny 6.3.4 | OTRS 5.0.17
OS: Debian 11 | CentOS 6.5
Database: Postgres | Oracle 12.1
Number of agents: 450 | Number of customers: 20000 | Number of CIs: 30000
Post Reply