Browse by Tags

Analysis Services Operations Guide
02 June 11 10:01 AM | Ronen Chenn | 2 comment(s)

---News alert--- Today 2/6/2011 the Analysis Services Operations Guide was published! In this guide you will find information on how to test and run Microsoft SQL Server Analysis Services in SQL Server 2005, SQL Server 2008, and SQL Server 2008 R2 in a production environment. The focus of this guide is how you can test, monitor, diagnose, and remove production issues on even the largest scaled cubes. This paper also provides guidance on how to configure the server for best possible performance. link...

תגים:SSAS, ITPRO, DEV, TECH, Analysis Services Operations Guide

BI חומרים נוספים ללימוד
25 March 11 06:53 AM | Ronen Chenn | with no comments

בנוסף לבלוגים קריאת ספרים וגוגלינג, תוכלו למצוא חומרים מעניינים גם ב TECNET ובMSDN- ריכזתי כאן מספר לינקים שיקצרו לכם את זמן ההגעה. SSAS - Multidimensional Data http://msdn.microsoft.com/en-us/sqlserver/cc510300.aspx SSAS - Data Mining http://technet.microsoft.com/en-us/sqlserver/cc510301.aspx PowerPivot for Excel http://technet.microsoft.com/en-us/bi/ff604673.aspx

תגים:SSAS, SSIS, LINK, DATAMINEING

Analysis Services Processing Options- glossary
16 April 09 02:01 PM | Ronen Chenn | with no comments

Processing Options Description Applied To Process Default Performs the minimum number of tasks required to fully initialize the object,server converts this option to one of other options based on the object state All objects Process Full Drops the object stores and rebuild the objects ,metadata changes ,such as adding new attribute to a dimension,requires Full Process All objects Process Update Applies member inserts,deletes, and update without invalidating the affected cubes. Dimensions Process...

תגים:SSAS, DEV

The ascmd command-line utility ( ascmd.exe )
15 April 09 09:48 AM | Ronen Chenn | 2 comment(s)

The ascmd command-line utility enables a database administrator to execute an XMLA script, Multidimensional Expressions (MDX) query, or Data Mining Extensions (DMX) statement against an instance of Microsoft SQL Server Analysis Services. This command-line utility contains functionality for Analysis Services that resembles the sqlcmd utility included with SQL Server. For more information, see the topic sqlcmd Utility in SQL Server. The execution results of the script, query, or statement can be stored...

תגים:SSAS, ITPRO, DEV, TECH, Analysis Services, ASCMD

SSAS 2008 Aggregation Manager
13 April 08 09:41 PM | Ronen Chenn | with no comments

At TechEd2008 at EILAT I was talking about SSAS2008 new feature. Well, one of them is the aggregation manager which is EMBEDDED in the visual studio. Those of you, who used it at the 2K5 version, had to download the N+BIDS HELPER from CODEPLEX and install it ... it was not so easy to install extension on the PRODUCTION machine, although it was quite good. Well 2K8 has it inside, with much more new feature. Such us union the aggregation you manually made with the usage based optimization. If you ask...

תגים:SSAS, AGGREGATION MANAGER, TechEd 2008