Important This scenario applies only to SharePoint Server 2013 Enterprise.
#Adventureworksdw2012 database download how to#
This article describes how to install and configure the AdventureWorks sample data set and configure a Business Intelligence Center on your SharePoint Server 2013 farm. The subsequent articles in this section make use of this sample data to demonstrate Business Intelligence capabilities in Excel, Excel Services in SharePoint Server 2013, and PerformancePoint Services. The AdventureWorks sample data set provides a sample database, data warehouse, and OLAP cube.
If you try to install and get it working with a Java project you might run into a few problems. The fourth is multi which makes the query update every document that matches the criteria (false by default meaning that it only updates the first one). As shown, we can use addToSet, which won't add a duplicated value to an array:The third parameter of update is upsert(false by default). Unfortunately Scott already has got movies in his loves field.
This post is a mini-tutorial on how to deal with array fields in MongoDB, specifically arrays of items that may or may not be duplicated.Let's create a collection of unicorns, smilarly to examples: Find should now return something like this, the will vary:Adding a value into an arrayWe've found out that our unicorn Scott also loves playing games, so lets a new value into our document's loves array:Using push, we could insert into our the same value multiple times.Pushing a value if its uniqueWe have found out that all our unicorns love movies and want to update the whole collection. Please let me know if this post has helped you or if you find anything to improve.