sql-serverssasdata-warehousebusiness-intelligencewarehouse
Figuring out dimensions for a DW
I have the following database schema from which I want to create DW with the needed dimensions for the following KPIs:
- Number of personel by training (formations)
- HR turnover
- Absences by category
What I'm trying to figure out is which dimensions should provide the contextual information for the facts table.
Solution
The following suggestions are based on your comments:
- To extract Absences by category you need to specify CATEGORIE and ABSENCE tables as dimensions.
- To extract Number of personnel by training (formations) you need to specify FORMATION table as dimension
- To extract the HR turnovers you need to specify CATEGORIE table as dimension
- What does the SQL Server Error "String Data, Right Truncation" mean and how do I fix it?
- A mathematical way to divide overlapping time ranges into hours
- How can I efficiently convert a bigint into a base 2 string and count the 1s?
- sqlBulkCopy WriteToServer throwing an error on computed fields (even if they are not included in the INSERT statement)
- SSRS Date Parameter and second parameter
- Create Table Computed Value
- How to place FK constraint so that deleting a single FK record DOES NOT delete the primary record
- How to read each row and value with SqlCommand in C#?
- How to determine report permissions via SSRS ReportServer database tables
- Using the Reporting Services Web Service, how do you get the permissions of a particular user?
- SQL Server Operating system error 5: "5(Access is denied.)"
- Modelling a Meals / Recipes / Foods database
- String Matching Struggle
- SQL-Server: Error - Exclusive access could not be obtained because the database is in use
- Script to get Log file name of database, change full recovery to simple, shrink log file and set back to full recovery
- Add an incremental categorical column
- WHERE clause that needs to be NULL or NOT NULL
- Replacing window function OVER() with WINDOW clause reference yields different results
- Getting "The connection does not support MultipleActiveResultSets" in a ForEach with async-await
- Dateadd for moving 7 day avg VS (partition by price order by date rows between 6 preceding and current row)
- SQL Server does not exist or access denied
- Error message: (provider: Shared Memory Provider, error: 0 - No process is on the other end of the pipe.)
- Append JSON values to a JSON array in SQL Server?
- How to fix a "No process is on the other end of the pipe" error in SQL Server 2012
- SQL Server 2016 R Services download
- Why and when should I use SPARSE COLUMN?
- How to store SQL query result into variable to include in a later SELECT statement
- Why does this approach with TarWriter use alot of memory with Streams for files?
- SQL Server 2008 delete all tables under special schema
- LINQ query using .All() returns fewer than expected results