Search Results: SSAS

• 
  SSAS – Using the Euro or Pound currency Symbol in a measure Format String

  SSAS – Using the Euro or Pound currency Symbol in a measure Format String If you have a set of measures and some of them are US dollars, some are Euros, and some are UK Pounds, you want to format them correctly in SSAS. First you will need to know the ASC

  Author:  MikeDavis     Date: 6/3/2011     Section: Blog

  tags : currency, Format String, measure, Pound, Symbol, .Euro, formatstring, SSAS
• 
  SSAS Reporting Actions with Date Parameters

  Reporting Actions in Analysis Services allows you to open a report in Reporting Services. Most of the time users want to pass in some parameters to the report so it shows the relevant data. If the parameter name matches the item in excel then this is a br

  Author:  MikeDavis     Date: 4/22/2011     Section: Blog

  tags : Action, Cube, Dilldown, Report, SSAS, Reporting action, SSRS
• 
  SSAS Dynamic KPI from a table

  KPI’s (Key Performance Indicators) in Analysis Services are a great way to show visually if a measure is above or below a goal. Managing the goal numbers can be a headache because they made need to be updated often. By placing the goal numbers on a table

  Author:  MikeDavis     Date: 4/21/2011     Section: Blog

  tags : Dynamic, Goal, MDX, SSAS, Table, Trend, KPI
• 
  SSAS Different Dimension Granularity

  In an SSAS cube you sometimes need to connect a dimension at a different granularity than other dimensions. For example, if you have budget measures and actual numbers. If you are trying to budget your expenses you budget at a higher level than the actual

  Author:  MikeDavis     Date: 5/28/2010     Section: Blog

  tags : Cube, DImension, Granularity, Define Relationship, SSAS
• 
  Logging SSAS Cubes User Activity?/Access?

  Hi there. I use a lot these dmvs: SELECT * FROM $system.DISCOVER_CONNECTIONS SELECT * FROM $system.DISCOVER_SESSIONS SELECT * FROM $system.DISCOVER_Commands here you can find queries running, time elapsed and users. For more available functions, take a de

  Author:  marcoadf     Date: 12/15/2011     Section: Forum

  tags : discover, dmv, monitoring, ssas activities, ssas dmv
• 
  Help! I Can’t Connect to Analysis Services in SSMS

  A few months ago, I installed SQL Server 2008 R2 and chose to install SSIS, SSRS and SSAS as well. While playing around with SSAS, I tried to open up SQL Server Management Studio (SSMS) and connect up to Analysis Services. The screenshot below shows how I

  Author:  briankmcdonald     Date: 11/2/2010     Section: Blog

  tags : Analysis Services, Brian K. McDonald, Connecting to SSAS using SSMS, no connection could be ma, SSAS
• 
  SSWUG Free Expo Event: Understanding SQL Server Analysis Services on 20th May 2011

  Here is another free expo/event from SSWUG about SSAS on 20th May 2011 Sessions will cover the following topics: Common Mistakes with SSAS Cube Designs SSAS Partitioning and Aggregation Strategies Properly Using the SSAS Query Cache Overcoming SSAS Implem

  Author:  meganathank     Date: 3/20/2011     Section: Blog

  tags : Free Event, SSWUG, SSAS
• 
  SSAS Interview Questions

  I was looking for some SSAS interview questions and found some very good resources on the web. The links are below. SSAS Interview Questions from Siddharth Mehta's blog Sql Server 2005 Analysis Services Interview Questions Dave Rodabaugh's Analysis Servic

  Author:  indupriya     Date: 1/5/2011     Section: Blog

  tags : SSAS Questions, SSAS interview questions
• 
  BI Xpress SSAS MDX Builder and SSIS Deployment

  BI Xpress SSAS MDX Builder and SSIS Deployment If you build SSIS Packages, or work on SSAS Cubes, BI Xpress is a must have tool for you. It has made my life so much easier in all of my BI work. I want to share with you just a couple of the features it con

  Author:  MikeDavis     Date: 6/7/2011     Section: Blog

  tags : BI MDX, BIxpress, Deploy, Deployment, SSAS, SSIS
• 
  SSAS Compare, a cool tool for Microsoft Business Intelligence professionals.

  Hello BIDN Family, It’s been long time gap and I was really missing my blogging time part. Through this blog I would just want to share the new tool developed by the Red –Gate called SSAS Compare . which I think , SSAS Compare is one of the co

  Author:  Anil     Date: 6/12/2012     Section: Blog

  tags : SSAS Compare
• 
  Handling Large Many to Many bridge tables

  In some scenarios you will need to create a many to many relationship in your cube in SSAS. I have an article that shows you how to do this here . One of the problems that arise from many to many bridge tables are the size of these tables. In this example

  Author:  MikeDavis     Date: 5/6/2011     Section: Blog

  tags : Cube, Dimension, Factless Fact Table, Many to Many, SSAS, Bridge Table
• 
  Configuring an SSAS 2008 Project

  In this article, Adam takes you through the basics of configuring an SSAS project in Business Intelligence Development Studio. He explores some options you will use every day, and some you should consider using to improve your team development.

  Author:  AdamJorgensen     Date: 11/24/2009     Section: Article

  tags : SSAS Configuration, SSAS Development, Visual Studio, SSAS 2008
• 
  Creating a Data Source View(DSV) in SSAS

  Continuing with the series on building your first cube, Adam takes you through exploring the UDM in SSAS 2008 and creating a DSV from which your cube can be designed.

  Author:  AdamJorgensen     Date: 11/24/2009     Section: Article

  tags : SSAS 2008, SSAS Development, SSAS Projects, DSV
• 
  MDS 2012: Part 6–Business Rules

  In Part 6 of this Master Data Services blog series we will look at how we enforce quality standards and ensure accuracy in our master data by implementing business rules. In the prior parts to this series, we have spent time reviewing important Master Dat

  Author:  cprice1979     Date: 7/17/2012     Section: Blog

  tags : Business Rules, Data Integration, Master Data management, Master Data Services, MDS
• 
  Connecting to and Querying an SSAS Cube in SSIS

  So imagine that you need to create a solution to moving the aggregated data from a cube into another location for a third party, such as a spread sheet, SQL Server table, or a flat file. We can accomplish this task using SSIS. First, create a new OLE DB C

  Author:  DustinRyan     Date: 1/19/2011     Section: Blog

  tags : connect to SSAS cube in SSIS, transfer data from SSAS cube with SSIS, query SSAS cube with SSIS
• 
  SSAS lazy processing

  When we reprocess SSAS cube then it actually bring new/changed relational data into SSAS cube by reprocessing dimensions and measures. Partition indexes and aggregations might be dropped due to changes in related dimensions data so aggregations and partit

  Author:  sirfnet     Date: 1/12/2011     Section: Blog

  tags : Analysis services tutorial, Lazy processing, SSAS tutorial, SSAS
• 
  How to Document SQL Server- BI Documenter

  How to Document SQL Server So you created this amazing BI solution. You have SSIS Packages loading your data warehouse, you have SSAS Cubes, and you have reports in SSRS. But how do you document this entire solution? It used to be a long tedious process.

  Author:  MikeDavis     Date: 6/7/2011     Section: Blog

  tags : Database, Index, SQL Server, SSAS, SSIS, SSRS, Tables, Document
• 
  This Year - Last Year SSAS Calculated Member

  In this quick demo I’m going to add a calculated member to the AdventureWorks cube that allows an end user to do a This Year/ Last Year comparison for a given measure.

  Author:  tinocash     Date: 2/16/2010     Section: Article

  tags : Analysis Services, Calculated Measures, SSAS, Calculated Members
• 
  SQL Server “Denali”: Installing SSAS Multidimensional vs Tabular Mode

  As I play with the recently released CTP3 of SQL Server Denali, I wanted to point something out about installing SSAS, since there is now two “modes” you can choose from due to the the new BI Semantic Model (I covered these new features here ). During ins

  Author:  jamserra     Date: 7/25/2011     Section: Blog

  tags : Denali, SQL Server, SSAS, BISM
• 
  SSAS Calculation Formatting Not Showing in Excel 2007 or Excel 2010

  Occasionally in SQL Server 2005 and 2008 Analysis Services, you'll build a cacluation and set the formatting to be a value like a currency and are surprised that in Excel 2007 and 2010 the formatting does not carry over. The "randomness" of this actually

  Author:  BrianKnight     Date: 10/1/2010     Section: Blog

  tags : calculation, excel 2007, excel 2010, mdx, ssas
• 
  SSAS KPI Trend

  KPI’s (Key Performance Indicators) in Analysis Services are a great way to show visually if a measure is trending in right direction based on previous levels. If you want to show a measure has increased or decreased since last month, this can be accomplis

  Author:  MikeDavis     Date: 4/22/2011     Section: Blog

  tags : Cube, MDX, SSAS, Trend, KPI
• 
  Data Mining and base knowledge.

  Hi. With the recent article from Devin about mining, he has made me remeber that I was about to ask one thing to all of you about this subject. SSAS provides data mining. Are there a wide variety of models provided by SSAS, or just the most known ones? An

  Author:  marcoadf     Date: 1/24/2010     Section: Forum

  tags : mining, ssas, models
• 
  SSAS Impersonation Smackdown - Specific Windows Acct vs Service Account

  Recently I was helping a client with their Analysis Services database structure. In this particular environment, there are a lot (and I mean A LOT) of AS db’s. One of the first things I noticed is that almost every single one was using the service a

  Author:  ChrisSchmidt     Date: 1/23/2013     Section: Blog

  tags : SSAS 2012, ssas impersonation modes, ssas service account
• 
  Near Real Time OLAP using SSAS Proactive Caching

  If I had a nickel for every time I've heard from a business user that the OLAP solution must support current real time data from the source system, I'd have at least half a dollar. The fact is that in reality there is usually some acceptable degree of lat

  Author:  MMilligan     Date: 1/13/2012     Section: Blog

  tags : client initiated, partitioning, proactive caching, scheduled polling, sql server notification
• 
  Microsoft Business Intelligence Certification 70-448, SSIS, SSAS, SSRS

  I just passed the Microsoft BI certification test 70-448 on SSIS, SSAS, and SSRS. It was a tough test and covers all aspects of the Microsoft BI stack. I used a lot of different study materials. Here is my assessment of the study materials I used and whic

  Author:  MikeDavis     Date: 1/30/2010     Section: Blog

  tags : 70-448, Microsoft Business Intelligence, Preperation, SSAS, SSRS, Test, SSIS