Results 226 for
"start and finish dates and role playing dimensions"
dimension model for many indicators field
I have 30+ fileds that has either 1 or 0 ( true or false)value in a fact table Patid -- -- --- PTInd_1 Ptind_2 Ptind_3........ PTind_30 -- etc 1
I have 30+ fileds that has either 1 or 0 ( true or false)value in a fact table Patid -- -- --- PTInd_1 Ptind_2 Ptind_3........ PTind_30 -- etc 1
Textual values in dimension tables
With much interest I am reading "The Data Warehouse Toolkit", and I stumble upon a design thing that I have done differently in my Data Warehouse design (this is described in the book on page 42). It describes about the dimension table that it
With much interest I am reading "The Data Warehouse Toolkit", and I stumble upon a design thing that I have done differently in my Data Warehouse design (this is described in the book on page 42). It describes about the dimension table that it
Confusion - star, snowflake, bridge table
Appreciate your expert comment on following: Entities: Quote, Trade, DIRequest, Order User, Customer, Trader, Sales or Marketer and Product - User is a user who is using the system or interfacing with the system. i.e. requesting quote or placing a
Appreciate your expert comment on following: Entities: Quote, Trade, DIRequest, Order User, Customer, Trader, Sales or Marketer and Product - User is a user who is using the system or interfacing with the system. i.e. requesting quote or placing a
Insurance Claims
Hi I was reading the Kimball DW Toolkit and need some advice concerning the chapter concernining Claims Processing: Our dataware contains a claims accumulating fact table containing a number of date fields (received date, signed date, entered into
Hi I was reading the Kimball DW Toolkit and need some advice concerning the chapter concernining Claims Processing: Our dataware contains a claims accumulating fact table containing a number of date fields (received date, signed date, entered into
Modeling help on dimension with many boolean value
Hi I'm really stuck on how to model a user need/business need Basically, we are in the healthcare and we have a software that manage the work of the paramedics in ambulances. There is a table that store all standard informations about the work of
Hi I'm really stuck on how to model a user need/business need Basically, we are in the healthcare and we have a software that manage the work of the paramedics in ambulances. There is a table that store all standard informations about the work of
multiple hierarchy : single dimension vs multiple
Hi Need to analysis sale revenue by store. We have two separate hierarchy for geographic location 1. Country / County / Council / Store name 2. Country / Region / Area / Store name Need valuable suggestion for how to design dimension for above to
Hi Need to analysis sale revenue by store. We have two separate hierarchy for geographic location 1. Country / County / Council / Store name 2. Country / Region / Area / Store name Need valuable suggestion for how to design dimension for above to
star data model and reporting with different dimension groupings
Dear community, I would like to ask you for helping me with a star data model / reporting problem. The simplified data model is: FACT_SALES (DATE_ID, PRODUCT_ID, CUSTOMER_ID, PLANT_ID, SALES_AMOUNT) DIM_PRODUCT (PRODUCT_ID, PRODUCT_NR,
Dear community, I would like to ask you for helping me with a star data model / reporting problem. The simplified data model is: FACT_SALES (DATE_ID, PRODUCT_ID, CUSTOMER_ID, PLANT_ID, SALES_AMOUNT) DIM_PRODUCT (PRODUCT_ID, PRODUCT_NR,
User Defined Dimension Attributes
I have a business requirement that is somewhat stretching my modelling skills. The application is a highly sensitive one so Ill describe the problem using a Sales Datamart template. There are 7 plus fact tables, 1 is updated monthly, the rest
I have a business requirement that is somewhat stretching my modelling skills. The application is a highly sensitive one so Ill describe the problem using a Sales Datamart template. There are 7 plus fact tables, 1 is updated monthly, the rest
Updating Periodic Snapshot Fact Tables
What are the best practices for maintaining periodic snapshot fact tables if the atomic data that created them is modified? We have a couple periodic snapshot tables that capture new inventory and new revenue at the end of every month. Sometimes the
What are the best practices for maintaining periodic snapshot fact tables if the atomic data that created them is modified? We have a couple periodic snapshot tables that capture new inventory and new revenue at the end of every month. Sometimes the
makeing a stand for star schema design
Hi, I am new to a financial company and I was asked to model two new sources of data in the existing mortgage data mart (not too sure if you could actually call it a datamart after seeing the design), basically I was asked to create detail information
Hi, I am new to a financial company and I was asked to model two new sources of data in the existing mortgage data mart (not too sure if you could actually call it a datamart after seeing the design), basically I was asked to create detail information
Facts or Dimension Attributes?
My company is currently building a data warehouse and I have a design issue that I am not sure how to address. In general, our business is selling an asset, such as the stock of a corporation, with a certain number of shares and a value. The value of th
My company is currently building a data warehouse and I have a design issue that I am not sure how to address. In general, our business is selling an asset, such as the stock of a corporation, with a certain number of shares and a value. The value of th
Modeling for Service related facts and dimension (for Tour Operating Company)
I am currently doing a dimensional model design for a Tour operating company. Their business is like selling hotels rooms, flights, and excursion to customers. All these are called SERVICES. Now I am designing dimension and fact table to hold bookings
I am currently doing a dimensional model design for a Tour operating company. Their business is like selling hotels rooms, flights, and excursion to customers. All these are called SERVICES. Now I am designing dimension and fact table to hold bookings
Textual fact or Junk dimension?
Hello, I have been following the forum for a while now and I must say that many doubts about dimensional modeling have gone thank to you all. However I am facing now the modeling of a cube and I am somewhat stuck on what is the best
Hello, I have been following the forum for a while now and I must say that many doubts about dimensional modeling have gone thank to you all. However I am facing now the modeling of a cube and I am somewhat stuck on what is the best
Employee With Multiple Jobs
Hello; I am developing an Employee Transaction Dimension such as that seen in Figure 8.2 of the "The Data Warehouse Toolkit". In my case, an employee may have multiple jobs. Some of the attributes found in the Employee Transaction Dimension
Hello; I am developing an Employee Transaction Dimension such as that seen in Figure 8.2 of the "The Data Warehouse Toolkit". In my case, an employee may have multiple jobs. Some of the attributes found in the Employee Transaction Dimension
Multi enterprise Calendar Dimension
Current I'm working for a Enterprise organisation that provide multiple vendors over the world with contract information. My question is what is the best practice for creating a Calendar structure that can support multiple different time zones and fiscal
Current I'm working for a Enterprise organisation that provide multiple vendors over the world with contract information. My question is what is the best practice for creating a Calendar structure that can support multiple different time zones and fiscal
Results 226 to 240 on 265
for "start and finish dates and role playing dimensions"
for "start and finish dates and role playing dimensions"
Active topics
Popular topics
Unanswered topics
