Modeling goals which may slowly change over time

Slowly Changing Facts?

Hi, I know the classic Kimball approach, where you have fact tables and dimension tables with different types of SCD. My current customer has a "fact table" which should be of Slowly Changing Type 2. I never had that requirement, but the fact tables

Sales facts vs sales goals & calls

I did a quick search of the forums and did not see this, but it seems a rather common scenario so I apologize if I am being redundant. I have a primary sales fact table that lists sales as line items from an order, pretty common arrangement. There are

Slowly changing sales opportunity facts or dimensions

We have built a datamart from our CRM system to query on sales opportunties. Sales opportunities look like facts in that they have dimensions (customer, product etc ) and attributes (value of opp). However, they also change status from say, RED to AMBER t

Unsure about relationship with Slowly Changing dimensions.

Hi Sorry datawarehouse newbie question! I have many years experience with relational databases but my head is not yet around the dimensional model. I am not sure how to maintain the relationship between Fact and Type 2 Dimension. i.e if a new row is

Modeling time dimension

I am in the process of building a student data warehouse and our data is based on quarters. Each quarter has a lot of dates associated with it. Some of these dates can overlap - like one date can be pass one for one quarter and pass two for another

Dynamic KPI goals

Hi All, We have a fact table where we collect some details (e.g. A, B, C, D ...) and on our reports we show KPIs based on these details. Let say KPI_1 is based on A and B, KPI_2 is based on A and D and so on. We have some dimensions like Departments,

Recruitment thread - Current guild status and our goals

Welcome to Prophecy of Zéowyn's forum. If you read this, you have most likely read our guild advertisement in trade or on the guild recruitment channel and wish to learn more about us. First of all, we are a casual RP-PvP guild and as such a guild we have

Track hierarchical slowly changing data which allows relational multiple future dates and retro terms

Q1)Given these requirements, what is the best possible design to model this? REQUIREMENT: Track hierarchical slowly changing data which allows relational multiple future dates and retro terms. Let me explain the 4 terms I have mentioned in detail for

TIME FOR A CHANGE

Is it not time hosting companies and registrars where made liable for any losses directly associated with fraud, hosted or registered by thier companies, Local Law Enforcement agencies could enforce this in the country of the Host/Registrar, This would

Point in time reporting using ad hoc functions

Hi There Is there a BI tool that can handle the following two reporting scenarios? Please note scenarios to be preferably supported through ad hoc reports that user can build on the fly? Also, if you know how to achieve this functionality in a particular

/3-1192263100698-want-a-username-change

Username Change Hello Forumotion Members Do you Want to change your Username? Just reply to this topic with the following details. Code: Last username: New username: Reason (If

My latest voodoo projects

Well here are my latest voodoo related projects. Do you guys happen to know what the first voodoos model number is? Just curious. (My gut is saying its an m:730) It reminds me a lot of my u:703 but its thinner. At any rate the dead voodoo set me back abou

SimBro_Release_v2.1.4_100131_TEST

rapidshare.com SimBro_Release_v2.1.4_100131_TEST.zip rapidshare.com SimBro_Release_v2.1.4_100131_TEST1.zip mediafire.com ymmnziitmow [Fix] Some typo, Style level bug [Codechange] Clean up some mess, [News] Nothing....