dimensional-modeling
How to report on sparse areas of sparse fact table
A source system tracks student attendance for a school district by reporting absence events. Attendance on any particular day can be determined by examining three datasets: school calendar, student en[详细]
2023-04-11 15:44 分类:问答How to map entities to dimension table which includes a hierarchy?
Consider the following hierarchy: Department -> Category -> Product (Each department contains multiple categories, each of which contains multiple products.)[详细]
2023-03-18 17:22 分类:问答Dimensional modelling few questions
I am getting familiar with Dimensional model, so started looking at health claims process.开发者_JAVA百科I am trying to acheive the following:[详细]
2023-03-16 07:45 分类:问答Analysis Services Attribute Hierarchy and Attribute Relationships
Is it pos开发者_运维百科sible to have a attribute hierarchy where the parent doesn\'t always have children? If so, how is this achieved in SQL server Analysis Services?Never mind - found the solution:[详细]
2023-03-02 18:19 分类:问答Is it possible to set the foreign key of a reference directly in NHibernate?
Got a project that collects data as XML files from a particular system (these come in as web requests), converts it to an entity model, and stuffs it in a database for reporting.[详细]
2023-02-06 19:24 分类:问答Two or more similar counts on fact table in dimensional modelling
I have designed a fact table that stores thefacts for a specific date dimension and an action type such as create, update or cancelled. The facts can be create and cancelled only once, but update many[详细]
2023-01-17 09:16 分类:问答Star-schema: Separate dimensions for clients and non-clients or shared dimension for attendants?
I\'m new to modeling star schemas, fresh from reading the Data Warehouse Toolkit. I have a business process that has clients and non-clients calling into conference calls with some of our employees.[详细]
2022-12-22 16:46 分类:问答NDepend Code Quality Metrics - Custom CQL - Brownfield development
I\'m working on a brown-field project that was initially developed for .NET 1.1, and subsequently was retro-fitted to .NET 2.0, with a smattering of .NET 3.5[详细]
2022-12-20 07:29 分类:问答