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
Introduction to Data Wrangler in Microsoft Fabric
What is Data Wrangler? A key selling point of Microsoft Fabric is the Data Science
Jul
Autogen Power BI Model in Tabular Editor
In the realm of business intelligence, Power BI has emerged as a powerful tool for
Jul
Microsoft Healthcare Accelerator for Fabric
Microsoft released the Healthcare Data Solutions in Microsoft Fabric in Q1 2024. It was introduced
Jul
Unlock the Power of Colour: Make Your Power BI Reports Pop
Colour is a powerful visual tool that can enhance the appeal and readability of your
Jul
Python vs. PySpark: Navigating Data Analytics in Databricks – Part 2
Part 2: Exploring Advanced Functionalities in Databricks Welcome back to our Databricks journey! In this
May
GPT-4 with Vision vs Custom Vision in Anomaly Detection
Businesses today are generating data at an unprecedented rate. Automated processing of data is essential
May
Exploring DALL·E Capabilities
What is DALL·E? DALL·E is text-to-image generation system developed by OpenAI using deep learning methodologies.
May
Using Copilot Studio to Develop a HR Policy Bot
The next addition to Microsoft’s generative AI and large language model tools is Microsoft Copilot
Apr