יום ראשון, מאי 22, 2016
Finally and as folowing the UserGroups request, I have updated the Assemblies for the SQL SERVER 2016 SSAS and TABULAR.
You can download the new Activity Viewer at https://activityviewer2016.codeplex.com/releases
please feel free to leave positive feedback :-)
יום שבת, ספטמבר 28, 2013
New version of Activity viewer for SQL SSAS 2012 is ready:https://activityviewer2012.codeplex.com/releases/view/112680
יום רביעי, יולי 10, 2013
The easier method to to this if you already have the measure group built is:Right click on the cube on the Cube Structure tab and select new measure. Then select DistinctCount as the usage, then your measure to count and it will automatically be created in a new Measure Group.
יום ראשון, ינואר 20, 2013
In Excel 2013, you can create data models containing millions of rows, and then perform powerful data analysis against these models. Data models can be created with or without the PowerPivot add-in to support any number of PivotTables, charts, and Power View visualizations in the same workbook. Although you can easily build huge data models in Excel, there are several reasons not to. First, large models that contain multitudes of tables and columns are overkill for most analyses, and make for a cumbersome Field List. Second, large models use up valuable memory, negatively affecting other applications and reports that...
יום חמישי, יוני 2, 2011
---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 to download: http://msdn.microsoft.com/en-us/library/hh226085.aspx
יום שישי, מרץ 25, 2011
בנוסף לבלוגים קריאת ספרים וגוגלינג, תוכלו למצוא חומרים מעניינים גם ב TECNET ובMSDN-
ריכזתי כאן מספר לינקים שיקצרו לכם את זמן ההגעה.
SSAS - Multidimensional Data
SSAS - Data Mining
PowerPivot for Excel
יום חמישי, אפריל 16, 2009
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 ...
יום רביעי, אפריל 15, 2009
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 in a file together with relevant SQL Server Profiler trace information. What can you do with it? Backing up a database in an UnTrusted domain ...
יום ראשון, אפריל 13, 2008
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: "hey, what about remove duplicate?" well the application...