Dimension Attribute that has 13.5million members

dimension attribute denormalisation in fact table

Hello, in our data warehouse, we have a fact table containing about 100 million rows per month joined to a customer dimension containing about 10 million customers. The customer dimension contains 30 attributes. Two of these attributes are very

data as an attribute on a dimension or a key on the fact table

Hi, I am in the process of trying to model a mortgage (origination/servicing) data mart. For requirements all I was given at this point is a spreadsheet of attributes. My plan was to try and pull out dimensions and metrics from the list and then have a

Same attribute in multiple dimensions or Create new dimension?

Hi all - I'm struggling with this concept. I have 2 dimensions: Customer and Products. Both share a common single attribute that I'll just call "Owner" for now. If a customer purchased a product, the owner would be the same for both. I

What to do when a single attribute rolls up to multiple categories?

I'm working with healthcare claims data, and developing a new data warehouse. A single pharmacy claim line will have a drug identifier called a NDC (national drug code). A single NDC may belong to one or more drug categories. Given the one-to-many

attributes depending on more than 1 dimension (2 dimensions)

suppose you have - a discount code attribute - a status attribute which depend on the combination of the dimension customer & the dimension product. You want to be able to relate these attributes to a fact table invoice details. What are the

Multi valued dimension attributes, weighting factor and cognos

Hi, we have several attributes in our product and customer dimension which might by multi valued. We modelled these as multi valued dimension attributes using bridge tables and weighting factors therein. Can anybody reference a best practice

Flexiblity To Add Attributes To A Dimension And Not Process The Whole Cube/s

Hello, We are in the process of designing a DW for Games and have run into a business problem : Business users want to add attributes to a dimension and decide its level in the hierarchy on the fly. The new attributes should be availabe in reports

Sparse dimensions, how to handle?

I've purchased the book "The Microsoft Data Warehouse Toolkit" and have reviewed it in order to build out a data warehouse solution I am currently designing. I am stuck in a spot that I don't seem to find any examples of , or am not abl

Audit Dimension Help

Hello all. I'm at the stage now where im building the audit dimension for my warehouse. I am having a little trouble figuring out a few things though. How do you aggregate the data from the error event fact table into the audit dimension? Some records

Supplier Dimension to include Customers & Employees

We are in the process of finalising Dimensions /Facts to be used in Datawarehouse. Already finalised separate dimensions (eg Customer,Supplier,Employee) to handle requirements of Sales,Purchace and Human resourses. During designing Accounts Payable Fact

Comments on members profile

It would be nice if members can communicate through comments on the profile pages? It seems a more friendly and personal way to communicate on a daily basis then just PM's or the main forums , dont you think so? It would open up the forum on a whole ne

Lock a topic so it doesn't count towards members post count

I've seen this feature on smf forums. It should be able to be implemented on phpbb.

Members Can Donate Points

I think it would be handy if there was an option that would allow everyone, not just administrators, to donate points to each other. It can get stressful, especially if you have a lot of members, trying to keep up with adding and subtracting points. A lot