Break distinct count measures into separate measure groups

יום רביעי, יולי 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.
תגיות: ,
אין תגובות

Memory-efficient Data Model using SSAS Tabular model

יום ראשון, ינואר 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...
אין תגובות

Analysis Services Operations Guide

יום חמישי, יוני 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
תגובה אחת

BI חומרים נוספים ללימוד

יום שישי, מרץ 25, 2011

  בנוסף לבלוגים קריאת ספרים וגוגלינג, תוכלו למצוא חומרים מעניינים גם ב 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  
תגיות: , , ,
אין תגובות

Analysis Services Processing Options- glossary

יום חמישי, אפריל 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 ...
תגיות: ,
אין תגובות

The ascmd command-line utility ( ascmd.exe )

יום רביעי, אפריל 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 ...
תגובה אחת

SSAS 2008 Aggregation Manager

יום ראשון, אפריל 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...
אין תגובות