Results 241 for
"start and finish dates and role playing dimensions"
Employee compensation - Star or Snowflake?
I'm designing a data mart for employee compensation. The measures will include things such as salary and various bonuses. Most of the data marts I've designed so far have fallen rather gracefully into a star schema. For this one, however, I have
I'm designing a data mart for employee compensation. The measures will include things such as salary and various bonuses. Most of the data marts I've designed so far have fallen rather gracefully into a star schema. For this one, however, I have
Quickly stopping/starting GPU# with a Global hotkey AND Fold on mouse = idle for X min.
I like folding but unfortunately can't stand when it get in my way on my main computer. For example moving among grouped windows with Areo is very laggy when folding (as much as 20% usage 9800gt)and affect video playback above ~320x240. I would
I like folding but unfortunately can't stand when it get in my way on my main computer. For example moving among grouped windows with Areo is very laggy when folding (as much as 20% usage 9800gt)and affect video playback above ~320x240. I would
Bridge tables versus massive junk dimensions
I am designing a star schema to store information on hospital stays. This is my first real star schema and things are off to a good start. My fact table is hospital stays. I have a diagnosis dimension. There are multiple diagnoses per stay. Costs are
I am designing a star schema to store information on hospital stays. This is my first real star schema and things are off to a good start. My fact table is hospital stays. I have a diagnosis dimension. There are multiple diagnoses per stay. Costs are
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
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
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
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
Results 241 to 255 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
