http://www.sqlservercentral.com/Content tagged Data Warehousing, Analysis Services posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)This white paper describes how to set up a load-balanced scalable querying environment for Microsoft SQL Server 2005 Analysis Services so that you can handle a large number of concurrent queries to your Analysis Services servers.http://www.sqlservercentral.com/redirect/articles/3148/2007/08/10http://www.sqlservercentral.com/redirect/articles/3148/Analysis Services 2005 in SQL Server improves cube design and performance. Learn how attribute relationships advise Analysis Services how data should be rolled up.http://www.sqlservercentral.com/redirect/articles/3116/2007/08/08http://www.sqlservercentral.com/redirect/articles/3116/Check out our Top 10 tips on Analysis Services 2005 that will help you navigate through the features and functionality of this priceless Business Intelligence tool.http://www.sqlservercentral.com/redirect/articles/3070/2007/07/02http://www.sqlservercentral.com/redirect/articles/3070/This white paper describes how to set up a load-balanced scalable querying environment for Microsoft SQL Server 2005 Analysis Services so that you can handle a large number of concurrent queries to your Analysis Services servers. Load-balanced querying ensures that readers of OLAP cubes can consistently query for the latest aggregations throughout the day and distribute the load of all queries among the available servers. This scale-out querying architecture optimizes cube processing time, increases the frequency of cube update, and makes processing more robust as you can afford more frequent processing and transparent error recovery.http://www.sqlservercentral.com/redirect/articles/3048/2007/06/26http://www.sqlservercentral.com/redirect/articles/3048/Support conditional formatting for enterprise reports from the Analysis Services layer of the integrated Microsoft business intelligence solution.http://www.sqlservercentral.com/redirect/articles/3006/2007/05/23http://www.sqlservercentral.com/redirect/articles/3006/Planning for disaster recovery in SQL Server Analysis Services can be tricky. Fortunately SQL Server 2005 introduces the concept of a database synchronization, allowing you to transfer information and meta data from one server to another. Yaniv Mor brings us a look at this feature. http://www.sqlservercentral.com/articles/Analysis+Services/2864/2007/05/02http://www.sqlservercentral.com/articles/Analysis+Services/2864/Connecting to a SQL Server 2005 database is a simple process, but connecting to an Analysis Services 2005 database takes a bit more effort. Longtime data warehousing author Jacob Sebastian brings us a quick tutorial on how you can connect from Management Studio. http://www.sqlservercentral.com/articles/Analysis+Services/2865/2007/05/01http://www.sqlservercentral.com/articles/Analysis+Services/2865/In this demonstration, you'll quickly learn how to create a basic cube using the Cube Wizard upon a data warehouse. Brian walks through the entire process in this 10 minute video to get you started with creating a browsing a cube.http://www.sqlservercentral.com/redirect/articles/2974/2007/05/01http://www.sqlservercentral.com/redirect/articles/2974/Use SQL Server Profiler to “look behind the scenes” within Analysis Services 2005. BI Architect Bill Pearson leads a hands-on introduction to determining resource utilization effectiveness for both processing and query performance with profiling.http://www.sqlservercentral.com/redirect/articles/2964/2007/04/19http://www.sqlservercentral.com/redirect/articles/2964/A whitepaper on getting the best performance from your system.http://www.sqlservercentral.com/redirect/articles/2848/2007/02/07http://www.sqlservercentral.com/redirect/articles/2848/In this article, we will examine IsLeaf(), once again as a conditional logic modifier, but within the context of a filter. Combining IsLeaf() with the MDX Filter() function is another way we commonly see it in action in the business environment, and our exposure to the practical aspects of its employment in this way will serve to round out our overall awareness of the potential of IsLeaf(). http://www.sqlservercentral.com/redirect/articles/2700/2006/12/05http://www.sqlservercentral.com/redirect/articles/2700/In this article, we will concentrate upon the useful IsLeaf() operator, from the perspective of its use within a calculation. We will discuss the straightforward purpose of the operator, to ascertain whether a member is a leaf-level member of a dimension; the manner in which IsLeaf() manages to do this; and ways we can leverage the operator to support effective conditional logic to meet various business needs within our own environments.http://www.sqlservercentral.com/redirect/articles/2699/2006/11/28http://www.sqlservercentral.com/redirect/articles/2699/In this lesson, we will expose another useful function in the MDX toolset, the .Ordinal function. The general purpose of the .Ordinal function is to return the ordinal value of a specified dimensional level.http://www.sqlservercentral.com/redirect/articles/2698/2006/11/21http://www.sqlservercentral.com/redirect/articles/2698/In this presentation, you'll see how you can use Excel 2007 to view data and create quick reports against data in Analysis Services. Then, you'll see how to conditionally format the data and apply rules to the data. http://www.sqlservercentral.com/redirect/articles/2694/2006/11/08http://www.sqlservercentral.com/redirect/articles/2694/Analysis Services and business intelligence are new structures for most of the SQL Server world. BI expert Yaniv Mor brings us another article on Analysis Services, this time explaining the various different options for storing your cube data. http://www.sqlservercentral.com/articles/Analysis+Services/2658/2006/10/31http://www.sqlservercentral.com/articles/Analysis+Services/2658/In this and the related articles, we will overview Actions in Analysis Services 2005. Much as they did in the previous version of Analysis Services, Actions allow information consumers to go beyond the robust OLAP perspective offered by Analysis Services, and to "step outside" for related information, or to generate commands or initialize programs, without leaving their current analysis focus.http://www.sqlservercentral.com/redirect/articles/2660/2006/10/24http://www.sqlservercentral.com/redirect/articles/2660/Need a quick KPI prototype, using Reporting Services / Analysis Services 2000 or 2005? BI Architect Bill Pearson leads hands-on practice in presenting simple KPIs to management with Reporting Services.http://www.sqlservercentral.com/redirect/articles/2566/2006/08/31http://www.sqlservercentral.com/redirect/articles/2566/Leverage Perspectives, new to Analysis Services 2005, through MDX. BI Architect Bill Pearson leads hands-on practice with this means of visually focusing data retrieved from the UDM. http://www.sqlservercentral.com/redirect/articles/2548/2006/08/24http://www.sqlservercentral.com/redirect/articles/2548/Support information consumers with easier navigation and more focused analysis choices. In this article, BI Architect Bill Pearson leads hands-on exposure to Perspectives, another new Analysis Services 2005 feature.http://www.sqlservercentral.com/redirect/articles/2550/2006/08/17http://www.sqlservercentral.com/redirect/articles/2550/For those of you using Analysis Services, Yaniv Mor takes a look at some of the manageablity tools with SQL Server 2005. The way you work with Analysis Services and your cubes has changed dramatically and this is a good overview to get you started. http://www.sqlservercentral.com/articles/Analysis+Services/managementissuesssas2005/2424/2006/06/07http://www.sqlservercentral.com/articles/Analysis+Services/managementissuesssas2005/2424/One of the difficult parts of developing anaylsis services cubes is determining which aggregations should be chosen. Yaniv Mor brings us the second part of his series and examines using Usage Based Optimization in SQL Server 2005. http://www.sqlservercentral.com/articles/Analysis+Services/usagebasedoptimizationinssas2005/2419/2006/05/30http://www.sqlservercentral.com/articles/Analysis+Services/usagebasedoptimizationinssas2005/2419/Analysis Services 2005 seems like it receives much less notice than most of the other features in the latest version of SQL Server. However it is becoming more widely used in more and more companies. One of the features that can prove useful is the logging of queries. New author Yaniv Mor brings us a look at how this has changed in 2005. http://www.sqlservercentral.com/articles/Analysis+Services/enablingquerylogginginssas2005/2393/2006/05/16http://www.sqlservercentral.com/articles/Analysis+Services/enablingquerylogginginssas2005/2393/In Part Two of his series, database administration expert Baya Pavliashvili explores the challenges involved in building and maintaining a warehousing solution using a simple database warehouse.http://www.sqlservercentral.com/redirect/articles/2303/2006/03/02http://www.sqlservercentral.com/redirect/articles/2303/In the first of a two-part series, Baya Pavliashvili, database administration expert, offers solutions to your business problem using a data warehouse.http://www.sqlservercentral.com/redirect/articles/2302/2006/03/01http://www.sqlservercentral.com/redirect/articles/2302/In this lesson, we revisit usage-based optimization, a subject that we undertook in my article MSAS Administration and Optimization: Simple Cube Usage Analysis, in September of 2003, and MSAS Administration and Optimization: Toward More Sophisticated Analysis in October of 2003. In the earlier articles, we discovered that, among several tools that Microsoft SQL Server 2000 Analysis Services offered us to assist in the maintenance and optimization of our cubes, two of these tools, the Usage Analysis Wizard and the Usage-Based Optimization Wizard, leveraged the usage-based optimization features of Analysis Services. http://www.sqlservercentral.com/redirect/articles/2238/2006/01/10http://www.sqlservercentral.com/redirect/articles/2238/It has been widely publicized that Analysis Services 2005 uses XML for Analysis 1.1 (XMLA) as its only network protocol for communication between client and server. XMLA is standard public protocol defined by XMLA council and full description can be found at www.xmla.orghttp://www.sqlservercentral.com/redirect/articles/2205/2005/12/26http://www.sqlservercentral.com/redirect/articles/2205/In this lesson, we revisit Named Sets, a subject that we undertook in my article MDX in Analysis Services: Named Sets in MDX: An Introduction, in March of 2004. There, we introduced Named Sets from the perspective of the MDX query language, having obtained brief exposure to the concept of Named Sets earlier in the MDX in Analysis Services series (Using Sets in MDX Queries). We examined Named Sets as they existed within Analysis Services 2000, touching upon them from the perspective of Analysis Manager, the Cube Editor, and related interfaces in Analysis Services.http://www.sqlservercentral.com/redirect/articles/2195/2005/12/15http://www.sqlservercentral.com/redirect/articles/2195/One of the many tasks of the SQL Server Database administrator is to take and maintain backups of SQL Server databases. This includes taking backups of analytical databases as well. Read on to learn how to backup an Analysis service database. http://www.sqlservercentral.com/redirect/articles/2190/2005/12/13http://www.sqlservercentral.com/redirect/articles/2190/In this article, we will begin an extended examination of the MDX surrounding drilling up and down within our Analysis Services cubes. Comprising an analytical technique by which an information consumer can maneuver between summarized ("drilling up") and detailed ("drilling down") levels of data, drilling up or down occurs along the lines of drilling paths that are defined within the physical structures of our cubes. Often specified by the cube's dimensional hierarchies, these paths can also be based upon alternative relationships that exist within or between dimensions.http://www.sqlservercentral.com/redirect/articles/2155/2005/11/11http://www.sqlservercentral.com/redirect/articles/2155/In this article, I will introduce a significant improvement that underlies the new Analysis Services development approach, the Data Source View. A Data Source View is a design-time object that makes its home in the workbench environment of the Business Intelligence Development Studio. http://www.sqlservercentral.com/redirect/articles/2115/2005/10/20http://www.sqlservercentral.com/redirect/articles/2115/