Tabular AMO 2012

23/06/2012

Great news on codeplex. it is very good to know that people are working hard to share their knowledge with the community. Tons of credits to JuanPablo Jofre! Tabular AMO 2012 is about creating and managing tabular models using the AMO api. It is a developer’s sample, for those interested in managing Analysis Services.The sample is made of two project parts. The first part is a library of functions to manage tabular models -AMO2Tabular V2-. The second part is a sample to build a tabular model -AdventureWorks Tabular AMO 2012- using the AMO2Tabular library; the created model is similar...
תגיות: , ,
תגובה אחת

Microsoft® SQL Server® 2012 Master Data Services Add-in For Microsoft® Excel®

The Master Data Services Add-in for Excel gives multiple users the ability to update master data in a familiar tool without compromising the data’s integrity in MDS. From within the Add-in, users can publish data to the MDS database with the click of a button. Administrators can use the Add-in to create new model objects and load data without ever launching any administrative tools, helping to speed deployment. With the Master Data Services Add-in for Excel, all master data remains centrally managed in MDS, while the ability to read or update the data is distributed to those who need...
תגיות: , ,
אין תגובות

Microsoft® SQL Server Integration Services Balanced Data Distributor For Microsoft® SQL Server® 2012

Microsoft® SSIS Balanced Data Distributor (BDD) is a new SSIS transform. This transform takes a single input and distributes the incoming rows to one or more outputs uniformly via multithreading. The transform takes one pipeline buffer worth of rows at a time and moves it to the next output in a round robin fashion. It’s balanced and synchronous so if one of the downstream transforms or destinations is slower than the others, the rest of the pipeline will stall so this transform works best if all of the outputs have identical transforms and destinations. The intention of BDD is...
תגיות: , ,
אין תגובות

BI User Group Meeting #30 (27.6.2012)

19/06/2012

שלום לכולם, ברצוננו להזמין אתכם למפגש קהילת ה - BI. המפגש הקרוב יתקיים ביום רביעי - 27.06.2012 במשרדי מיקרוסופט רעננה, אולם דקל. מצורף לו"ז לקראת המפגש. להרשמה והבטחת מקום חניה, יש להירשם באתר : http://www.eventbrite.com/event/3574825399 לו"ז ל Bi User Group Meeting #30(27.06.2012)   17:30  התכנסות 18:00    Microsoft 2012 In memory. 19:15  הפסקה 19:30   המשך 20:00  שאלות ותשובות המרצה: איתי בראון- משמש כ CTO ובעלים של Twingo   להרשמה והבטחת מקום חניה, יש להירשם באתר : http://www.eventbrite.com/event/3574825399 נשמח לראותכם! רונן חן ואיתי בראון
תגיות: , ,
אין תגובות

Get Cube Last Processed Date

14/06/2012

The common request to present the last process date of Cube XX can be solved by the ASSP project presented at codeplex. The function in the CubeInfo class is GetCubeLastProcessedDate. Thisfunction will return the date when the current cube was last processed.The following is an example MDX query against the sample Adventure Workscube: with member . asASSP.GetCubeLastProcessedDate()select . on 0from Download the project and carefully walkthrough the step by step.
תגיות: , , , , ,
2 תגובות

Microsoft® SQL Server® 2012 Data Mining Add-ins for Microsoft® Office® 2010

09/06/2012

link to download: http://www.microsoft.com/en-us/download/details.aspx?id=29061 Hot from the oven… Now you can use it in 64BIT as well Microsoft SQL Server 2012 Data Mining Add-ins for Microsoft Office 2010 (Data Mining Add-ins) helps you take advantage of SQL Server predictive analytics in Office Excel 2010 and Office Visio 2010. The download includes the following components: Table Analysis Tools for Excel: This add-in provides easy-to-use tasks that leverage SQL Server 2012 data mining models within Excel 2010 using either your spreadsheet data or external data accessible through your SQL Server 2012 Analysis Services instance. Data Mining Client for Excel:...
אין תגובות

SQL&BI on June 11th 2012 Daniel Hotel Herzelia

01/06/2012

Hi all! I would like to invite you to this event were I will walk you through a full day seminar on SQL 2012 end to end the complete BI solution. It will be DEMO oriented and lots of methodology & best practices. You can register here: http://www.microsoft.com/israel/sql-explore/content/Seminars/12067.aspx I am looking forwards to see you there! Ronen
אין תגובות

PerformancePoint 2010 Content Deployment Tool (2012)

The PerformancePoint 2010 Content Deployment Tool is a command-line tool that allows you to deploy PerformancePoint content using an existing ddwx file and can be used to migrate content from development to production or between site collections on the same SharePoint server.The tool allows you to: Re-map list locations - you can deploy content from one site to another site by specifying the new list location to deploy the content to Automatically deploy dashboards - by default, dashboards are automatically deployed to the previous path and master page Update server names and a ton of other...
אין תגובות

Things to notice in SQL Server Reporting Services in SQL Server 2012

SharePoint Mode Server References Require the SharePoint Site You cannot browse or reference directly to the Report Server using the virtual directly name in the URL path. For example: http://<Server name>/ReportServer It is now required that you include the SharePoint site in the URL path. For example, if your site name is ‘videos’ and used the ‘sites’ prefix, the URL would look similar to the following: http://<Server Name>/sites/videos/_vti_bin/ReportServer Changes to SharePoint Mode Command-Line Installation The input setting /RSINSTALLMODE only works with Native mode installations and it does not work for SharePoint mode installations. For example, the following is not...
תגיות: , ,
אין תגובות