Who is online?
0
guests and
0
members
Member login
|
Become a member
Home
Articles
Forums
Blogs
Jobs
Events
Files
Spaces
People
login
register
Home
» search results
Search Results: MDX
450 results found
MDX
101: Introduction to
MDX
In this article, Dustin will cover the basics of the Multi Dimensional Expression (MDX) Language and introduce you to writing your first MDX statement.
Author:
DustinRyan
Date: 9/1/2010 Section:
Article
tags :
Introduction to MDX
,
Learn MDX
,
mdx
,
MDX query syntax
MDX
Puzzles: Sixth Sense - Answer
This week's puzzle used a couple functions we learned about a few weeks back . To solve the Sixth Sense puzzle, you should have used the TopCount function (or the Head and Order functions) and the Generate function . So lets start off with a basic query t
Author:
DustinRyan
Date: 12/30/2010 Section:
Blog
tags :
Generate function
,
MDX puzzle solution
,
TopCount function
Showing an SSAS Hierarchy as Delimited String
I recently encountered a requirement for a client to display a list of all the individual stores of a ragged hierarchy (the leaf members) on an SSRS report with a bunch of different measures. But they also wanted to be able to quickly see the the ancestor
Author:
DustinRyan
Date: 10/11/2011 Section:
Blog
tags :
Ancestors
,
Descendants
,
Generate
,
Hierarchy
MDX
Puzzles: Encounters of the Fourth Kind - Answer
Since this week is Thanksgiving and I was busy as mess on Friday, I figured I would wait to post the solution to last week's MDX puzzle until today and take a week off from blogging while I celebrate Thanksgiving with the family. To solve Encounters of th
Author:
DustinRyan
Date: 11/22/2010 Section:
Blog
tags :
Ancestor function
,
IIF function
,
MDX puzzle solution
MDX
Functions
MDX
Examples
MDX
Queries
Here is list of SSAS MDX Functions which we commonly use in writing MDX queries. You can find details about most of MDX function by clicking it. Time Set Statistical Navigation YTD TOPCOUNT COALESCEEMPTY ANCESTOR QTD BOTTOMCOUNT COUNT ANCESTORS MTD CROSSJ
Author:
sirfnet
Date: 1/13/2011 Section:
Blog
tags :
MDX Tutorial
,
SSAS
,
SSAS MDX
,
SSAS Tutorial
,
MDX
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
Intro to
MDX
at SQL Saturday #130 – Jacksonville, FL
This weekend is SQL Saturday #130 in Jacksonville, FL. On Friday, April 27th, is a great pre-con session by SQL Server MVP, Kevin Kline on Performance Tuning SQL Server 2008 R2. Go here to get registered for this phenomenal opportunity to learn from an un
Author:
DustinRyan
Date: 4/26/2012 Section:
Blog
tags :
free training
,
SQL Saturday
Reporting on an SSAS Cube with SSRS 2008
In this article, Dustin gives you an introduction on building a report on a cube using the MDX Query Designer.
Author:
DustinRyan
Date: 5/7/2010 Section:
Article
tags :
MDX query
,
MDX query designer
,
SSRS cube report
,
SSRS 2008
MDX
Puzzles: Double Deuce Action
Well last week's MDX puzzle showed us how to use the Ancestor function to navigate the levels of a hierarchy. This week's MDX puzzle is all about navigating within a single level of a hierarchy. If you need a referesher on a hierarchy and how the levels f
Author:
DustinRyan
Date: 11/1/2010 Section:
Blog
tags :
MDX puzzles
,
MDX
Dump
MDX
OLAP Query output to a relational table from SSMS
I found two simple ways to dump MDX query output to a table and then dump the table data to excel file or text file as per need. The two methods are: 1. Using OPENROWSET Syntax : OPENROWSET('provider_name', 'datasource'; 'user_id'; 'password', {[ catalog.
Author:
artuladhar
Date: 5/16/2012 Section:
Blog
tags :
dump
,
file
,
MDX data
,
OLAP
,
output
,
query
,
Table
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
Parameter Suppress Auto Update
I discovered this issue the other day while creating a report from a cube. I used the query designer to build a report with a few parameters. The query designer did a great job of building the MDX for me but the client wanted something a little bit more c
Author:
ChrisAlbrektson
Date: 10/26/2010 Section:
Blog
tags :
MDX
,
Parameters
,
SSRS
,
SuppressAutoUpdate
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
Creating a Rolling Date Range Named set in
MDX
Creating a Rolling Date Range Named set in MDX One Client I was working with wanted a named set that would give them the last 5 years. Of course this needed to be a rolling 5 years so it automatically moved the years up every January. To create this I use
Author:
MikeDavis
Date: 12/6/2010 Section:
Blog
tags :
Date
,
Date Range
,
Named Set
,
Rolling Date
,
MDX
Code and Slide Deck from Intro to
MDX
Session at JaxCodeCamp2010
So if you missed JaxCodeCamp 2010, you missed one heck of a free training event! Each session I attended was incredible and I learned all kinds of new things even in some of the areas that I consider myself strong in. Any ways, my session Introduction to
Author:
DustinRyan
Date: 8/30/2010 Section:
Blog
tags :
Introduction to MDX
,
JaxCodeCamp
,
MDX
The power of SIMBA into the world of BI on top of BIG DATA.
It been long time and I really miss this BIDN family Network ,after a long time gap I would love to post this blog regarding the power of SIMBA into the world of BI on top of BIG DATA . It’s really interesting and exciting to see these kinds of new
Author:
Anil
Date: 2/27/2013 Section:
Blog
tags :
BI
,
Big DATA
,
Hadoop
,
SIMBA
Free
MDX
Webcast Series from SSWUG
Explore the basic functions of MDX and view many practical examples on using the query language in SSWUG's "Introduction to MDX" webcast series. In three, in-depth sessions, Business Intelligence architect and MDX expert Bill Pearson will focus on the bas
Author:
indupriya
Date: 5/2/2011 Section:
Blog
tags :
Introduction to MDX
,
MDX webcast
,
SSWUG
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
MDX
Puzzles: Super 8
If you’ve followed my blog, you’ve probably come across my series of MDX puzzles. If you’re not familiar with the MDX Puzzles series of post, check this out . Anyways, on to the puzzle! As always, these MDX queries were written against the Adventure Works
Author:
DustinRyan
Date: 4/22/2011 Section:
Blog
tags :
OpenQuery function
,
MDX Puzzles
MDX
Puzzles: Third Time's a Charm - Answer
I'll admit that this week's puzzle was probably a little tougher than the past couple, but I think I gave enough hints that you should have been able to figure it out. So here is one way to solve the puzzle: Let's start out with a base query that has Rese
Author:
DustinRyan
Date: 11/12/2010 Section:
Blog
tags :
Generate function
,
TopCount function
,
MDX puzzle solution
MDX
Puzzles: The Fifth Element
After a relaxing and enjoyable Thanksgiving break from work, its back to the grind stone. Monday and Tuesday were a little crazy for me, which is why this week's puzzle isn't getting posted until today. Due to that fact, the answer won't be due until Frid
Author:
DustinRyan
Date: 12/1/2010 Section:
Blog
tags :
MDX puzzles
,
MDX
Intro to
MDX
Session Slide Deck and
MDX
Script
Thanks to everyone who attended my session at SQL Saturday #130 in Jacksonville, FL a couple weeks back. I apologize for posting this so late, but better late than never. To download my session materials, just click this link . In it you'll find my PowerP
Author:
DustinRyan
Date: 5/9/2012 Section:
Blog
tags :
SQL Saturday
Problem with RANK statement when used for a dynamic set inside SCOPE statement
Hi, I am new to any complex or involved MDX code. I am stuck and I need to get this done. Would really appreciate your help. I am trying to create a calculated member for percentile and I found the approach in the following link http://www.bidn.com/articl
Author:
fzfassoc
Date: 10/11/2011 Section:
Forum
tags :
Calculations
,
percentile
Last Year sales problem
I am new to SSAS with no training and no support. A consulting firm helped us with the MDX, but that's that. Our calendar year works from July to June, but not the 1st. Last year 27/06/2010 to 25/06/2011 and current year from 26/06/2011 till 30/06/2012. T
Author:
Helcas
Date: 1/16/2012 Section:
Forum
tags :
Last year
,
parallelperiod
MDX
/SSRS: How to remove the ALL member from your parameter
This brief blog is for individuals that are new to creating reports from a cube. Since you’re new to creating reports from a cube you still probably rely on using the query designer because maybe you don’t know MDX yet and that’s fine. So pretend you had
Author:
ChrisAlbrektson
Date: 1/19/2011 Section:
Blog
tags :
Children Function
,
Parameter
,
SSRS
,
MDX
Page 1 of 18 (450 items)
<< Prev
1
2
3
4
5
6
7
8
9
10
11
...
Next >>
Go to page:
[Go]