tag:blogger.com,1999:blog-16888062.post6341776580346445776..comments2023-12-30T03:34:56.205-05:00Comments on Nick Barclay: BI-Lingual: Beginning MDS – Getting at the Data with TSQL (Part 7 of 7)Nick Barclayhttp://www.blogger.com/profile/16606624539083402212noreply@blogger.comBlogger10125tag:blogger.com,1999:blog-16888062.post-87834021882259496012011-05-31T06:09:26.930-04:002011-05-31T06:09:26.930-04:00Hi Nick,
Very good article thank you. I found whe...Hi Nick,<br /><br />Very good article thank you. I found when digging into mdm.tblAttribute - instead of DataType_ID = 1, shouldn't it read AttributeType_ID = 1 to filter for user defined attributes?<br /><br />Kevin PickeringAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-16888062.post-39122008701404713892010-04-23T06:45:58.794-04:002010-04-23T06:45:58.794-04:00Thanks Nick. I'll have a look at it.Thanks Nick. I'll have a look at it.Subhasisnoreply@blogger.comtag:blogger.com,1999:blog-16888062.post-56825367363743891242010-04-22T09:10:00.895-04:002010-04-22T09:10:00.895-04:00You can export model data from within the Manageme...You can export model data from within the Management UI.<br /><br />As for updating an external DB this is something you would want to explore the MDS API - it would be a custom dev effort on your part.Nick Barclayhttps://www.blogger.com/profile/16606624539083402212noreply@blogger.comtag:blogger.com,1999:blog-16888062.post-26737255877861858832010-04-22T08:45:14.449-04:002010-04-22T08:45:14.449-04:00Seperate database, the database from where we are ...Seperate database, the database from where we are pulling the records, eg. AdventureWorksDW2008R2 database. Also, I need to know how Export option is performed.<br /><br />Thanks.Subhasisnoreply@blogger.comtag:blogger.com,1999:blog-16888062.post-39517790431906398872010-04-22T08:13:58.195-04:002010-04-22T08:13:58.195-04:00"source database" - do you mean the MDS ..."source database" - do you mean the MDS repository database or another separate DB?<br /><br />NBNick Barclayhttps://www.blogger.com/profile/16606624539083402212noreply@blogger.comtag:blogger.com,1999:blog-16888062.post-11922412830375170212010-04-22T06:52:07.000-04:002010-04-22T06:52:07.000-04:00Hi Nick,
It was a wonderful article on MDS to sta...Hi Nick,<br /><br />It was a wonderful article on MDS to start with. I have a question. Can I insert or update data into the tables of the source database through MDM? <br /><br />Thanks,<br /><br />RoySubhasisnoreply@blogger.comtag:blogger.com,1999:blog-16888062.post-29969769112479311032010-03-09T18:01:52.210-05:002010-03-09T18:01:52.210-05:00As an EDM user i am very happy for these blogs.
So...As an EDM user i am very happy for these blogs.<br />Some thinks are very familiar, other are interesting new concepts.<br />Waiting to find more.<br />Thanks for the info you have forwarded..Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-16888062.post-13018045571503733822010-02-12T09:18:19.954-05:002010-02-12T09:18:19.954-05:00Glad you found it useful :)Glad you found it useful :)Nick Barclayhttps://www.blogger.com/profile/16606624539083402212noreply@blogger.comtag:blogger.com,1999:blog-16888062.post-40898293519746741002010-02-11T09:56:29.756-05:002010-02-11T09:56:29.756-05:00Thank you very much for this post. I actually fou...Thank you very much for this post. I actually found it much more helpful to understand than the EDM documentation/training manuals that I've seen.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-16888062.post-20237031084820119992009-11-26T18:19:26.678-05:002009-11-26T18:19:26.678-05:00Hi Nick
I am a bit curious about you wanting to d...Hi Nick<br /><br />I am a bit curious about you wanting to dig into the tables inside MDS. Have seen some other posts around the place wanting to do the same thing. I always understood one of the key aspects of a product such as this was to protect us from these complexities and protect itself from those wanting to fiddle under the hood where they can perhaps cause some damage. The views provided by the product (which have progressively increased in number and variety through the +EDM versions) should cover most requirements.<br /><br />Otherwise, I am glad to see MDS getting some exposure. Over the last few years (with +EDM) we have seen several cases of politics and people getting in the way - particularly some IT bods who wanted to do it all their own way and not let users anwyhere near the master data.<br /><br />On another front, I don't think MDS is as immature a product as some might think. It started as a dimension management tool to support cubes before the broader application became obvious. +EDM was at version 4 just before becoming MDS, and prior to that was recognised as one of the major players in a field of 5 or 6 products. It has just been hard to spot for a couple of years while being transformed into MDS.<br /><br />Also wondering if the old +EDM manuals and training material will be re-jigged for MDS - might save you some typing :)<br /><br />Looking forward to seeing a lot more appearing about MDS in use for specific business issues.<br /><br />CheersMartin Harmelinhttps://www.blogger.com/profile/11684623156856639578noreply@blogger.com