Search Results: calculations

• 
  Ten MDX Calculations For Your Cube

  I get lots of questions about how to implement various types of calculations in a cube so I figured I'd cover some of the more commonly used calculations I run into on a regular basis. All of these example calculations I'll be providing were written again

  Author:  DustinRyan     Date: 11/17/2011     Section: Blog

  tags : BI xPress, count leaf members, MTD, YTD
• 
  MDX Calculation Builder Automatically Builds MDX Calculations for You

  One of the most powerful aspects of Analysis Services is the ability to easily view your facts over time. What's not always so easy is writing those calculations that make complex time analysis possible. MDX can have a steep learning curve, which is where

  Author:  DustinRyan     Date: 10/31/2011     Section: Blog

  tags : BI xPress, MDX Calculation Builder
• 
  Aging Report For Trouble Tickets

  When you need these kinds of calculations it is much eaiser when you have an ETL process to tranfers this data into a datawarehouse where you can create all of these calculations in the ETL process. If you can't do this then you can do calculations in vie

  Author:  MikeDavis     Date: 5/3/2010     Section: Forum

  tags : DateDiff, Time Calculations, SSRS
• 
  SSAS YTD Issue - Calendar vs. Fiscal

  Hi All, I've recently been using the following white paper to re-work my SSAS date calculations manually rather than using those created by the time intelligence wizard: A Different Approach to Implementing Time Calculations in SSAS It has all been workin

  Author:  Trav     Date: 2/23/2012     Section: Forum

  tags : HIERARCHY, YTD
• 
  Top 3 Simplest Ways To Improve Your MDX Query

  Learning to write MDX is difficult enough, but learning to write efficient MDX and performance tune an MDX query can be even more of a challenge. With that thought, I wanted to put together a few tips that can help you improve the performance of your MDX

  Author:  DustinRyan     Date: 3/29/2012     Section: Blog

  tags : MDX IIF function, MDX Performance, Named Sets
• 
  MDX Scripting with SCOPE Statement

  In this article, Dustin gives you an introduction on using a SCOPE statement to apply custom calculations to specific subcubes within the Adventure Works cube.

  Author:  DustinRyan     Date: 3/15/2010     Section: Article

  tags : MDX Scripting, SCOPE statement, MDX
• 
  Implementing Common Business Calculations in DAX

  Chris Webb has spoken about "implementing common business calculations in DAX" during SQL Server Day 2010 in Belgium. Here is the link for uploaded video. Implementing Common Business Calculations in DAX DAX is Microsoft's new multidimensional calculation

  Author:  sirfnet     Date: 4/29/2011     Section: Blog

  tags : Powerpivot, SSAS
• 
  BIxPress MDX Calculation Builder

  MDX and SSAS is a powerful part or Business Intelligence that I have yet to venture into. The good news is that BIxPress has made it easier and quicker to use calculations in SSAS. The BIxPress calculation builder allows you to quickly develop calculation

  Author:  ogonzalez     Date: 11/6/2011     Section: Blog

  tags : BIxpress, Calculation Builder
• 
  MDX Time Calculations Done the Right Way

  In this article Devin shows you a unique way of writing time calculations. These calculations are dynamic so no matter what measure is used it will show it YTD, Previous Period, etc...

  Author:  DevinKnight     Date: 8/11/2010     Section: Article

  tags : MDX, SSAS
• 
  SSAS Parent Child Dimension Properties

  I’ve saved the best for last, so they say. Well, depending on how you look at it. Over the last week, I’ve blogged about all of the other sections in Analysis Services dimensions except for parent-child, so now it’s time to finish off ou

  Author:  ChrisSchmidt     Date: 3/6/2013     Section: Blog

  tags : memberswithdata, memberswithdatacaption, parent child naming template, ssas dimensions, ssas parent child dimensions, unaryoperator
• 
  SSAS Calculation to Pull Previous Month Last Day

  Hi. To set the stage I work for a company that, among many things, provides reporting solutions for Credit Unions. I have a fairly straight forward SSAS solution but am still pretty green when it comes to MDX. In my solution I have a typical Calendar dime

  Author:  EGAN     Date: 12/1/2009     Section: Forum

  tags : KPIs, MDX, Calculations
• 
  MDX Utility Belt of Calculations Part 4

  This is part four in the series of blog posts that will help in building a library of calculations you can use as a reference in any analysis services cube you build. You can find the previous posts to this blog series below: Part 1 – ParallelPeriod Part

  Author:  DevinKnight     Date: 12/7/2009     Section: Blog

  tags : MDX
• 
  MDX YTD not working due to format String

  If you are using the templates for MDX calculations built into SSAS 2008 you might run into some strange issues. In the image below you can see the calculation is working for all years except for 2008. My first thought was data issue. After querying the t

  Author:  MikeDavis     Date: 8/2/2010     Section: Blog

  tags : Calculation, SSAS, MDX
• 
  MDX Utility Belt of Calculations Part 1

  Developing MDX calculations is one of the most confusing and time consuming pieces of building an Analysis Services cube. That is why I have accumulated what I like to call a Utility Belt of calculation that I can pull out at any moment to solve a problem

  Author:  DevinKnight     Date: 12/1/2009     Section: Blog

  tags : SSAS
• 
  Performance Tips with Computed Columns

  When preparing an environment for reporting purposes such as a data warehouse, you may want to consider a method of pre-aggregation to minimize calculations at runtime. Calculations that may adversely affect the performance of a stored procedure. One meth

  Author:  kylewalker     Date: 6/4/2010     Section: Blog

  tags : Data Warehouse, Performance, Computed Columns
• 
  MDX TO CALCULATE PREVIOUS YEAR 4th QUARTER SALES

  Well, what hierarquies do you have in time dimension? I will assume you have Y-Q-M-D (Year, quarter, month and day). you have to create a member based on your current year: WITH MEMBER {Measures.LastQuarter} AS ( [Time].[Year].prevmember.lastchild ) For C

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

  tags : lag, lastchild, quarter
• 
  SSAS - The way to go??

  I have used DTS on Sql Server 2000 and am now working at a new job using SSRS, SSIS, SSAS on Sql Server 2008 R2. Quite a change. Before I came, the group ran everything based on queries and calculations on data from Project Server into Excel. They want to

  Author:  bluize76     Date: 10/19/2011     Section: Forum
• 
  MDX Handle Dividing by Null or 0 Gracefully

  If you ever created any calculations in your cube or in an MDX query that uses division, you've probably run into the issue of dividing by zero (0) or NULL. Dividing by 0 or NULL will show the ugly -1.#INF when browsing your cube from Excel. But being the

  Author:  DustinRyan     Date: 2/22/2010     Section: Blog

  tags : -1.#INF, Divide by Null, Divide by zero, MDX NaN, MDX
• 
  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
• 
  MDX Scope with an If Then Exception or Filter

  The scope statement in MDX is great for applying calculations to a certain area of a cube, also called a subcube. Dustin Ryan wrote a great article on the scope statement here . The issue I am going to cover will be using the scope statement when you only

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

  tags : Exception, Filter, If Then, Scope, MDX
• 
  SQL Saturday Is Coming To Jacksonville, FL and I’m Speaking!

  On April 27th next month, SQL Saturday #215 will be here in beautiful, sunny Jacksonville, Florida and none other than yours truly will be speaking, bright and early at 8:30 in the morning! I'll be presenting MDXplosion! Intro to MDX . The MDX query langu

  Author:  DustinRyan     Date: 3/1/2013     Section: Blog

  tags : SQL Saturday
• 
  MDX Utility Belt of Calculations Part 2

  This post is a part of a series of blog posts I am writing to give you a Batman-like Utility Belt of MDX calculations. With this Utility Belt available you can have a template of commonly needed calculations you can use for just about any Analysis Service

  Author:  DevinKnight     Date: 12/1/2009     Section: Blog
• 
  MDX Utility Belt of Calculations Part 3

  This is part three in a series of blog posts that will help you build an arsenal of MDX calculations that you can have ready at the drop of a dime. The first two posts of this blog series use the ParrallelPeriod and PrevMember functions to return data at

  Author:  DevinKnight     Date: 12/3/2009     Section: Blog
• 
  Excel Web Access error in Sharepoint 2007

  I wanted to use Excel Services on Sharepoint 2007 to migrate some of our BI reports from a third party application that we use. So I tried publishing to Excel Services from Excel 2007 assuming that our Sharepoint was setup to be used with Excel Services.

  Author:  indupriya     Date: 2/16/2011     Section: Blog

  tags : Excel Calculation Server, Excel Services, Excel Web Acccess, MOSS 2007
• 
  Dataset with Text or Stored Procedure

  As most of you already know, Reporting Services reports make use of Datasets to get data. These Datasets can get the data from Text, Table (rarely used) or a Stored Procedure. Which query type to use has been a topic on many forum boards and I’ve ha

  Author:  briankmcdonald     Date: 10/2/2011     Section: Blog

  tags : Brian K McDonald, Dataset with query type text or stored proc, sqlbigeek