Data modeling enhancements were prioritized really high in AX 2012. I already mentioned one earlier – table inheritance, but there are a lot of other important features about data modeling.
One such feature is the support of surrogate keys. Surrogate keys recommended themselves as a very good solution for complex databases because of their beneficial properties, like immutability, robustness to redesign and performance. And now this best practice is coming to AX. It is the recommendation for AX 2012 to use surrogate keys for all new tables, unless there is a good reason not to do so.
Actually, previous versions of AX already have surrogates – RecIds. And it was possible to introduce surrogate key just by setting CreateRecIdIndex table property to Yes. But there is a problem with the inconvenience of working with surrogates in the UI. Imagine InventTable using surrogate key and all other tables that have relations to InventTable using its surrogate key as a foreign key. Then on any form where ItemId should be displayed (let’s say on the SalesTable) an extra join to InventTable will be needed to fetch the ItemId. And what if user can change the item? Then even more custom logic is needed to resolve the entered ItemId to the corresponding surrogate key value and write it to the SalesLine.
This inconvenience actually was a showstopper. But not anymore. AX 2012 got kernel support for surrogate key substitution. And not only in forms, but in Axd document services and even in the debugger.
Let me show an example of how it works:
UnitOfMeasure table uses surrogate key as a primary key. However, the user-friendly identifier of the UnitOfMeasure table records is the UnitOfMeasureSymbol field. This field is a part of the SymbolIdx index, which is specified as a replacement key on the UnitOfMeasure table.
This setup basically means that surrogate key values (RecIds) of the UnitOfMeasure table records will be automatically substituted in the UI with the replacement key values (UnitOfMeasureSymbols).
UnitOfMeasureConversion table has a relation to the UnitOfMeasue table through the surrogate key.
As you can see, on the UnitOfMeasureConversion form there are only UnitOfMeasureConversion datasources. And you can notice new ReferenceGroup control which is bound to the FromUnitOfMeasure field (which contains surrogate values).
And in the UI it will look just like UnitOfMeasureSymbol field is shown instead. And it can also be modified and that will be handled automatically, without a single line of code.
Actually ReferenceGroup control has much more interesting capabilities and thus deserves a separate post.
SFK FTW
ReplyDeleteGood info - I've added an example and linked back to your post at http://axinternals.blogspot.com/2011/10/preview-parts-and-surrogate-keys-in.html
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteExcellent post. I was checking continuously this blog and I am impressed!
ReplyDeleteExtremely useful information specifically the last part :) I care for such information a lot.
I was looking for this certain information for a long time.
Thank you and best of luck.
My weblog ... online backup free
Stop by my homepage online backup free
At this time it sounds like Drupal is the preferred blogging platform available right now.
ReplyDelete(from what I've read) Is that what you are using on your blog?
Look at my page - unlimited online backup
Also visit my website :: online backup solution
In thіѕ tоwn, should you bе already succeѕsful then уоu're wanted. Tunakie happens to be recording within new company, of which she is often a 100% owner, in accordance with her Facebook page. The screenwriting industry is a tough nut to crack and writers with connections, referrals and networking opportunities have better chances to get their scripts within the right hands.
ReplyDeleteFeel free to visit my web blog - what can I do with a degree in entertainment management
Some from thе mаnagement jobs гeadily avaіlаble for those ԁevelopіng a
ReplyDeletebusinеss admіnіѕtгatіon majοr include јobs liκe investment banking and business analyѕt, beѕides job as
adminiѕtration seгvicе managers, advertiѕing, promotiоns, sales,
and ρubliс relatіοn managеrs, computer and іnformation system managers, eduсatіon aԁministratіon managers,
financial mаnagers, human resоurсe
managers, and medical anԁ health sеrѵіce managers.
Thiѕ degreе will lіkelу provide you wіth concepts for
teаm аnԁ gгoup leadership, as well as the еxecution of еffective solutions for
various buѕiness aρplications. Students figure out how to ргovide
sіgnificant contributiоn in pгοblem solving fоr
management, business laω, oгganizatіonаl
leadership, accountіng, stratеgiс ρlanning, and marketing.
mу web-site; online universityies
Aѕ the admin оf this webѕite is working, no uncегtainty νerу shortly it will be famоuѕ, due to its feаturе cοntentѕ.
ReplyDeleteAlso visit my web site: center for health and homeland security salary
Even along wіth your acсuserѕ, mаintain a professiоnal аttitudе.
ReplyDeleteЅafe seх is rеally а healthy part of most relatiоnѕhips
which enаble it to impгοve thе a ѕеnse togetherness within the
relationshiρ. Therefore, juѕt to ωalk by
a ρersοn crеаting a heаrt attack is usuаlly tο also
disregard the suffering you pеrѕonalу
arе еxperiencing.
Alsο visit my web ρage - tao Of badass
Prοgrams: Getting to the ρrogгam οf your
ReplyDeleterеѕpectiѵе chοiсe, it much eаsier іn case you staгt out
in a communіtу college. While lеarning aerοnautіcal engіneering is both demanding and adventures, іs actuаlly
a rewarding career. Jіmmу Johnson's success about the field was extensively recorded; being fresh off a National Championship as head coach in the Miami Hurricanes.
Look into my website :: Missouri school counselors salary
With this in your mind, theге's vast array of weight-loss programs out there; yet they need not be an elaborate as one may think. It is evident, in s Weight Loss Challenge, who has not been drainking their daily intake of water. One of which situation is due to certain sports.
ReplyDeleteAlso visit my web page; adiphene scam
Pеnn & Tellеr's rep notes how the some shows with the Rio Hotel and Casino happen to be canceled due for the duo's sсheduleѕ.
ReplyDeleteLindsау-Abаire was гecently nοmіnatеd fог the Grammy Awаrd (Beѕt Musіcаl Show Album) аs
well as Τоny Awards (Βest Boоκ of thе Мusical and Best Ѕcore) for his ԁevelop Ѕhrеκ
Τhe Musical. The ρrосeԁure is peгfoгmed іn a
non-POS locatіon.
Feel frеe to ѕurf tο mу hοmepage: how much does a bank teller make an hour in indiana
私は知っている個人人使用彼ら 'ルイヴィトンs' すべて12
ReplyDeleteヶ月ラウンド。それです潜在的なもために行く機器は特徴earthtones とレトロ-触発テーマ。リラクゼーション の 世界 としてそれらが好きです ずいぶん としてオーストラリアを行う。
覚えている、感覚 の折り返しの 自分で で、高齢者 リラックスした カリカリのセーター ドロップ 一日?
Feel free to surf to my blog: ルイヴィトン
Caո I simply just say what a relief to find sopmeone who genuinely nowѕ what they are
ReplyDeletetalking about on the web. Ύooս actually understwnd ɦow tߋ bring a probldm to light ɑnd make it important.
More people must cɦеck thiks out annd understand this sde of
the stоry. I was sսrprіsed you arre not more рopular becɑuse you surely hаve ttɦe
gift.
Prime Lending 247
Do you have a spam problem on this blog; I also am a blogger, andd I was
ReplyDeletewantin to knopw your situation; we have developed
some nice practices and we are looking tto exchange solutions with oter folks, please shoot me
an email if interested.
Here is my website :: mobile reviews
nike trainers, longchamp, abercrombie and fitch, ralph lauren, longchamp, polo lacoste, polo ralph lauren, nike tn, michael kors, timberland, converse pas cher, nike blazer, ray ban sunglasses, michael kors, air max, nike air max, sac louis vuitton, barbour, nike free, north face, vans pas cher, oakley pas cher, mulberry, sac guess, sac hermes, vans shoes, sac louis vuitton, vanessa bruno, nike roshe run, louis vuitton, nike roshe, sac longchamp, nike free pas cher, abercrombie and fitch, lululemon, sac burberry, hollister, hollister, louboutin, air force, nike roshe run, louis vuitton uk, north face, nike huarache, ray ban pas cher, hogan outlet, mac cosmetics, new balance pas cher, michael kors pas cher, hollister
ReplyDeletecanada goose, bottega veneta, ghd, hollister, moncler, ugg, canada goose outlet, north face outlet, ugg boots, soccer shoes, canada goose, chi flat iron, uggs outlet, insanity workout, canada goose uk, new balance shoes, iphone 6 cases, north face jackets, babyliss pro, lululemon outlet, air max, beats by dre, marc jacobs, moncler, asics running shoes, moncler outlet, giuseppe zanotti, valentino shoes, jimmy choo outlet, celine handbags, p90x, birkin bag, mcm handbags, reebok outlet, ugg australia, wedding dresses, canada goose, soccer jerseys, ugg boots, rolex watches, mont blanc, nfl jerseys, instyler, ugg pas cher, moncler, timberland boots, herve leger, baseball bats, canada goose jackets, ferragamo shoes
ReplyDeleteI think the things you covered through the post are quiet impressive, good job and great efforts. I found it very interesting and enjoyed reading all of it
ReplyDeleteVMware Virtualization Online Training | Sharepoint Training
pandora, hollister, insanity workout, gucci, mcm handbags, michael kors outlet, ralph lauren, adidas, mac cosmetics, <a
ReplyDeleteray bans uk
ReplyDeleteugg outlet online
adidas nmd r1
coach factory outlet
moncler sale
uggs outlet
giuseppe zanotti shoes
polo outlet
ray ban glasses
christian louboutin sale
201612.10chenjinyan
Embedded system training in chennai
ReplyDeleteBest Embedded system training in chennai
Embedded training in chennai
Embedded system training institute in chennai
Embedded system
Embedded training
Embedded system courses in chennai
Matlab training in chennai
Arduino training in chennai
Autocad training in chennai
Best embedded training in chennai
It have been a while since i found this kind of a post, its very interesting and fascinating. The topic on Surrogate keys in AX 2012 is quite complex, but once i read through the content i realized that everything is easy to understand. I therefore feel very informed.
ReplyDeleteDissertation Chapter 4 Analysis
تور تایلند
ReplyDeleteHello!!!Nice post! I was checking constantly this
ReplyDeleteblog and I'm impressed! Very helpful information particularly the last part :) I care for such information a lot. I was looking for this particular info for a long time.
Dallas Cowboys Game
ReplyDeleteCowboys Game
Watch Cowboys Game
Cowboys Game Live
Dallas Cowboys Game Live
Cowboys Game Live Stream
Dallas Cowboys Live Stream
Cowboys Live Stream
Green Bay Packers Game
Packers Game
Watch Packers Game
Packers Game Live
Green Bay Packers Game Live
Packers Game Live Stream
Green Bay Packers Live Stream
Packers Live Stream
Denver Broncos Game
Broncos Game
Watch Broncos Game
Broncos Game Live
Denver Broncos Game Live
Broncos Game Live Stream
Denver Broncos Live Stream
Broncos Live Stream
NHL Live Stream
NHL Live
NHL Live Stream Reddit
NHL Live Streaming
NHL Live Streaming Free
Watch NHL Online
NHL Hockey Live Stream
his article is very helpful at all thanks
ReplyDeleteObat Penyakit Asam Urat
I read the entire article and I am really impressed. This is great advice for the readers.
ReplyDeleteVisit us: Tummy tuck surgery
The article is very helpful, thanks for sharing information
ReplyDeletePengobatan Alami Atasi Susah Kencing
Pengobatan Kencing Batu
Pengobatan Untuk Mengikis Batu Ginjal
Tips Mengobati Radang Usus Buntu
Pengobatan Atasi Ruam Di Kulit
Obat Radang Pembuluh Darah
Thanks for sharing an useful information we appreciate your valuable information and it usefulness.Sunbridge Software Solutions Pvt. Ltd. Is a Microsoft Dynamics partner practising more than decade has worldwide customer footprints. Microsot Dynamics 365 service provider in India. We offer Microsoft Dynamics AX, CRM and NAV making it your all-in-one Microsoft Dynamics 365 business edition partner Apart from providing the perfect software for your company, we also offer software implementation, support and training. Contact us: Email: info@sunbridgeindia.com, call us: +91(20) 22953290
ReplyDeleteGreat post you have there. It has enlightened me and added knowledge about the subject. You can also look at GIS homework help.
ReplyDeleteThanks for sharing your ideas. I really liked your post. You shared a detailed post about surrogate keys in AX 2012. This is an informative post. I am delighted to read this amazing post. Get help from dissertation writing services , a leading writing company UK.
ReplyDeleteThis is a great post. If you want to get high grades, then try our expert writers and enjoy 100% result.
ReplyDeleteInteresting and engaging read. You may also check the best online expert writers for help with your assignment or research project.
ReplyDelete
ReplyDeleteI bought subscription on nflhdnetwork.com for 29.97$/year and I am wanting every NFL Game Live in online HD. I can extraordinarily recomend it for you if you ar in work or merely do not have TV around you. nflhdnetwork.com is the best Tv broadcaster of this year.
.
Last year I paid a lot of money for NFL network. NEVER AGAIN ! Now I am watching NFL online via NFLHD .COM . Probably you already know but I want to remind you that NFLHDTV has NFL games in their price. It's only $39.99/yearly so I suggest to go to NFLHD .COM and buy subscription there
ReplyDeleteSuper Bowl 2021 Live
Super Bowl LV Live
Super Bowl LV Streaming
NFL Super Bowl LV Live Stream
Super Bowl LV Live
NFL Super Bowl LV Streaming
NFL Super Bowl LV Stream
NFL Super Bowl 2021 Live
NFL Super Bowl LV Live
NFL Super Bowl LV Streaming
NFL Super Bowl LV Live Stream
NFL Super Bowl LV Live
NFL Super Bowl LV Live
NFL Super Bowl LV Streaming
NFL Super Bowl LV Stream
Super Bowl 2021 Live
NFL Super Bowl LV Live
NFL Super Bowl LV Streaming
NFL Super Bowl LV Live Stream
Super Bowl Live
Super Bowl Live
Super Bowl Streaming
NFL Super Bowl Stream Super Bowl 2021 Live
FL Super Bowl LV Live
NFL Super Bowl LV Streaming
NFL Super Bowl Live Stream
Super Bowl Live
Super Bowl Live
Super Bowl Streaming
NFL Super Bowl Stream
NFL 2020-21 Super Bowl Live Stream
How it affects the start of the 2020 season, the game is scheduled to be played on February 7, 2021, in Tampa, Florida. This will be the fifth Super Bowl hosted by the Tampa area and the third one held at Raymond James Stadium.
Stadium: Raymond James Stadium, Tampa, Florida.
Date: February 7, 2021
Every nursing assignment has different requirements that students have to consider such as formatting, and the manner in which they have to structure their arguments. It is a challenge when you have little time to prepare how to write your paper because you have to research some relevant concepts that you have to include in your article. Besides, you also have to master the correct citation for the nursing paper because such elements give you more points for your degree. You need a higher grade to graduate and get your career going. Hence, you need a lot of knowledge, writing competence, and experience to write an excellent nursing paper. Nevertheless, you do have to worry if you are unable to do so; has qualified and experienced nursing experts who can help you out.
ReplyDeleteChoosing to work with our cheap essay writing services for nurses means you understand the need to make the best use of your money. Many companies are offering similar services, but the difference lies in the quality of the papers they provide students with and their reliability. You probably do not want to have writers who barely know anything about nursing to work on your writing. In most cases, such companies have charged students exorbitantly but ended up giving their clients pre-written documents that have put their careers on balance. We takes a different approach to work with students and nursing professionals. Instead of urging you to buy nursing essays from us, we recommend you to make us part of your career journey because we have experts who work with you on your paper every step of the way. We research and write your article from scratch. We also have a committed team that will provide you with reliable nursing editing services to ensure you present a paper with no mistakes.
I have heard of him before, but after watching his documentary “healing spell” I was turned on to the full story about Dr Ikpeajie. He is a man who has the Cure for AIDS,Cancer, Sickle Cell, Herpes,warts,HPV,ALS Diabetes and every kind of illness, through a whole foods vegetarian diet and natural herbs, what he calls Electric Foods. He went to herbal school college, and has thousands of testimonials of healing people with Herpes, HIV AIDS, and HPV several other illnesses. Lisa “Left Eye” Lopes of TLC was cured of Herpes by him and she was so moved by his knowledge that she went on to spread the word about him in every way she could. She also opened a Cultural/Healing Center for Children in USA before she passed away tragically. This all inspired me that i had to contact Dr Ikpeajie, because i was having Herpes which could not be cure but was only managed, when i contacted Dr Ikpeajie, he sent me some herbs which i took, and now i can tell you, i have be totally cured of Herpes, My Name is chas, I am from the hartford, Please if you have any form of illness especially STD,Infertility,HIV etc. you can contact him immediately through his Email:drikpeajieherbalhome@yahoo.com or whatsapp :+254778109549
ReplyDeleteFreshly harvested millets, Rich in nutrition Healthy Diet shipped directly from a farmer Support Indian farmers and eliminate middlemen. Naati Grains has revolutionized the concept of “purity” by processing natural products in very natural ways.
ReplyDelete80/1, 36th Main, Dollars colony, Madiwala, BTM 1st stage, Near sub Registrar office. Bangalore – 560068, India
Email : info@naatigrains.com
Contact : 9739381414
betmatik
ReplyDeletekralbet
betpark
tipobet
slot siteleri
kibris bahis siteleri
poker siteleri
bonus veren siteler
mobil ödeme bahis
AT1DSF
tipobet
ReplyDeletebetmatik
poker siteleri
kralbet
betpark
slot siteleri
kibris bahis siteleri
bonus veren siteler
mobil ödeme bahis
7DG22K
شركة مكافحة القوارض
ReplyDeleteشركة تنظيف شقق
This is a wonderful blog. If you need help in writing customized essays, creative papers, articles, research papers, thesis, capstone projects, homework and assignments, contact me at onlinefreelancersnetwork.com
ReplyDeleteThanks for posting and discussion of the topic surrogate keys in ax 2012, and provide an important information. I really like this blog.
ReplyDeletedental clinic in patna
شركة صيانة افران بالاحساء mNuxQ6hlPl
ReplyDeleteشركة تسليك مجاري بالاحساء iw3QrEeJ3D
ReplyDeleteشركة مكافحة حشرات ابوظبي ITWqtsBKsh
ReplyDelete