VHF at 21h47
21
Jul
2009
General Ledger Account Number as Dimension Key
I am adding a General Ledger Account dimension to my DW. It will be populated from the chart of accounts table in our ERP system. Now, all the dimensions (product, customer, etc.) that I have previously designed have a proper surrogate key (SK), and I have never before been inclined to use a business/natural key as a DW dimension key.
However, for the General Ledger Account dimension I am sorely tempted to use the 5-digi
I am adding a General Ledger Account dimension to my DW. It will be populated from the chart of accounts table in our ERP system. Now, all the dimensions (product, customer, etc.) that I have previously designed have a proper surrogate key (SK), and I have never before been inclined to use a business/natural key as a DW dimension key.
However, for the General Ledger Account dimension I am sorely tempted to use the 5-digi
About
This topic belongs to the forum
Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.
- Numbers of topics : 1858
- Numbers of messages : 8714
- Numbers of users : 3801
- Numbers of points : 1672
Similar topics
...asked by AlertPay to add a bank account. the bank account is the 11 digits in the NIB, in case anybody doesn't know
dont remeber if first or last, but ill check if anyone needs
Hi,
I'm working on a project where dimensions have dates in them. An example is for a client where we have date of birth, joining date, date of death, etc. In fact i have about 6 different date columns.
Now, I'm trying to find out what the best
This seems to be missing on the Next3. It's not under settings.
I loaded the apk from Power Package 145, yet it doesn't show up anywhere.
Anyone have any ideas?
(Still working on Getting Market working properly...)
Regards,
raykj07
I came here with The Seldom Seen Kid under my arm and it wasn't long before the great and the good here were recommending I try out eariler works by the band. My wife recently bought me Leaders Of The Free World and Cast Of Thousands and I've been slowly
The significant dimension tables in our data model each contain 25 or so codes. Example currency code, category code
etc. Each of these dimension tables have different sets of codes i.e they do not share identical sets of codes. Each
code requires
Forums from same category
Free forum : hi. Free forum : 2709rsgamboa6219. Free forum,
Free forum : Forum IT Teknik Komputer dan Jaringan SMKN 1 SLAWI
LEGO Island Discussion, modding, news and more!
Techy Boards, a growing technology discussion forum! For fans of nintendo, xbox, playstation or anything else!
HmongThoobNtiajTeb. com/
Search
Informations
5 Replies For the topic :
"General Ledger Account Number as Dimension Key"
This topic has been viewed 3117 times.
Last message :
21/07/2009 at 21h47 by "VHF"






