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 to the 'AdventureWorks Tabular Model 2012', available for download here: http://msftdbprodsamples.codeplex.com/downloads/get/353143.
The intentions around the AMO2Tabular library were to provide the most complete guide on how to write AMO code to manage the different logical objects in a tabular model. Not all functions to manage tabular models are implemented in the library; but, I expect the necessary knowledge to complete the library is included in the AMO2Tabular source code. Also, I expect you to contribute to the library; once you find that certain functionality was not included and you have to implement that functionality, please consider donating your code to expand the library.
The scope of the library comprehensive, in the sense that it has functionality for all tabular objects. However, as mentioned earlier, it is not extensive; it does not necessarily cover all possible operations on every tabular object. If coding certain operation, on a particular object, is not an obvious solution, you can be certain that I have included that operation in the library; what remains to be seen is what you consider obvious vs. what I do (I just hope there is not too much difference here).
The 'AdventureWorks Tabular AMO 2012' sample was designed with two purposes in mind. The first purpose was for it to be a test bed for the library; where most of the functionality of the library could be tested. The second purpose was to have a sample on how to use the library to build and manage a tabular model; also, the model created by the sample should have enough complexities to be a good showcase of the capabilities of the library.
The downloadable file contains one solution -Tabular AMO- with both projects: AMO2Tabular and 'AdventureWorks Tabular AMO 2012'.

See the Readme file for a quickstart; or, see the Setup and Execute file for a detailed explanation on building the tabular model.

• Read more
• No comments

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 it.
The Master Data Services (MDS) Add-in for Microsoft Excel is a data management tool that delivers a multitude of master data management capabilities with ease and efficiency. Manage MDS data within an interface you already know and love – Microsoft® Excel. Leverage existing Excel functionality to share your managed lists with others, knowing these lists can be secured and monitored with all of the features provided by Master Data Services.
The Master Data Services Add-in for Excel gives multiple users the ability to update master data in a familiar tool while maintaining 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 it.

• Quickly and easily load new managed data sets into the Master Data Services database.
• Administrators, easily create new entities to store sets of managed data.
• Make bulk data changes to pre-existing models.
• Correct all issues discovered through the validation process and seamlessly publish updates to the MDS server.
• Add and update columns in your entities with a few clicks, creating constrained columns on the fly.
• Send defined queries to other users through Outlook Email for a rich collaboration experience leveraging Master Data Services Security
• Determine data matches with the new Data Quality Services for SQL Server 2012

Click here for download.

• Read more
• No comments

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 to improve performance via multi-threading. Several characteristics of the scenarios BDD applies to: 1) the destinations would be uniform, or at least be of the same type. 2) the input is faster than the output, for example, reading from flat file to OleDB.
NOTE: An updated version of Microsoft SSIS Balanced Data Distributor (BDD) is available. This includes a fix for the problem causing BIDS to crash when removing the BDD transform.

For more details, and download information, see KB 2616527.

• Read more
• No comments

שלום לכולם,

ברצוננו להזמין אתכם למפגש קהילת ה - BI.

המפגש הקרוב יתקיים ביום רביעי - 27.06.2012 במשרדי מיקרוסופט רעננה, אולם דקל.

מצורף לו"ז לקראת המפגש.

להרשמה והבטחת מקום חניה, יש להירשם באתר :

לו"ז ל Bi User Group Meeting #30(27.06.2012)

17:30  התכנסות

18:00    Microsoft 2012 In memory.

19:15  הפסקה

19:30   המשך

20:00  שאלות ותשובות

המרצה:

נשמח לראותכם!

רונן חן ואיתי בראון

• Read more
• No comments

This update contains hotfixes for issues that were fixed after the release of SQL Server 2012.
The build number of this cumulative update package is 11.0.2325.0.

The complete hotfixes that are included in this cumulative update package can be found here:

http://support.microsoft.com/kb/2703275

• Read more
• No comments

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. This
function will return the date when the current cube was last processed.
The following is an example MDX query against the sample Adventure Works
cube:

with member [Measures].[LastProcessed] as
ASSP.GetCubeLastProcessedDate()
select [Measures].[LastProcessed] on 0
from [Adventure Works]

Download the project and carefully walkthrough the step by step.

• Read more
• 2 comment(s)

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: By using this add-in, you can create, test, explore, and manage 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 Templates for Visio: This add-in enables you to render and share your mining models as annotatable Visio 2010 drawings.
• link to download: http://www.microsoft.com/en-us/download/details.aspx?id=29061

• Read more
• No comments

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

• Read more
• No comments

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 properties - you can update the server name (and other properties) of data sources, reports, and dashboards to update them from development values to production values without manual steps.

you can download the tool and read more about it here

• Read more
• No comments

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 supported in SQL Server 2012: /RSINSTALLMODE="DefaultSharePointMode”. In place of that input setting, use /RSSHPINSTALLMODE="DefaultSharePointMode".

The following statement is an example of a complete installation command and parameter set: setup /ACTION=install /FEATURES=SQL,RS /InstanceName=Denali_INST1 …. /RSSHPINSTALLMODE="DefaultSharePointMode"

For more information on command-line installations, see Command Prompt Installation of Reporting Services SharePoint Mode and Native Mode.

The Reporting Services WMI Provider no longer supports Configuration of SharePoint Mode

The Configuration of Reporting Services SharePoint is now completed using PowerShell cmdlets and SharePoint Central Administration. The new SharePoint mode architecture utilizes the SharePoint services architecture. SharePoint does not support WMI interfaces.

These changes affect the following list of components and work flows:

• Custom applications that use the Reporting Services WMI provider for Reporting Services in SharePoint mode.

• The Reporting Services Configuration Manager, rskeymgmt.exe, and rsconfig.exe. Instead of using those utilities for configuration of Reporting Services SharePoint mode, use SharePoint Central Administration and PowerShell.

• SQL Server Management Studio: Customers cannot reference a server with syntax similar to <machine_name>/<instance_name>. Starting with the SQL Server 2008 release, the recommended method was to use a SharePoint site URL. For example, http://<sharepoint_server>/<sharePoint_site>. Starting with SQL Server 2012, a SharePoint site URL is the only supported syntax.

Report Model Designer is not available in SQL Server Data Tools

SQL Server Data Tools (SSDT) no longer supports report model projects. The Report Model designer is not available in SQL Server 2012 Reporting Services (SSRS). You cannot create new Report Model projects or open existing projects in SQL Server Data Tools (SSDT) and you cannot create or update report models. To update report models, you can use SQL Server 2008 R2 Reporting Services or earlier tools. You can continue to use report models as data sources in reports authored in SQL Server 2012 Reporting Services (SSRS) tools such as Report Builder and Report Designer. The query designer that you use to create queries to extract report data from report models continues to be available in SQL Server 2012 Reporting Services.

• Read more
• No comments