About conformed dimensions?

HI,

Can any one tell about the meaning of conformed dimensions and use ?


kumar123 (BOB member since 2007-08-19)

[quote:212a218990=“data-warehouses.net”]A conformed dimension is a set of data attributes that have been physically implemented in multiple database tables using the same structure, attributes, domain values, definitions and concepts in each implementation.

Unlike in operational systems where data redundancy is normally avoided, data replication is expected in the Data Warehouse world. To provide fast access and intuitive “drill down” capabilities of data originating from multiple operational systems, it is often necessary to replicate dimensional data in Data Warehouses and in Data Marts.

Un-conformed dimensions imply the existence of logical and/or physical inconsistencies that should be avoided.
[/quote]

Note:
Conformed dimensions allow you to report against multiple fact tables and combine the result in one table.


Andreas :de: (BOB member since 2002-06-20)

Hi Kumar ,

Apart from what Andreas suggested :

Conformed dimesion are one whihc are commeon across datamarts e.g Time , Country etc

It promotes parallel design .

REgards
Sapan


swapnil_taz :india: (BOB member since 2006-04-06)

If only that were 100% true.

If you have 3 fact table.

Table A uses 3 dimensions, table B uses those 3 plus 1 extra, so 4, and table C uses the previous 4 plus another 1, then Webi does not just simply combine everything nicely.

It stops you from bringing all the dimensions into a single table due to the different granularities.


bungy :us: (BOB member since 2007-10-04)

Well, that goes without saying. Maybe, I should have clarified: If you are only using conformed dimensions and no dimensions, which only exist for some fact tables, but not for other fact tables in your data provider then…


Andreas :de: (BOB member since 2002-06-20)

I thought that “conformed” was defined as; being able to be shared across all fact tables.

One thing I would like BO to be able to do, is to handle shrunken dimension tables :).


Mak 1 :uk: (BOB member since 2005-01-06)

Its a pity that Webi doesn’t offer you the option of just cross joining if you want to.


bungy :us: (BOB member since 2007-10-04)

Can somebody please tell me about shrunken dimensions.
Thanks in advance:)


Navya (BOB member since 2010-06-24)

Shrunken dimensions…

http://forum.kimballgroup.com/dimensional-modeling-and-data-architecture-f6/date-dimension-t290.htm

http://intelligent-enterprise.informationweek.com/020101/501warehouse1_1.jhtml


Mak 1 :uk: (BOB member since 2005-01-06)

Aggregate awareness dear boy!

Hello Mark,

It was actually something we discussed here, in more detail, don’t know if you ever tried what you suggested…

https://bobj-board.org/t/148680/1

Unurprisingly, I still stand with my Shrunken dimension statement:-

Alhough, maybe I should have added the word “gracefully”… :mrgreen:


Mak 1 :uk: (BOB member since 2005-01-06)

I’ve got a feeling I’ll be restarting that blog project soon, so I’ll be covering it in there.

Cool :).

I will try and unearth my real-life example, although it was not date related, as per the examples we discussed before.
I came up with something the client was more than happy with, but just thought there should be a better way of dealing with it - maybe a data level solution.
I believe I did have to make the dimension Aggregate Aware…

Spk Soon,

Mark.


Mak 1 :uk: (BOB member since 2005-01-06)