DotNetShoutout - Stories tagged with SSAS

SSAS

atom rss
5
Shouts
spam Shout it Mute it

Set the Slice on your SSAS Cube Partitions now!
published 495 days, 23 hours, 51 minutes ago posted by kinj312kinj312 498 days, 23 hours, 23 minutes ago
Friday, February 10, 2012 5:00:19 PM GMT Tuesday, February 07, 2012 5:28:32 PM GMT
I am pretty sure that most of you would have heard or read about this at least once in your SSAS career, but how many of you actually do set slices for your partitions? Well, I am also guilty of the charge and seldom did set slices till a recent issue... (more)
category: Data | clicked: 7 | comment | | source: beyondrelational.com
tags: SQL Server, SSAS, TSQL
9
Shouts
spam Shout it Mute it

Using SSAS formatting in SSRS
published 517 days, 18 hours, 16 minutes ago posted by dharadhara 520 days, 6 hours, 28 minutes ago
Thursday, January 19, 2012 10:35:12 PM GMT Tuesday, January 17, 2012 10:23:01 AM GMT
Christmas time is one of my most favourite times of the year – the time when you can just lay back, relax, enjoy some quality time with your family and catch up with your old friends. While this Christmas time has been a little hectic for me considering... (more)
category: Data | clicked: 6 | comment | | source: beyondrelational.com
tags: SQL Server, SSAS, BI, SSRS
10
Shouts
spam Shout it Mute it

SSRS & SSAS #62 – Create a data source on Report Server for an Analysis Services database
published 518 days, 23 hours, 52 minutes ago posted by kinj312kinj312 521 days, 8 hours, 20 minutes ago
Wednesday, January 18, 2012 4:59:12 PM GMT Monday, January 16, 2012 8:31:09 AM GMT
The team I recently moved into had never had a data source created on their report server for an Analysis Services source. A co-worker helped me got a data source created with Microsoft SLQ Server Analysis Services as the Data Source Type. For credentials... (more)
category: Data | clicked: 5 | comment | | source: beyondrelational.com
tags: SQL Server, SSAS, BI, SSRS
7
Shouts
spam Shout it Mute it

SSAS #26 – SSRS and SSAS Integration: how bad it is and our hope with two types of data providers
published 526 days, 20 hours, 25 minutes ago posted by dharadhara 528 days, 8 hours, 47 minutes ago
Tuesday, January 10, 2012 8:26:19 PM GMT Monday, January 09, 2012 8:04:19 AM GMT
A few months ago, I had a post, SSAS #21 – Steps to create a SSRS report with MDX accessing a Cube . If you have worked on creating SSRS reports accessing cubes for a little while, you already knew that my post really doesn’t help you much... (more)
category: Data | clicked: 8 | 2 comments | | source: beyondrelational.com
tags: SQL Server, SSAS, TSQL, BI
7
Shouts
spam Shout it Mute it

Formula engine and storage engine in SSAS
posted by dharadhara 595 days, 7 hours, 37 minutes ago
Thursday, November 03, 2011 9:14:14 AM GMT
In SSAS, to improve query performance, it’s important to understand what happens inside analysis services when a query is run. Analysis Services is made up of two engines: Formula Engine (FE) – It is single-threaded. It processes the MDX queries... (more)
category: Data | clicked: 7 | comment | | source: beyondrelational.com
tags: SQL Server, SSAS, BI
5
Shouts
spam Shout it Mute it

Building a Visual Studio project from an existing SSAS database
published 622 days, 19 hours, 10 minutes ago posted by dharadhara 624 days, 6 hours, 14 minutes ago
Thursday, October 06, 2011 9:41:22 PM GMT Wednesday, October 05, 2011 10:36:46 AM GMT
Imagine you join a company, and there is an existing SSAS database that contains a few cubes that are working nicely. You are asked to add an enhancement to one of the cubes, so you poke around in source control for the Visual Studio analysis services... (more)
category: Data | clicked: 10 | 4 comments | | source: beyondrelational.com
tags: SQL Server, SSAS, TSQL, BI
4
Shouts
spam Shout it Mute it

Using a Display Folder for a SSAS calculation
posted by dharadhara 636 days, 8 hours, 24 minutes ago
Friday, September 23, 2011 8:26:41 AM GMT
I was having a problem getting the display folder to work for a calculation in SSAS. Turns out, it will only work if you select “Measures” as the Parent hierarchy: The display folder (“Acct Calc – Supply Chain”) shows up... (more)
category: Data | clicked: 1 | comment | | source: beyondrelational.com
tags: SQL Server, SSAS
5
Shouts
spam Shout it Mute it

MS BI Workshop #15 – Why SSAS?
published 698 days, 8 hours, 38 minutes ago posted by dharadhara 699 days, 7 hours, 47 minutes ago
Saturday, July 23, 2011 8:13:37 AM GMT Friday, July 22, 2011 9:03:51 AM GMT
Assuming that now we’ve loaded our data warehouse. The rest of my notes are all about SSAS. SSAS is a service that can pre-aggregate data and make it faster to query data. According to the workshop presenter, it took only 2 seconds to query a 24... (more)
category: Data | clicked: 6 | comment | | source: beyondrelational.com
tags: SQL Server, SSAS, TSQL
5
Shouts
spam Shout it Mute it

SSAS #23 – Implement dimensional hierarchy in SSAS 2008
published 715 days, 9 hours, 50 minutes ago posted by dharadhara 717 days, 8 hours, 52 minutes ago
Wednesday, July 06, 2011 7:01:31 AM GMT Monday, July 04, 2011 7:58:59 AM GMT
Let’s continue from my previous post, SSAS #22 – Dimensional Hierarchy Contained in a Single Dimensional Table (Star Schema) . I need to assume that you have done all the following so far: Created an Analysis Services Project in BIDS Created... (more)
category: Data | clicked: 6 | comment | | source: beyondrelational.com
tags: SQL Server, SSAS, TSQL
4
Shouts
spam Shout it Mute it

When and How to Snowflake Dimension Sources : SSAS Design Part 3
published 717 days, 8 hours, 37 minutes ago posted by dharadhara 719 days, 7 hours, 26 minutes ago
Monday, July 04, 2011 8:14:28 AM GMT Saturday, July 02, 2011 9:24:52 AM GMT
In my last post , I had quickly hinted why I prefer using a star schema and also explained the second scenario in which I would snowflake the dimension sources for the DSV. The three scenarios as well as the example product dimension are... (more)
category: Data | clicked: 1 | comment | | source: beyondrelational.com
tags: SQL Server, SSAS, TSQL
6
Shouts
spam Shout it Mute it

When and How to Snowflake Dimension Sources : SSAS Design Part 1
published 729 days, 10 hours, 27 minutes ago posted by dharadhara 730 days, 8 hours, 5 minutes ago
Wednesday, June 22, 2011 6:24:14 AM GMT Tuesday, June 21, 2011 8:46:05 AM GMT
One of the best practices while designing a SSAS solution is to decouple your source database (which is in ideal cases, the data warehouse or the data mart but could also be an OLTP database) with the help of a semantic layer or view layer. Even though... (more)
category: Data | clicked: 15 | comment | | source: beyondrelational.com
tags: SQL Server, SSAS, TSQL, BI
5
Shouts
spam Shout it Mute it

SSAS #21 – Steps to create a SSRS report with MDX accessing a Cube
published 735 days, 21 hours, 16 minutes ago posted by dharadhara 737 days, 6 hours, 37 minutes ago
Wednesday, June 15, 2011 7:34:46 PM GMT Tuesday, June 14, 2011 10:14:19 AM GMT
I wasn’t sure if I should put this blog under SSRS or SSAS category. SSAS category won by default because I do not have many SSAS posts. In my last SSAS #20 post, I blogged about how to use the out-of-box Analysis Services processing tasks in SSIS to process dimensions, partitions, and measure... (more)
category: Data | clicked: 11 | comment | | source: beyondrelational.com
tags: SQL Server, SSAS, SSRS
5
Shouts
spam Shout it Mute it

SSAS #20 – When Analysis Services meet Integration Services
published 749 days, 11 hours ago posted by dharadhara 751 days, 8 hours, 41 minutes ago
Thursday, June 02, 2011 5:51:24 AM GMT Tuesday, May 31, 2011 8:10:00 AM GMT
I recently designed a cube in Analysis Services from scratch. After some brief research on all the different ways to process Analysis Services objects, some of the questions I had finally have a clear answer. If you have being working on Microsoft’s BI platform, you would know that SSAS and SSIS actually... (more)
category: Data | clicked: 3 | comment | | source: beyondrelational.com
tags: SQL Server, SSAS, TSQL, BI
6
Shouts
spam Shout it Mute it

Where to store calculated measures – SSAS cube or SSRS reports?
published 810 days, 18 hours, 28 minutes ago posted by dharadhara 812 days, 9 hours, 30 minutes ago
Friday, April 01, 2011 10:22:51 PM GMT Thursday, March 31, 2011 7:21:27 AM GMT
As I mentioned in one of my previous posts, nowadays I am busy preparing the design document of my new project and sending it around for reviews. If there is one question I could pick from the list that keeps coming back to me frequently, that would be this – why are you recommending to store all the... (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: SQL Server, SSAS, TSQL, BI
3
Shouts
spam Shout it Mute it

How to Create OLAP Cube using Business Intelligence Development Studio
posted by eralpereralper 895 days, 7 hours, 6 minutes ago
Friday, January 07, 2011 9:45:34 AM GMT
SQL Server Business Intelligence developers can create Analysis Services and Integration Services projects as well as Reporting Services projects using SQL Server Business Intelligence Development Studio aka BIDS. With each new SQL Server version, the Business Intelligence platform for BI developers has developed much in order to provide mature solutions to the requirements of customers. Although it was possible to create OLAP cubes in SQL Server 2000, with the new CTP version release of SQL Server 201... (more)
category: Data | clicked: 6 | comment | | source: www.kodyaz.com
tags: cube, OLAP, SQL Server 2008, SSAS, SQLServer
2
Shouts
spam Shout it Mute it

SSAS: Using fake dimension and scopes for dynamic ranges
published 922 days, 3 minutes ago posted by gpeipmangpeipman 922 days, 16 hours, 22 minutes ago
Saturday, December 11, 2010 4:47:49 PM GMT Saturday, December 11, 2010 12:29:35 AM GMT
In one of my BI projects I needed to find count of objects in income range. Usual solution with range dimension was useless because range where object belongs changes in time. These ranges depend on calculation that is done over incomes measure so I had really no option to use some classic solution. Thanks to SSAS forums I got my problem solved and here is the solution. (more)
category: How To | clicked: 2 | comment | | source: weblogs.asp.net
tags: SSAS, SQL
6
Shouts
spam Shout it Mute it

Is it the end of the road for SSAS?
published 931 days, 3 hours, 8 minutes ago posted by dharadhara 931 days, 10 hours, 55 minutes ago
Thursday, December 02, 2010 1:42:44 PM GMT Thursday, December 02, 2010 5:55:52 AM GMT
If you have been following the PASS summit notes coming from the attendees, you would have noticed an unmatched sense of pandemonium in the SSAS community. The reason is none other than the announcement of Microsoft's decision to move from the traditional... (more)
category: Data | clicked: 0 | comment | | source: beyondrelational.com
tags: SQL Server, MSBI, SSAS, TSQL, BI
9
Shouts
spam Shout it Mute it

MS PowerPivot - A view point
published 1031 days, 3 hours, 48 minutes ago posted by dharadhara 1032 days, 7 hours, 16 minutes ago
Tuesday, August 24, 2010 1:03:07 PM GMT Monday, August 23, 2010 9:35:36 AM GMT
Looking at the cost aspect associated with Power Pivot, I can see many business users using Power Pivot for excel 2010 to do some data analysis and reporting .They will least care about publishing it on Share Point which needs SP 2010 and SQL Server 2008 R2. (more)
category: Web Dev | clicked: 0 | comment | | source: beyondrelational.com
tags: POWERPIVOT, MSBI, SSAS, BI
5
Shouts
spam Shout it Mute it

SSAS Dimension Attribute Properties : Part 2 - Some Random Thoughts
posted by jacobsebastianjacobsebastian 1087 days, 13 hours, 20 minutes ago
Tuesday, June 29, 2010 3:31:28 AM GMT
In SSAS Dimension Attribute Properties : Part 1, we reviewed the Advanced and Basic properties of dimension attributes. This article would be continuing with the Misc, Parent-Child and Source properties. (more)
category: Data | clicked: 3 | comment | | source: beyondrelational.com
tags: data warehouse, SSAS, Business intelligence, SQLServer
8
Shouts
spam Shout it Mute it

SSAS Dimension Attribute Properties : Part 1 - Some Random Thoughts
published 1100 days, 6 hours, 8 minutes ago posted by jacobsebastianjacobsebastian 1101 days, 3 hours, 46 minutes ago
Wednesday, June 16, 2010 10:42:58 AM GMT Tuesday, June 15, 2010 1:04:44 PM GMT
In this post, Jason provides a quick overview of SSAS Dimension Attribute properties and provides a wonderful explanation of each property. (more)
category: Data | clicked: 3 | comment | | source: beyondrelational.com
tags: cube, Data Warehousing, Data Mining, Dimension, SSAS, analysis, SQLServer, Database
Previous 1 2 Next