PerformancePoint provides a staging database to load data into. Data loaded can be validated within the staging database before synchronising to the main application.
Below is a quick description of the validation steps performed – it could help feed into an ETL specification – if any of the ‘rules’ are broken validation will fail and the main application model cannot be synchronised.
Foreign Key Checks
All foreign keys must reference dimension members that exist.
Leaf Level Checks
Can only load leaf level facts unless the Business Process member is set to MANADJ or FXADJ.
Header Accounts
Facts cannot be loaded against accounts of type ‘Header’
Business Process Members
The following Business Process members are calculated and cannot be loaded:
– CONSOLIDATED
– PREALLOC
– POSTALLOC
– PREELIM
Time Data View
Facts can only be loaded against the ‘Periodic’ dimension member.
Currency Checks
Input Currency must match Entity currency unless you are loading against the FXAdj Business Process in which case you can specify a different currency.
Flow Checks
The following Flow members are calculated and cannot be loaded:
– FX
– FXO
– FXF
– OPE
– MVT
– INT
Account Type/Flow Checks
No Flow is allowed on Income Statement/Profit and Loss and Non Financial accounts.
Flow is required for Balance Sheet accounts.
Intercompany Checks
Entity, Intercompany and Account dimension members must all have appropriate Entity and Account types, that set the ‘Intercompany’ member property to true for all Intercompany facts
Pareto Charts in Power BI and the DAX behind them
The Pareto principle, commonly referred to as the 80/20 rule, is a concept of prioritisation.
Apr
Databricks: Cluster Configuration
Databricks, a cloud-based platform for data engineering, offers several tools that can be used to
Apr
AI Assistance in Microsoft Fabric
The exponential growth of Large Language Models (LLMs) couples with Microsoft’s close partnership with OpenAI
Apr
10 reasons why it’s worth the effort to understand the value of your data
“If leaders really want to create a data driven culture, the journey starts with them!
Apr
Content Safety in Azure AI Studio
Azure AI Content Safety is a solution designed to identify harmful content, whether generated by
Apr
Model Benchmarks in Azure AI Studio
In the constantly changing field of artificial intelligence (AI) and machine learning (ML), choosing the
Apr
Celebrating International Women’s Day: from Classroom to Code
As we celebrate International Women’s Day, I want to share my journey of breaking stereotypes
Mar
Pretty Power BI – Adding Pagination to Bar Charts
Good User Experience (UX) design is crucial in enabling stakeholders to maximise the insights that
Feb