User Defined Dimension Attributes

Deriving Dimension attributes from Fact table

Hi, I have a Customer_Activity fact table which stores the the Activity Start & End Date values. I need to derive the last time the customer had an activity before the current date (based on the Activity End Date - MAX(Activity End Date) WHERE Activity

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

Conformed Dimension Partial Set of Attributes

Hi Just looking for some confirmation that a dimension with partial attributes might still be considered conformed. For eample A dimension of batch ProdBatch PK BatchID Batch Name Product ID Product Name ... at an invoice Fact table

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 with distinct attributes

In the health care data analysis DW, the grain of one of my fact tables is the episode of care. How can I include procedure codes performed on an episode ? if I create a multi-valued dimension for it and used bridge tables to model this, it will end up

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

User Extension for Symfony/Lime code generation?

Hi, The topic says it all really. Has anyone written a SIDE user-extension that will generate code (pref PHP) for lime instead of PHPUnit? Thanks, -T

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

Pringles

are amazing.

Type your username with your elbow

DFde n azsdKJGH Holy crap that's the worst I've ever done xD

Topic/User honor system?

Ok here's the deal, i know there's stats and everything, but what if there was honors for topics and users. I know there's "Today's active topics," "Today's top 20 posters," and "Overall top 20 posters." But what if there