Monster Dimensions

Rapidly changing Monster dimension...

Hi Everyone, I have a list of more than 300 attributes, which are actually part of the fact table.(basically ..these values changes for each transaction level record in fact but belongs to a single dimension). that lot contains more than a 100 date

monster build

is the jump from 200 def to 400 worth the time?

M-M-M-MONSTER KILL

My trusty MP5

monster class

wat is with the monster class tab i have how does it work?

Popy's NaNoWriMo entry: (Not) Everyone is a Monster

So, as November comes, I'll be using this topic as a sort of blog of how my story is coming (anyone who doesn't know about NaNo, go here: nanowrimo.org), and even post it in full (perhaps...most likely). Here's the summary: Two groups of students awake

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

How to manage Conformed dimensions

Hi, If I'm implementing data mart by data mart, I build a dimension for the first data mart. After a few months, I realize I can use that dimension for the second data mart as a conformed dimension. But it needs additional columns. How do you manage this

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

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

Cube Processing for Dimension Schema changes

Hi, I had a general question about how cube processing works. If my dimension schema changes (an addition of a property), will I have to do a full reprocess of all cube partitions for which that dimension was member of? Or do I only need to

Monster Ranks

These ranks were on hold for a long time, but now I had time and patience to finish them... So go ahead and tell your comments ...and of course empty one: Font is Times New Yorker, size 16 and color e79d00

MDX(or something else) for getting history based on last dimension characteristic for SCD.

Hi everyone, I am implementing a cube and I run into a problem with slowly changing dimensions(SCD type 2). I guess it might be resolved somehow with MDX or somehow else, maybe you guys can help me to resolve it. The problem: I have SCD, say Policy wit

Linking or Merging Similar dimensions from Different Source Systems

We've got a situation with the DW we're building where we have 2 seperate systems that we are wanting to bring the data together for cross analysis 1) The first system is the main operational system ie a contact management application that records