Enterprise AI & Cloud Architecture

There are three standard storage modes (MOLAP, ROLAP and HOLAP) Advantages & Dis-advantages of MOLAP, ROLAP and HOLAP In the OLAP world, there are mainly two different types : Multidimensional OLAP ( MOLAP ) and Relational OLAP ( ROLAP ). Hybrid OLAP ( HOLAP ) refers to technologies that combine MOLAP and ROLAP. MOLAP Excellent performance- this is the more traditional way of OLAP analysis. In MOLAP, data is stored in a multidimensional cube. The storage is not in the relational database, but in proprietary formats. Advantages: MOLAP cubes are built for fast data retrieval, and are optimal for slicing and dicing operations. They can also perform complex calculations. All calculations have been pre-generated when the cube is created. Hence, complex calculations are not only doable, but they return quickly. Disadvantages: It is limited in the amount of data it can handle. Because all calculations are performed when the cube is built, it is not possible to include a large amou...

How can I publish an Excel 2010 workbook to Excel Services 2010 running in SharePoint Server 2010? Create your Excel workbook: - Step 1 : Open your Excel application: - Step 2: Select an available template. In this post, I'm using the " Sales report " template from " Sample templates ." You can also enter or import your own data if you wish. Choose the " Sales Report " template The data table should look like this: - Step 3: Create an object (table, PivotTable, Named Range, etc.). I skipped this step for this post since my chosen template had already created them for me. Publish the workbook to Excel Services - Click the File button, select Save & Send , then Save to SharePoint : - Edit your publish options: - Click Save As : - Navigate to the site where you wish to save the workbook: - Enter your account: - Enter your account again: - Check your site to verify: - Select Site Pages  to see your result: ...

New Functionality Some of the features introduced in Microsoft SharePoint 2010 were put in place because of customer requests, and quite a few are simply an evolution of the SharePoint platform. In the end, the functionality was added to provide a richer experience to the user base. Microsoft Access Services You can now create, edit, and update Microsoft Access 2010 databases within SharePoint. These databases can be viewed and manipulated by using a Web browser, the Microsoft Access client, or a Web page that is linked to your site. Business Connectivity Services It is now possible to easily connect to external data sources. By using Office 2010, you are able to update external data sources to create, read, update, and delete (CRUD) items. Digital Asset Manager SharePoint 2010 has a library dedicated to managing and sharing digital assets such as audio, video, and other rich media files. With the Digital Assets library, multiple rich media files can be stored togethe...

How to access SharePoint information using code that executes on the SharePoint server itself. The rest of this chapter focuses on methods of accessing SharePoint data from remote locations, whether that means accessing SharePoint using HTTP, a client application such as Silver light, or web service. SharePoint 2010 provides a way of accessing list data using a Representational State Transfer (REST) interface. (Interfaces utilizing the REST interface are referred to as RESTful .) The RESTful interface provides a simple way for external applications to access and modify SharePoint data. It makes it possible to retrieve an XML representation of list data by simply supplying a URL. It ’ s possible to carry out basic CRUD (create, read, update, and delete) operations using the REST interface, by using the HTTP operations of POST, GET, PUT, and DELETE. By passing in various parameters with your URLs, it ’ s possible to a filter and sort the data that you get back. For your RESTful se...

CLASS NAME DESCRIPTION SPSite A site collection inside a web application SPWeb An individual site within a site collection SPList A list within a particular site SPListItem An item in a SharePoint list SPFolder A folder within a SharePoint site SPFile A document stored in a SharePoint list SPGroup A SharePoint group SPUser A SharePoint user SPContentType A content type SPField A column (either a site column or a list column, depending on its location) SPView The view on a particular list Note that an SPSite object represents a site collection, not a site.

A Comparison of Farm and Sandboxed Solutions More Info: FARM SANDBOXED Assemblies are placed in the GAC or in the Bin directory of a SharePoint web application. Assemblies placed in the GAC are fully trusted,whereas assemblies placed in the bin directoryof a web application can be partially trusted.  Assembly execution takes place in the web Server process (w3wp.exe). Any assemblies associated with a solutionare extracted, kept in memory, and executed within a special worker process called SPUCWorkerProcess.exe. This isolates the execution of sandboxed solutions from the Operations of the underlying web process. Solutions must be installed and deployed by a farm administrator Solutions can be installed and deployed by asite administrator There are no limitations on which SharePoint classes and objects can be used in farm solution Assemblies. Developers must leverage a subset of the SharePoint API when developing sandboxed Solutions. ...

SandBox Solutions  Although SharePoint enables end users to customize their SharePoint sites to a certain degree, some customizations can only be made by deploying custom code and custom assets to the server via a solution. However, only a farm administrator has the ability to deploy a solution to the farm. In some cases, farm administrators don ’ t have the available time to deploy solutions in a timely manner, leaving end users frustrated that their solutions are not being deployed as quickly as they would like. Furthermore, if a solution is deployed globally, particular features could become available to all site collections across the farm. This could be undesirable, especially in environments with hundreds or thousands of site collections, and especially in hosted environments in which one site - collection owner should be unaware of any activity in any other site collection on the server.   What Are Sandboxed Solutions? SharePoint 2010 has introduced the concept ...