Results 211 for
"start and finish dates and role playing dimensions"
Surrogate Key causing incorrect results
Hi Sorry for the newbie question, i am just starting out with SSAS and I am trying to figure out how to do the following:- I have a applications fact table with a surrogate key (auto number) and business key, I am trying to calculate applications
Hi Sorry for the newbie question, i am just starting out with SSAS and I am trying to figure out how to do the following:- I have a applications fact table with a surrogate key (auto number) and business key, I am trying to calculate applications
Advice on relationships between Type 2 SCDs ?
Hi All, I am constructing a new warehouse schema containing a number of dimensions which need to be modeled as type 2 SCDs. This is all fine and I have surrogate IDs which are being used as the FK in the facts. The challenge I have is that a number of
Hi All, I am constructing a new warehouse schema containing a number of dimensions which need to be modeled as type 2 SCDs. This is all fine and I have surrogate IDs which are being used as the FK in the facts. The challenge I have is that a number of
Indicator Dimension or Fact Table
Sorry, this is a long explanation but I wanted to document the entire case. Thanks in advance for your advice. Background: Currently we are modeling a data mart for traffic accident data. The source system is a repository rather than a
Sorry, this is a long explanation but I wanted to document the entire case. Thanks in advance for your advice. Background: Currently we are modeling a data mart for traffic accident data. The source system is a repository rather than a
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
SCD type 2 - Valid To Date Value? 12/31/9999 or Null?
Hello all, While populating Effective End Date (Valid to date) for current record, is it better to put a largest possible end date value of 12/31/9999, or is it better to insert a null value. One advantage of inserting 12/31/9999 as end date is that
Hello all, While populating Effective End Date (Valid to date) for current record, is it better to put a largest possible end date value of 12/31/9999, or is it better to insert a null value. One advantage of inserting 12/31/9999 as end date is that
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
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
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
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
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
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
Results 211 to 225 on 267
for "start and finish dates and role playing dimensions"
for "start and finish dates and role playing dimensions"
Active topics
Popular topics
Unanswered topics
