.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Two facts with 0:n (0,n) cardinality - managing legitimate orphan facts

Posted By:      Posted Date: September 22, 2010    Points: 0   Category :Sql Server

Dear All,

I have two fact tables with 0:n cardinality.  This is for a hosptal operating theatre.  Consider:  blocks of time are timetabled for operations to be carried out for a list of patients.  These blocks of time are called sessions, and the operations that are booked to be done in those blocks of time 'belong' to those sessions.  So, we have a 1:n cardinality relationship between sessions and operations.  However, not all operations fall into this 'pre-booked' category.  There are emergencies.  These simply get done right there and then, and don't 'belong' to any session.  There's a 0:n cardinality relationship between sessions and emergencies.  Booked operations and emergencies are interspersed throughout the day. 

One piece of information I want is a count of operations per session.  That implies a referenced relationship between my operations measure group and my sessions dimension, via the operations dimension as intermediate dimension (I should add that in my cube, the sessions fact has an associated 1:1 sessions dimension, and the operations measure group likewise has a 1:1 fact dimension).  Of course, any attempt to process a cube with such a relationship fails, as some of the operations side of the fact:fact relationship don't have&nbs

View Complete Post

More Related Resource Links

Two many to many dimension => How to calculate correct facts????

Hey guys,   I got a problem and I hope someone could help me with it.  I have the following scenario which I need to solve. The Schema looks something lilke that...   DIM3 DIM3_Key Dim3_Att   FactlessFact_DIM3_DIM4 DIM3_Key DIM4_Key WeightingFactor   DIM4 DIM4_Key Dim4_Att     FACT DIM1_Key DIM3_Key Sales_Fact   DIM1 DIM1_Key Dim1_Att   FactlessFact_DIM1_DIM2 DIM1_Key DIM2_Key WeightingFactor     DIM2 DIM2_Key Dim2_Att   As you can see my Facttable is connected to two dimension which are actually many to many. Also there is a 'WeightingFactor' in every FactlessFact table (BRIDGE), so that i am able to correct (as defined by the factors) values when ever I query DIM2_Att or DIM4_ATT.   So the Problem I have is that I every Fact shoud be MULTIPLIED with the WEIGHTING FACTOR. Well in MSAS 2008 I can do that with an Measured expression but since a measure needs to be unique I cannot just use 'WeightingFactor'. So When I renamed it to WeightingFactor34 and WeightingFactor12. But this only gives me the correct values for the defined Path. In case I use  WeightingFactor12 i only get the correct values for DIM2_ATT but not for DIM4_ATT.   I guess I need to solve this with a calculated Measure???? Am I right? I am new to MSAS and also new with MDX and all this stuff... How can use a calculated meas

How to "infill" snapshot facts by repeating last non-empty value

I have a cube with a typical snapshot structure and daily granularity (like inventory quantities). I would like to be able to remove some of the granular data from this cube, because we have something like 270,000,000 rows of source data, cube processing is slow, and there isn't a meaningful difference from one data point to the next, at the day level. However, users want a graduated level of detail - daily detail for the recent past, then monthly or quarterly for older periods. Doing that would help the situation BUT - they also want charts that "appear" to show data for each data point and not have "holes" between one data point and the next. So here's the question: if I have a cube with a snapshot fact table, and the table has daily values for the most recent 30 days, then monthly values for 6 months, then quarterly values for two years prior, is there any sane way to make output from the cube "spoof" the gaps, by repeating the last snapshot value for each "empty" day? In other words, if I deliver a chart over the whole time period, I want it to have plateaus that repeat the last non empty value across each gap in the data, but without incurring the storage penalty of keeping all those values.

Database Corruption - The Facts Please


Our system


We have over 800 PDA units out in the field, all with SQL Server CE 1.0 and 2.0 installed.  There are four programs on the device that each have their own database.  One program (embedded Visual C++) has an SQL CE 1.0 database, the others (Visual Studio C# CF1) use SQL CE 2.0.


All four databases are stored in a permanent area of memory on the device, but never on the Storage Card.  They are accessed using a connection that is opened and closed for each operation.  We have seen all four databases become corrupted, but the most common is the one most frequently used.


We currently have 10 different PDA models supported by our software out in the field.  We have seen corruption in all of them.




We have poured an enormous amount of resources into trying to work around the problem.  We cannot reproduce corruption at will, but we have collected some facts about it.


1) It does not solely happen because of 'power failure'.  We have seen a database corrupted in our office whilst the device was being charged and powered on the whole time.

2) Removing transactions does not

Toolbox: Static Analysis Database Tools, Managing Remote Computers, And More


If you want to apply static analysis to your databases, connect to remote computers, find out more about the Entity Framework, or just check into some cool podcasts for your daily commute, then you'll want to read more about these latest tools and resources.

Scott Mitchell

MSDN Magazine July 2009

Toolbox: Managing in the Cloud, UX Design Patterns, Anders Hejlsberg's The C# Programming Language,


Now that you're even managing projects in the cloud, you'll need some tools to help. This month we illustrate one, discuss UX design patterns, a book by Anders Hejlsberg, and more.

Scott Mitchell

MSDN Magazine June 2009

Cutting Edge: Managing Dynamic Content Delivery In Silverlight, Part 2


This month Dino continues his look at managing dynamic Silverlight content by discussing caching and isolated storage.

Dino Esposito

MSDN Magazine February 2009

Cutting Edge: Managing Dynamic Content Delivery In Silverlight, Part 1


This month Dino tackles the problem of large download size for Silverlight applications, explaining when to use streaming, when to divide the download, and other techniques for better performance over the wire.

Dino Esposito

MSDN Magazine January 2009

Foundations: Managing State With Durable Services


This month Juval Lowy tackles questions such as when to keep proxies and services in memory for better state management in long-running workflows.

Juval Lowy

MSDN Magazine October 2008

Look it Up: Managing Directory Security Principals in the .NET Framework 3.5


Here's an overview of the new System.DirectoryServices.AccountManagement class in the .NET Framework 3.5 and how it simplifies working with directory services.

Joe Kaplan and Ethan Wilansky

MSDN Magazine January 2008

CLR Inside Out: Managing Object Lifetime


Although the .NET Framework provides a managed execution environment, it is important to consider object lifetime management and write code that uses and releases resources correctly. The CLR team shows you how.

Tim Fischer

MSDN Magazine November 2007

Cutting Edge: Managing the User Experience in AJAX


This month Dino takes a look at limitations and UI issues in Partial Rendering AJAX pages and techniques for managing the UI.

Dino Esposito

MSDN Magazine November 2007

Remoting: Managing the Lifetime of Remote .NET Objects with Leasing and Sponsorship


Leasing and sponsorship is the solution for managing the lifecycle of a remote object in .NET. Each object has a lease that prevents the local garbage collector from destroying it, and most distributed applications rely upon leasing. There are several ways in which objects and clients can extend the lease, including dedicated sponsor objects. In this article, the author explains leasing, shows how to configure it, and how it relates to the various remoting activation models. He then discusses design guidelines and options, along with their impact on throughput and performance. Additionally, he introduces a helper class used to automate the management of lease sponsors.

Juval Lowy

MSDN Magazine December 2003

Data Points: Techniques for Managing Rowset Paging


There are a number of ways to handle paging in Web applications. This month I'll examine several paging techniques and weigh their pros and cons. John Papa discusses how to manage paging and caching issues through the lower tiers of an n-tiered architecture, including how to make SQL Server manage the paging on your app's behalf.

John Papa

MSDN Magazine May 2003

ASP.NET: Nine Options for Managing Persistent User State in Your ASP.NET Application


ASP.NET provides many different ways to persist data between user requests. You can use the Application object, cookies, hidden fields, the Session or Cache objects, and lots of other methods. Deciding when to use each of these can sometimes be difficult. This article will introduce the aforementioned techniques and present some guidelines on when to use them. Although many of these techniques existed in classic ASP, best practices for when to use them have changed with the introduction of the .NET Framework. To persist data in ASP.NET, you'll have to adjust what you learned previously about handling state in ASP.

Steven Smith

MSDN Magazine April 2003

ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend