SqlServerKudos - Stories tagged with SSAS

SSAS

atom rss
2
kudos
spam Kudos Remove

SSAS Dimension Attribute Properties : Part 1 - Some Random Thoughts
published 77 days, 16 hours, 9 minutes ago posted by jacobsebastianjacobsebastian 86 days, 15 hours, 47 minutes ago
Thursday, June 24, 2010 12:41:12 PM GMT Tuesday, June 15, 2010 1:03:29 PM GMT
SSAS Dimension Attribute Properties : Part 1 - Some Random Thoughts
In this post, Jason provides a quick overview of SSAS Dimension Attribute properties and provides a wonderful explanation of each property. (more)
category: Warehousing | clicked: 0 | comment | | source: beyondrelational.com
tags: analysis, Cube, Data Mining, Data Warehousing, database, Dimension, SQLServer, SSAS
2
kudos
spam Kudos Remove

Static Named Sets v/s Dynamic Named Sets - Some Random Thoughts
published 95 days, 17 hours, 31 minutes ago posted by jacobsebastianjacobsebastian 104 days, 21 hours ago
Sunday, June 06, 2010 11:19:29 AM GMT Friday, May 28, 2010 7:50:04 AM GMT
Static Named Sets v/s Dynamic Named Sets - Some Random Thoughts
Many times, it can happen that we end up writing very complex MDX expressions revolving sets. To simplify such expressions or to improve the performance of some queries, we can extract the definitions of some sets into a separate named set expression which are called named sets. A named set can be created either using a CREATE SET statement or a WITH SET statement (For syntax, refer Building Named Sets in MDX). In SQL Server 2005, there was only the Static named sets feature but in SQL Server 2008, both ... (more)
category: Warehousing | clicked: 1 | comment | | source: beyondrelational.com
tags: MDX, SSAS
1
kudos
spam Kudos Remove

SQL Server SSIS package performance series - resolve the low-memory conditions
published 135 days, 20 hours, 30 minutes ago posted by sasa 140 days, 21 hours, 39 minutes ago
Tuesday, April 27, 2010 8:20:33 AM GMT Thursday, April 22, 2010 7:10:49 AM GMT
SQL Server SSIS package performance series - resolve the low-memory conditions
SSIS Packages are integral part of database management activities, that all ETL based activities can be managed efficiently. The primary usage for these packages is to manage the movement of data from one place to another. To do that, the package needs to know where it is moving data from and where it is moving data to. Now a days the environment of source & destination server is not limited to a network or between 2 systems, it is diversified into global locations that typically enables Integration...(r... (more)
category: News | clicked: 1 | comment | | source: sqlserver-qa.net
tags: access, benchmarking, Best Practices, low memory, package, perfmon, Performance, SQL Server, SSAS, SSIS
1
kudos
spam Kudos Remove

SQL Server 2005 Standard Edition, Enterprise Edition & X64 based Knowledge Base Article changes
published 138 days, 20 hours, 44 minutes ago posted by sasa 142 days, 22 hours, 55 minutes ago
Saturday, April 24, 2010 8:05:42 AM GMT Tuesday, April 20, 2010 5:54:47 AM GMT
SQL Server 2005 Standard Edition, Enterprise Edition & X64 based Knowledge Base Article changes
The following pages were recently modified. Source: Knowledge Base Product: Microsoft SQL Server 2005 Enterprise Edition Notification Contents: New FIX: You receive a "Provider Load Failure" error message or the WMIPRVSE.EXE process stops responding when you use a SQL Server 2005 WMI provider to obtain information about SQL Server 2005 services http://support.microsoft.com/kb/980142/en-US FIX: Proactive caching starts unexpectedly when you insert data in SQL Server 2005 http://support.microsoft.com/kb/98... (more)
category: News | clicked: 0 | comment | | source: sqlserver-qa.net
tags: best practice, database mail, dbcc checkdb, enterprise edition, kba, Performance, SQL Server, SSAS, ssiss, SSRS, standard edition, x64
1
kudos
spam Kudos Remove

Exploring Additional Multi Dimensional Expression (MDX) Functions in SQL Server Analysis Services – Part 3
published 352 days, 15 hours, 18 minutes ago posted by sasa 362 days, 10 hours, 47 minutes ago
Tuesday, September 22, 2009 1:31:52 PM GMT Saturday, September 12, 2009 6:03:06 PM GMT
Exploring Additional Multi Dimensional Expression (MDX) Functions in SQL Server Analysis Services – Part 3
I recently wrote two articles on MDX in SQL Server Analysis Services Exploring MDX (Multi Dimensional Expression) in SQL Server Analysis Services Exploring Additional Multi Dimensional Expression (MDX) Functions in SQL Server Analysis Services – Part 2 This is the third and final part of the series and we will explore some additional functions of MDX: 1. IIF functions returns one of the possible two values in a logical test. It can return either a string or numeric value. WITH MEMBER MEASURES.[IIF V... (more)
category: Analysis | clicked: 1 | comment | | source: www.sqlservercurry.com
tags: MDX, SSAS
1
kudos
spam Kudos Remove

The cost of SSAS metadata management
published 379 days, 15 hours, 21 minutes ago posted by sasa 384 days, 12 hours, 35 minutes ago
Wednesday, August 26, 2009 1:28:42 PM GMT Friday, August 21, 2009 4:15:04 PM GMT
The cost of SSAS metadata management
This post will explain how we found ourselves in a situation where when processing a partition the metadata checks took 50 times longer than the actual partition and how to identify what time penalty you are incurring for the metadata checks. The system i was investigating had around 80 cubes with around 100 partitions per cube all hosted in one database and we would add 1 partition per cube per day. The partitions in each cube were small but were taking far to long to process and as each da... (more)
category: Analysis | clicked: 1 | comment | | source: sqlblogcasts.com
tags: Analysis Services, Performance, SSAS, Tips
1
kudos
spam Kudos Remove

Microsoft Codename "Gemini"
published 407 days, 16 hours, 39 minutes ago posted by sasa 408 days, 9 hours, 39 minutes ago
Wednesday, July 29, 2009 12:11:04 PM GMT Tuesday, July 28, 2009 7:10:54 PM GMT
Microsoft Codename "Gemini"
Today is July 28th 2009 and I am writing this small post to share my understanding on Gemini and Business Intelligence arena and specifically around Analysis Service. Talk about data in Microsoft and the very first thing that comes in mind is SQL Server. Microsoft hardly released SQL 2008 and we are looking forward for next version of SQL Server. That is very ambitious. When it comes to Business Intelligence problem, things like Reporting, Analysis, data-mining come... (more)
category: News | clicked: 5 | comment | | source: blogs.msdn.com
tags: Gemini, Kilimanjaro, SSAS
1
kudos
spam Kudos Remove

Media Business Intelligence - Decentrix and BIAnalytix - Part 2
published 408 days, 16 hours, 45 minutes ago posted by sasa 409 days, 10 hours, 10 minutes ago
Tuesday, July 28, 2009 12:05:09 PM GMT Monday, July 27, 2009 6:39:57 PM GMT
Media Business Intelligence - Decentrix and BIAnalytix - Part 2
In this episode, host Kirk Evans talks with Dr. Michael Ludwich, VP of Consulting at Decentrix, where Dr. Ludwich provides a demonstration of the BIAnalytix solution. This quite an interesting demonstration, helping to show the value of BI in a media organization. In Part 1 of this interview, we talked with Wayne Ruting, CEO of Decentrix, about the importance of business intelligence in a Media & Entertainment company. Decentrix has quite a client roster, including some of the largest broadcaste... (more)
category: Analysis | clicked: 0 | comment | | source: channel9.msdn.com
tags: BI, Excel, Excel 2007, Excel Services, Office, SharePoint, SQL 2008, SQL Server, SQL Server 2008, SQL Server Analysis Services, SQL Server Integration Services, SQL Server Reporting Services, SSAS, SSIS, SSRS
1
kudos
spam Kudos Remove

SSAS: Creating a Rowset action with the ExecuteSQL .Net stored procedure
published 410 days, 13 hours, 19 minutes ago posted by sasa 410 days, 22 hours, 37 minutes ago
Sunday, July 26, 2009 3:30:35 PM GMT Sunday, July 26, 2009 6:12:47 AM GMT
SSAS: Creating a Rowset action with the ExecuteSQL .Net stored procedure
A few weeks ago I did a post introduced the ExecuteSQL .net stored procedure for SSAS. Chris Webb asked if this function can be called from Excel 2007 when it is set this up as a rowset action and I figured that this would make a good topic for a blog post. So the following screen shots show how you would go about setting up such an action. As a quick example I cheated a bit and set up an Rowset action that calls the sp_who2 system stored procedure. This way I did not have a depedancy on any particular d... (more)
category: Analysis | clicked: 2 | comment | | source: geekswithblogs.net
tags: ASSP, Codeplex, SSAS, Stored Procedures
1
kudos
spam Kudos Remove

Announcing “Expert Cube Development with Microsoft SQL Server 2008 Analysis Services”
published 402 days, 16 hours, 59 minutes ago posted by sasa 410 days, 22 hours, 43 minutes ago
Monday, August 03, 2009 11:51:18 AM GMT Sunday, July 26, 2009 6:06:58 AM GMT
Announcing “Expert Cube Development with Microsoft SQL Server 2008 Analysis Services”
I’m pleased to announce that, after a lot of effort and late nights, the book that Marco Russo, Alberto Ferrari and I have been working on has finally been published! It’s called “Expert Cube Development with Microsoft SQL Server 2008 Analysis Services” and, basically, it’s a book about building cubes with Analysis Services 2008. So no surprises there then… Why should you buy this book? There are a lot of other, rea... (more)
category: Analysis | clicked: 4 | comment | | source: cwebbbi.spaces.live.com
tags: BIDS, Book, Cube, MDX, SSAS