Results 226 for
"start and finish dates and role playing dimensions"
SMP BIG ADV ?
What do i need to do to take advantage of these if i am running a Q6600 no oc. I have read in the past that the old SMP would give bonus points for WU's done with the Q6600.
What do i need to do to take advantage of these if i am running a Q6600 no oc. I have read in the past that the old SMP would give bonus points for WU's done with the Q6600.
How do you handle weighting when you have multiple mulitvalued dimensions?
I've been reading The Data Warehouse Toolkit (2 ed.) and I can't seem to find a section that discusses how to handle weighting when more than one multivalued dimension is included in the design. I work with healthcare claims; we're in the process of
I've been reading The Data Warehouse Toolkit (2 ed.) and I can't seem to find a section that discusses how to handle weighting when more than one multivalued dimension is included in the design. I work with healthcare claims; we're in the process of
Joining facts through conforming dimensions
I've seen some overlap in some posts but I don't want to hijack someone elses thread to attempt to get clarification for my scenario. I also didn't want to simply make the title "Joining Fact Tables" because I know the immediate response would b
I've seen some overlap in some posts but I don't want to hijack someone elses thread to attempt to get clarification for my scenario. I also didn't want to simply make the title "Joining Fact Tables" because I know the immediate response would b
Aggregates with Distinct
Hi all, I am currently wroking on a Star Schema [with few dimensions and one fact :-)] but ran into some issues regarding Unduplicated Aggregates. Let me explain: we have the following dimensions : Ofices Staff
Hi all, I am currently wroking on a Star Schema [with few dimensions and one fact :-)] but ran into some issues regarding Unduplicated Aggregates. Let me explain: we have the following dimensions : Ofices Staff
Date Dimension
Hi All, I understood Kimball way of implementation Date Dimension table. In a way, the lowest granularity date represent each record, with the following month, quarter and year attribute. However, what happen if the lowest grain of certain fact are at
Hi All, I understood Kimball way of implementation Date Dimension table. In a way, the lowest granularity date represent each record, with the following month, quarter and year attribute. However, what happen if the lowest grain of certain fact are at
Business keys in Fact. Is this accepted?
It is a data warehouse optimization project and a very basic data warehouse is in place. There are a couple of dimensions with only 2, 3 columns only (<30 rows) and where the Business key can be easily interpreted. Ex: Event_Type_DIM: this has 2
It is a data warehouse optimization project and a very basic data warehouse is in place. There are a couple of dimensions with only 2, 3 columns only (<30 rows) and where the Business key can be easily interpreted. Ex: Event_Type_DIM: this has 2
Tablet stuck at "sylvania" screen
I turned on the tablet last night, and it's stuck at the "Sylvania" screen. Have tried while plugged in and not-no difference. I have not modded this tablet at all. I'm planning on returning it (was planning to today), but wanted to do a
I turned on the tablet last night, and it's stuck at the "Sylvania" screen. Have tried while plugged in and not-no difference. I have not modded this tablet at all. I'm planning on returning it (was planning to today), but wanted to do a
New to BI and need a little help understanding the basic concept
Hi, I apologize in advance if you lose the will to live with my question or if you think it is a stupid one but I am very know to BI with limited SQL knowledge, I have be tasked with developing a BI solution which on the face of it seems small scale
Hi, I apologize in advance if you lose the will to live with my question or if you think it is a stupid one but I am very know to BI with limited SQL knowledge, I have be tasked with developing a BI solution which on the face of it seems small scale
Assign default value for a dimension
Hi, We have the following case: For the product code in the source data, lookup the product natural key in the product dimension and assign the surrogate key returned by the lookup to the fact. If the lookup fails, assign the unknown product whose
Hi, We have the following case: For the product code in the source data, lookup the product natural key in the product dimension and assign the surrogate key returned by the lookup to the fact. If the lookup fails, assign the unknown product whose
Updating a Fact Table
I currently working on an Accounting Datamart which the dims and facts are loaded daily. I have recently had a request to update the data after its been loaded. The best way for me to explain this is to give an example. The data is loaded daily, so
I currently working on an Accounting Datamart which the dims and facts are loaded daily. I have recently had a request to update the data after its been loaded. The best way for me to explain this is to give an example. The data is loaded daily, so
Customer Dimension
I am trying to model a Customer Dimension with Educational and Employment details and I want some advice on how to model this scenario A Customer can have several levels of Education like schooling, college, university, training (one to many realtionship
I am trying to model a Customer Dimension with Educational and Employment details and I want some advice on how to model this scenario A Customer can have several levels of Education like schooling, college, university, training (one to many realtionship
Snowflake or Star Schema?
Hi, I am doing some dimensional modelling for a "not for profit" Fundraising Company They solicit Funds from the WEB, Direct Mail and Phone Solitications, etc and all Transactions are stamped with the FundID. The legacy system has all
Hi, I am doing some dimensional modelling for a "not for profit" Fundraising Company They solicit Funds from the WEB, Direct Mail and Phone Solitications, etc and all Transactions are stamped with the FundID. The legacy system has all
Combining Factless Facts and Bridges - sensible or not?
We are working in a MS SQL Server 2005 environment using SSIS to populate our DW DB and SSAS to build our OLAP database from that DW DB. It is not a huge database in the scheme of things - 28 million payments, 6 million customers, 2 million membership
We are working in a MS SQL Server 2005 environment using SSIS to populate our DW DB and SSAS to build our OLAP database from that DW DB. It is not a huge database in the scheme of things - 28 million payments, 6 million customers, 2 million membership
two facts that relate via degenerate dimension
Hi, I have a order line fact which look like this: Order Line Fact ------------- Order Line Key (SK) Order Line number (DD) Order Number (DD) Some measure (fact) Now some time later I have another fact which would reference the Order Number
Hi, I have a order line fact which look like this: Order Line Fact ------------- Order Line Key (SK) Order Line number (DD) Order Number (DD) Some measure (fact) Now some time later I have another fact which would reference the Order Number
Dealing with Duplicate Dimension Rows
A recent acquisition has added complexity to the Customer dimension and associated fact tables at the company I work for. The root of the problem is that we now have around 20 sources of customer and associated sales facts. We have data quality processe
A recent acquisition has added complexity to the Customer dimension and associated fact tables at the company I work for. The root of the problem is that we now have around 20 sources of customer and associated sales facts. We have data quality processe
Results 226 to 240 on 284
for "start and finish dates and role playing dimensions"
for "start and finish dates and role playing dimensions"
Active topics
Popular topics
Unanswered topics
