Results 46 for
"start and finish dates and role playing dimensions"
Slowly Changing Dimensions - Design Review (Need More Clarification)
Hello, Suppose I have following Fact and Dim table CustomerDim CustomerKey CustomerID CustomerNumber CustomerName CreditLimit - Slowly Changing, wants history IsAnnualMember - Slowly Changing, can be different from year to year or
Hello, Suppose I have following Fact and Dim table CustomerDim CustomerKey CustomerID CustomerNumber CustomerName CreditLimit - Slowly Changing, wants history IsAnnualMember - Slowly Changing, can be different from year to year or
ETL approach for replacing multiple dates in one row.
We have a Fact table that stores several key dates in the life cycle of a customer. Each of these dates is supposed to be a surrogate key pointing to the date dimension. My questions pertains to efficiently replacing these dates with surrogate keys in the
We have a Fact table that stores several key dates in the life cycle of a customer. Each of these dates is supposed to be a surrogate key pointing to the date dimension. My questions pertains to efficiently replacing these dates with surrogate keys in the
Hierarchy within single dimension or two dimensions
I am unsure of the best way to model a specific business scenario and was looking for some input. I will explain it in terms of a common example, the Product dimension. Let's say that every "product" is assigned to a specific
I am unsure of the best way to model a specific business scenario and was looking for some input. I will explain it in terms of a common example, the Product dimension. Let's say that every "product" is assigned to a specific
Conformed Dimension for Transaction Fact and Accumulating Snapshot Fact Table
I'm working on a new warehouse application for reporting against our IT Project database. I want to create both a transaction fact table and an accumulating snapshot fact table. The project database (source) consists of multiple normalized tables to
I'm working on a new warehouse application for reporting against our IT Project database. I want to create both a transaction fact table and an accumulating snapshot fact table. The project database (source) consists of multiple normalized tables to
Kimball Dimensions
I got into a nice heated debate the other day. The item of discussion was flattened dimensions. Id like to know your opinion (or facts) about the following, (Some of this is common sense please still give me some feedback ). Any article citations
I got into a nice heated debate the other day. The item of discussion was flattened dimensions. Id like to know your opinion (or facts) about the following, (Some of this is common sense please still give me some feedback ). Any article citations
Modeling multiple multivalued dimensions and other design questions
Hello, all. This is my first time working on a dimensional model and I have some questions regarding multivalue dimensions. I am modeling our Remedy trouble ticket process and was settling on the grain being each individual ticket. The problems come in
Hello, all. This is my first time working on a dimensional model and I have some questions regarding multivalue dimensions. I am modeling our Remedy trouble ticket process and was settling on the grain being each individual ticket. The problems come in
Help in declaring grain and identifying dimensions
Requirements: 3 Reports ----------------------- Source Systems: 3 Project DBs 1st Report : Portfolio Summary Details The project monthly details report will display project information i.e. summary actual costs from the Vendor History file
Requirements: 3 Reports ----------------------- Source Systems: 3 Project DBs 1st Report : Portfolio Summary Details The project monthly details report will display project information i.e. summary actual costs from the Vendor History file
Sandboxie's Start/run access settings
ssj100 or someone else can please explain or guiding me how to setup Sandboxie's settings Start/run access and Internet access [Restrictions].My forced programs VLC,Foxit,Firefox,WMP. Thanks
ssj100 or someone else can please explain or guiding me how to setup Sandboxie's settings Start/run access and Internet access [Restrictions].My forced programs VLC,Foxit,Firefox,WMP. Thanks
Cannot start the internet explorer...what do i do?
So I cant start ie, how do i get it working again?
So I cant start ie, how do i get it working again?
Dimensions Directly Tied to Facts vs. Snowflaking
Hi all, Thanks in advance for your input on this. We are in the midst of a building out a portion of our data warehouse. The example here has to do with insurance data. Hopefully the discussion can be abstracted to a more generic modeling level. We
Hi all, Thanks in advance for your input on this. We are in the midst of a building out a portion of our data warehouse. The example here has to do with insurance data. Hopefully the discussion can be abstracted to a more generic modeling level. We
Date Dimensions - Muliple Calendars
Hi, We have an interesting challenge with our Date dimension. We need to carry multiple calendars - one per country, and one for the Group. When loading the FACT, we create a record per invoice for the country and a record for the group calendars. Thi
Hi, We have an interesting challenge with our Date dimension. We need to carry multiple calendars - one per country, and one for the Group. When loading the FACT, we create a record per invoice for the country and a record for the group calendars. Thi
Time dimension - update
Hi, I was not sure if this question was for ETL or here ;-) This is the situation : I have created a DW and a cube for statistic for Paramedic events. I'm working for the governement of canada and they are using some unusual financial period (13
Hi, I was not sure if this question was for ETL or here ;-) This is the situation : I have created a DW and a cube for statistic for Paramedic events. I'm working for the governement of canada and they are using some unusual financial period (13
Medieval Role-Play
Choice of the category: Games & RPG Choice of a title: Medieval Role-Play Forum address: http://www.medieval-role-play.forumotion.com/ Main language: English Forum description: Medieval Role-Play allows player to live a Medieval Life.
Choice of the category: Games & RPG Choice of a title: Medieval Role-Play Forum address: http://www.medieval-role-play.forumotion.com/ Main language: English Forum description: Medieval Role-Play allows player to live a Medieval Life.
Gateway to Role-Play
Forum Title: Gateway to Role-Play Choice of Category: Games and RPG Language: English Forum's Purpose: The purpose of Gateway to Role-Play is to provide a friendly, organized atmosphere where members can role-play in various genres, chat
Forum Title: Gateway to Role-Play Choice of Category: Games and RPG Language: English Forum's Purpose: The purpose of Gateway to Role-Play is to provide a friendly, organized atmosphere where members can role-play in various genres, chat
Has a server been playing up for the last 36 hours?
My forum has been very slow at times over the last day and a half. Sometimes its normal but for long periods its going very slowly (15-20 seconds to load a page) - other members have reported it too, so its not my PC specific. Is it just our forum o
My forum has been very slow at times over the last day and a half. Sometimes its normal but for long periods its going very slowly (15-20 seconds to load a page) - other members have reported it too, so its not my PC specific. Is it just our forum o
Results 46 to 60 on 263
for "start and finish dates and role playing dimensions"
for "start and finish dates and role playing dimensions"
Active topics
Popular topics
Unanswered topics
