Skip to content
Power Partners Doc
DWH (Bouwsoft edition) Technical Reference
Initializing search
pwrp/doc
Power Partners Doc
pwrp/doc
Welcome
General
General
Docdoc
Values
Values
mission
values
Processes
Processes
Role Assignments
Roles
Roles
Delivery
Delivery
Account Manager
Channel Manager
Delivery Team Member
Onboarding Buddy
Project Manager
Relationship Manager
Scrum Master
Marketing
Marketing
Marketing Assistant
Marketing Manager
Sales
Sales
Sales Manager
Sales Representative
Finance
Finance
Accountant
Bookkeeper
Payroll Manager
Sold License Manager
Operations
Operations
Budget manager
Cost Manager
Operations Manager
Time Log Executor
HR
HR
Line Manager
OKR Manager
Onboarding Executor
Worktime Reviewer
Strategy
Strategy
Chairman of the Board
General Manager
IT
IT
Documentation Officer
IT Onboarding Executor
Security Officer
Web Site Manager
Process Landscape
Process Landscape
All Employees
All Employees
1password
Cyber Security Guidelines
Expenses
Office Netiquette CH
Overtime
Sick Leave
Vacation Request
Work Time Tracking
Delivery
Delivery
Delivery Team-Member
Delivery Team-Member
Client Browser Profile Installation
Create Task
New Team-Member Onboarding Buddy
Planio Time Tracking
Planning Meeting Preparation for Delivery Team Member
Support Ticket Resolution
Account Manager
Account Manager
Client Invoice Creation
Credit Note
Project Offer
Reminder Management
Project Manager
Project Manager
Create Order
Planning Meeting Preparation for Project Manager
Scrum Master
Scrum Master
Planning Meeting Preparation for Scrum Master
Planning Meeting
Standup Meeting
Retrospective Meeting
Support Desk
Weekly Timelog Review Meeting
Monthly Timelog Review
Demo Meeting
Relationship manager
Relationship manager
Client Delivery Onboarding
Planning Meeting Preparation for Relationship Manager
User Metrics Onboarding
Marketing
Marketing
Dashboard of the Month
Google analytics
Lead Forensics Workflow
Linkedin channel management
Mail chimp list maintenance
Sales
Sales
Lead Generation
Sales Cold Calling
New Prospect Onboarding
New Client Onboarding
Freshsales cleanup
Monthly Greatness Meeting Sales
Finance
Finance
Accountant
Accountant
Month-End Closing
Payroll Management
Tax at Source
VAT
Bookkeeper
Bookkeeper
Accounts Payables
Daily Bank Reconciliation
Intra-Company Invoicing
License manager
License manager
License Invoice Preparation
Monthly Project Invoicing Overview
Operations
Operations
Process Review Meeting
Quarterly Management Meeting
IT
IT
Employee IT Offboarding
New Employee IT Onboarding
Search Console Review
Wp backup check
Wp update
HR
HR
Monthly Greatness Meeting
New Employee Onboarding
OKR Meeting
Worktime Review
Strategy
Strategy
Yearly Strategy Offsite
Templates
Templates
Process Template
Meeting Template
Clients
Clients
wf
wf
ari
ari
Support
Support
Ari support
azj
azj
sd
sd
Solution Overview
um
um
Az Jan Portaels Automation Server User Manual
cem
cem
Solution Design
Solution Design
Organization
Solution Overview
Perspectives
Perspectives
Production
Arendar
Arendar
Arendar / CongaConnect
KPI Overview
Support
Support
Compare Actual Datapoints with Derived Values
Configure New Timeseries
Inspecting SQL query of influx view
cgk
cgk
Sd
Sd
CGK
KPIs
Data Sources
Data Model
Data Mapping
Components
Support
Support
CGK Support
del
del
Sd
Sd
del
Introduction
KPIs
Data Sources
Data Model
Data Mapping
Components
Support
Support
Support
del Support
hbr
hbr
Sd
Sd
hbr
KPIs
Exact Data Source
Excel Data Source
Lean Data Source
OneTwo Source
Support
Support
Support
hbr Holvoet Support
hey
hey
Perspectives
Perspectives
Perspective: Pipeline
Perspective: Portfolio
Perspective: Project
Sd
Sd
CDS Views
hey Overview
RE-FX Tables
SAP Odata Views
SAP Transactions
Support
Support
Azure function sap api url parameter
HEY Support
int
int
Sd
Sd
Intermedia Introduction
Reports
Data Sources
Data Model
Data Mapping
Components
Support
Support
INT Support
Int 1 adding column to issues table
User manual
User manual
Intermedia Monthly Reporting
Nop
Nop
Sd
Sd
Current setup
pab
pab
Sd
Sd
PAB Lineage
prf
prf
Sd
Sd
prf
KPIs
Data Sources
Data Model
Data Mapping
Components
Support
Support
PRF Support
ptau
ptau
Support
Support
ptau Support
tb
tb
Budget per division
tun
tun
Organization
Tunap Business Process
Solution Overview
Support
Support
Tunap Support
umbr
umbr
Sd
Sd
umbr
KPIs
Data Sources
Components
Data Mapping
Data Model
Learnings
Support
Support
UMBR Support
vdm
vdm
Sd
Sd
Overview
Solution Overview
Perspective Finance
Support
Support
vdm Support
vm
vm
Sd
Sd
vm
KPIs
Data Sources
Data Model
Data Mapping
Components
Support
Support
VM Support
vns
vns
Introduction
KPIs
3 data sources
4 datamodel
Data Mapping
Components
Z old
Z old
eeg
eeg
Sd
Sd
Eeg power bi development
Legacy ssis
Legacy ssis
EEG SSIS Getting Started
Background
Pipeline
indu
indu
Sd
Sd
indu
Organisation
Perspectives and KPQs
Processes
KPIs
Dashboards
Data Sources
Data Model
Lineage
Support
Support
INDU Support
zh
zh
alki
alki
Sd
Sd
Components
Data Model
User Access
Support
Support
Alkitronic Support
Die
Die
Sd
Sd
Die sd
Support
Support
die-Support
hbt
hbt
Sd
Sd
hbt Heinrich Brandmeldetechnik Solution Design
Support
Support
hbt Heinrich Brandmeldetechnik Support
lb
lb
Sd
Sd
Dispo screen
Dispo screen
Leisibach Overview (#lb)
De
De
Solution Design Übersicht
Dispo-Bildschirm
En
En
Solution Design Overview
Dispo Screen
Fahrer bonus
Fahrer bonus
Driver Bonus
Fahrer Bonus ADM
Data Mapping
KPIs
Support
Support
LB Support
pot
pot
Sd
Sd
pot
Introduction
Organisation
Perspectives and KPQs
KPIs
Processes
Dashboards
Data Sources
Data Model
Lineage
Support
Support
POT Support
stihl
stihl
Access overview
Teli
Teli
System Access
Wil
Wil
Client docu
Client docu
Übersicht Power-BI-Modell
son
son
bom
bom
Sd
Sd
bom
Introduction
KPIs
Dashboards
Data Sources
Processes
Data Model
Data Mapping
Lineage
Annex 1: Legacy Reporting
Support
Support
bom Support
Bom warehouse employee
kdg
kdg
Sd
Sd
Dynamics 365 file export snapshot
kdg Overview
Legacy Environment
Support
Support
KDG Support
old
old
duco
duco
Sd
Sd
duco
Introduction
KPIs
Data Sources
Data Model
Data Mapping
Components
Reports
Support
Support
duco Support
itsi
itsi
nat
nat
Sd
Sd
Naturalia Introduction
Reports
Data Sources
Data Model
Data Mapping
Components
Support
Support
NAT Support
internal
internal
pwrp
pwrp
Sd
Sd
Overview
Solution Overview
Perspective Operations
Perspective Delivery
Support
Support
pwrp Support
Departments
Departments
Delivery
Delivery
Knowledge Base
Knowledge Base
Azure
Azure
Subscription
Subscription
Azure Subscription
Adf
Adf
Azure Data Factory
Azure Data Factory (ADF)
Integration Runtime (IR)
Edm.Stream
How to correctly setup the App for the PBI dataset refresh
App config
App config
App Config (AC)
Azure function
Azure function
Azure Function Introduction
Azure Function Installation
Hybrid Connection Manager (HCM)
How to analyse logs of a specific table
Azure Functions Tips and Tricks
Azure logic app
Azure logic app
Azure logic app
Entra odata app
Entra odata app
Introduction to OAuth on the Microsoft Identity Platform
Auth Code Authorization Flow
Client Credentials Authorization flow
Creating an Entra App in Azure
Media
Media
Untitled
Key vault
Key vault
Key Vault Installation
Azure Key Vault Introduction
Power bi api
Power bi api
Power BI API
Power BI Embedded Introduction
Power BI Embed Token
Storage account
Storage account
Storage Account (SA)
Web app
Web app
Web App Introduction
Core Tools
Core Tools
Apps and Tools Overview
Azure Data Studio
dev.azure.com
GitHub
Greenshot
Obsidian
ERPs
ERPs
A3
Abacus
Abacus
Abacus Financial Reports F31
Abacus Introduction
Modules
Abacus ODBC driver installation
Abacus REST API
Abacus tips and tricks
BC Business Central
BC Business Central
Introduction
First Steps
Sales Document Types
API
Extensions
Bouwsoft
ES2000
Exact
KPD
KWP
Logic4
Odoo
Onetwo
Prato
Sap
Sap
SAP BusinessOne (SAP B1)
SAP S/4HANA
Exclaimer
Exclaimer
Exclaimer Setup Guidelines
git
git
Git Introduction
How we use git
Git LFS
md
md
Overview
LaTeX
LTeX
Markdown Tips and Tricks
Typical Tasks in Markdown
MS365
MS365
Outlook
GDAP
Power BI
Power BI
Anonymise a dataset
Extract or Save Background Images from pbix file
Dashboard on TV (Legacy)
Refresh Error
Sharing reports overview
Using Imgur to add/create public images to Power BI reports
DAX
DAX
DAX Calendar Week
DAX Open Orders
DAX DimCalendar
DAX Fiscal Year
DAX Last Balance
DAX Showing Dimensions for Empty Facts
Multilanguage dataset using tabular editor
Mylan test
Power query
Power query
Import Multiple Excel Workbooks Using PowerQuery M In Gen1 Dataflows
Master dataflow issue explanation
Planio
Planio
Planio: Terminology and Concepts
Planio Guidelines
Planio Meetings
Planio Helpdesk Functionality
Semantic Model
Semantic Model
G/L Semantic Model (ADM)
Transactions vs Positions
Sql
Sql
Firebirdsql
Firebirdsql
Important specialities
SQL
SQL
Azure SQL Server
Azure SQL Installation
Tips and tricks
Tips and tricks
How to drop all tables in an SQL Server Schema
How to Import a Large Excel into SQL Server
Move Tables to a New Schema (Rename Schema)
SQL Server Create Script from Table Data
Vpn
Vpn
hide.me VPN
ngrok
VSC
VSC
Log into Azure from VSC
Vsc 2 deploy al extension
Cannot Debug Python in VSC: User/settings.json
Terminal not active after running script
Python VSC Project Cloning
Dev Guidelines
Dev Guidelines
Development Guidelines
Power BI Playbook
Power BI Playbook
Power BI Playbook
Introduction
Components
Data Wrangling
Modelling
Calculations
Visuals
Reference lists
Reference lists
Power BI Checklists
Power BI Naming Conventions
Solution Design
Solution Design
Guidelines
Templates
Templates
Organization
Solution Overview
Perspective XXX
Cheat-Sheet
Offering
Offering
Services
Services
Consulting
Consulting
Consulting Overview
Projects
Projects
Project Overview
Products
Products
Product Landscape
DWH (BC edition)
DWH (BC edition)
Dwh bc introduction
Installation
Installation
Overview
Pre-requisites
Access
Keyvault
Azure Function
SQL Server
Azure Logic App
Azure Data Factory (ADF)
BC
Create Alert For when Azure Activity Fails
VSC Project
Deploy Azure Function
Tips and Tricks
Techref
Techref
DWH (BC): Technical Reference
Updating
Updating
Guideline to update a BC DWH product
FinAcc BC
FinAcc BC
Installation
Installation
Deploying Power BI
Prerequisites
Techref
Techref
Key Measures
Technical reference finacc
DWH (Bouwsoft edition)
DWH (Bouwsoft edition)
DWH (Bouwsoft edition) Introduction
Installation
Installation
Bouwsoft API Authentication
Bouwsoft DWH Azure Deployment
Configuration
Configuration
DWH Bouwsoft Configuration
Techref
Techref
DWH (Bouwsoft edition) Technical Reference
DWH (Exact edition)
DWH (Exact edition)
DWH (Exact edition) Introduction
DWH (Exact edition) Installation
DWH (Exact edition) Installation
Exact Authentication
Exact DWH Azure Deployment
Techref
Techref
References
DWH (InfluxDB edition)
DWH (InfluxDB edition)
Dwh influx readme
DWH (ionBIZ edition)
DWH (ionBIZ edition)
DWH (ionBIZ edition) Introduction
Installation
Installation
DWH (ionBIZ edition) installation
Configuration
Configuration
config.ionbiz_Tables
Techref
Techref
ionBIZ Custom Fields
Dwh robaws
Dwh robaws
Configuration
Configuration
Configuration Table descritpion
Installation
Installation
Robaws API
Robaws DWH Azure Deployment
Reference
Reference
References
Automation server
Automation server
Automation Server Introduction
Techref
Techref
Automation Server Techref
PowerBI Proxy
PowerBI Proxy
Installation
Installation
Installation Overview Power Partners Power BI Proxy
Azure Subscription Setup for Power BI Proxy
Register an Entra App
Power BI Setup
Get a Refresh Token
Key Vault
Web App
Web App Configuration
Web Configuration
Test and Monitor your Proxy Installation
Power BI Proxy Introduction
Theory
Theory
Notation
Variables
Open Orders
KPIs
KPI Examples
KPI Examples
Introduction
Customer
Finance
Sales
HR
Inventory
Projects
Real Estate Portfolio
Marketing
Marketing
Knowledge Base
Knowledge Base
Wp dashboard link
WP Sidebar Language Problem
WP Landing Pages Google Ads
WordPress Landing Pages
WP Sidebar
WordPress Post Translation
Web Page Best Practices
Sales
Sales
Lead Qualification
Campaigns
Campaigns
Lead Forensics Campaigns
Sales Scripts
Sales Scripts
DE
DE
Entscheidungsträger Sales Script
Watchdog
Mapping Client Needs to Products and Services
Finance
Finance
Introduction
IT
IT
Phone Setup
HR
HR
Knowledge base
Knowledge base
Clockodo
Clockodo
Clockodo Import
Recruiting
Recruiting
Analyst
Analyst
Application
Application
Application Rating Table
Video Rating Table
HR Interview
HR Interview
Interview Questions
Rating Table
Business case
Business case
Mayfair
Mayfair
Background
Candidate View
Grade Sheet
Salesonite
Salesonite
Interviewer Background
Candidate View
Grade Sheet
Data Engineer
Data Engineer
Application
Application
Application Rating Table
Video Rating Table
HR Interview
HR Interview
Interview Questions
Rating Table
Business Case
Business Case
Background
Candidate View
Grade Sheet
Strategy
Strategy
Methods
Methods
Fix This Next
Scrum
UMF
Strategy
Strategy
Overview
Organization
Tags
DWH (Bouwsoft edition) Technical Reference
TODO
Back to top