Jeremy Kashel's Blog - All Comments

re: Working with Images in Power View

Richard Back — Tue, 29 Nov 2011 16:25:35 GMT

Great practical tip on Power View. Its a really useful tool that I think people are going to take to.

re: Managing SSAS Named Sets with Master Data Services Collections

Jeremy Kashel — Tue, 29 Nov 2011 16:04:54 GMT

Hi Melissa,

My thoughts are that I hope not! I certainly haven't heard that they're going to be dropped, and I've noticed that the collections UI has been given a significant update in RC0. If I hear anything I'll be sure to post something...

re: Managing SSAS Named Sets with Master Data Services Collections

Melissa Coates — Wed, 09 Nov 2011 12:33:05 GMT

Hi Jeremy,

Thanks for the info! I proposed using Collections to my customer to solve a different but similar reporting need - however, we haven't implemented yet because I heard a rumor that Collections may become deprecated in a future version of MDS. Any thoughts on that?

Thanks!

Melissa Coates

re: Data Quality Services

Hennie — Tue, 26 Jul 2011 10:49:13 GMT

Great stuff. Myself also interested in DQS. Nice reading

re: Master Data Services in SQL Server Denali

Tomer (MSFT) — Thu, 14 Jul 2011 00:19:03 GMT

There will be easy upgrade from SQL Server 2008 R2 into Denali. You can use it to test your current models on Denali CTP3.

re: Master Data Services in SQL Server Denali

Jeremy Kashel — Mon, 11 Jul 2011 16:20:56 GMT

Hi,

I've heard that the underlying db hasn't changed much, aside from the fact there are now entity specific staging tables. So that looks good for migration, but I haven't heard anything concrete. Perhaps we'll learn more when CTP3 is (apparently) released this week.

re: Master Data Services in SQL Server Denali

David Grospelier — Mon, 27 Jun 2011 22:42:21 GMT

Hi,

I'm trying to find more details on the migration process from MDS Sql Server 2008 R2 to MDS in SQL Denali. Did you know if the migration path would be possible ?

Thanks.

re: New Master Data Services Book

Jeremy Kashel — Tue, 12 Apr 2011 05:17:12 GMT

Hi Sebastiaan,

MDS wil keep the history of your data by default. In your example, if you change the bike from blue to yellow, you can find out that it used to be blue from the transaction history.

To access this feature go to Explorer->Review->Transactions. You can also look at this across versions by looking in the Version Management feature.

Hope that helps

Jeremy

re: New Master Data Services Book

S Gerards — Thu, 07 Apr 2011 13:37:39 GMT

Hi Jeremy,

I am very exciting of hearing about a book of master data services. In June i am gone a buy it.

On this moment i am creating a prototype with Master data services. Only I have a question about it. On the internet I can't find a answer so I hope you now more about it.

Is there a possibility in MDS to keep history of the data. Example: I have a bike in blue color. I change it to yellow. Now i will see that the bike is now yellow but that he was blue.

If you have any input for me, i'd like to hear from you.

Thanks

Sebastiaan

re: Explicit Hierarchies Vs Recursive Hierarchies in MDS

Xavier Averbouch — Wed, 23 Feb 2011 23:45:50 GMT

very interesting blog

thanks!

re: Master Data Services - Business Rules

adet — Thu, 28 Oct 2010 01:13:49 GMT

hi, I would like to add complex business rules. I have a date attribute.

e.g.

Day(DateColumn) is not equal 15 OR Day (DateColumn) is not equal 30

then

action

re: Master Data Services Subscription Views

Pulkit — Thu, 21 Oct 2010 11:25:41 GMT

good explanation...may be if you can specify with more example and actual views would be really helpful..may be I am being just a child to be spoonfeeded...:)

re: Analysis Services KPIs and Reporting Services 2008 R2

Jeremy Kashel — Thu, 17 Jun 2010 20:21:19 GMT

I agree, if there was something that was re-usable across all parts of the MS BI stack then it would certainly come in handy. The formatting part in SSRS is pretty easy though, they've done a slick job on the interface.

re: DAX Closing Balances

barrys — Mon, 14 Jun 2010 04:08:27 GMT

niiiice

re: Analysis Services KPIs and Reporting Services 2008 R2

Peter Eb. — Thu, 27 May 2010 16:55:34 GMT

Long term, I'd love to see something like a KPI abstraction that is re-usable in Excel, AS, SSRS and PPS (aka all the reporting tools). I think this has the potential to be a big time saver. But maybe the formatting is so easy to use it's not a big deal?