Log in
::
Register
::
Not logged in
Search:
Home
Articles
Editorials
Forums
Scripts
Blogs
QotD
SQL Jobs
Training
Authors
About us
Contact us
Newsletters
Advertise
Write for us
Articles with tag
MDX
Refine your search with one of the following additional tags (with number of items):
Analysis Services
(6)
Data Warehousing
(4)
SQL Server 2005
(1)
Search for
any
content tagged
MDX
Items 1 to 15 of 15
Intrinsic Member Properties: The MEMBER_KEY Property
Join BI Architect Bill Pearson in an introduction to the intrinsic MEMBER_KEY property. In hands-on exercises, we gain exposure to the use of the property in generating simple lists, as well as datasets to support report parameter picklists.
Read more...
By
Additional Articles
2008/07/11
|
Source:
Database Journal
|
Category:
Analysis Services
Rating:
Rate this
|
Briefcase
|
813 reads
Parameterizing Number of “Look Back” Periods with the MDX LastPeriods() Function, Part I
Parameterization of MDX functions is one of those things that cannot be delivered solely via graphical MDX Editor – but then, you really didn’t think that you could avoid actually touching MDX at all, did you? BI Architect Bill Pearson demonstrates a way to parameterize the highly useful LastPeriods() function.
Read more...
By
Additional Articles
2008/06/24
|
Source:
Database Journal
|
Category:
MDX
Rating:
(not yet rated)
Rate this
|
Briefcase
|
737 reads
Introduction to MDX Scripting in Microsoft SQL Server 2005
This document describes how Multidimensional Expressions (MDX) for Microsoft SQL Server 2005 can be applied to common business problems. This document assumes some familiarity with MDX.
Read more...
By
Additional Articles
2008/05/02
|
Source:
TechNet
|
Category:
MDX
Rating:
(not yet rated)
Rate this
|
Briefcase
|
2,155 reads
Set Functions: The StripCalculatedMembers() Functio
Business Intelligence Architect Bill Pearson continues his examination of MDX functions, this time introducing StripCalculatedMembers(). In this article, we expose the function, and then lead a hands-on practice session with examples that reinforce the concepts.
Read more...
By
Additional Articles
2008/04/18
|
Source:
Database Journal
|
Category:
MDX
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,175 reads
MDX Numeric Functions: The Min() Function
Business Intelligence Architect Bill Pearson introduces the numeric Min() function, and leads hands-on practice examples of its use.
Read more...
By
Additional Articles
2008/02/25
|
Source:
Database Journal
|
Category:
MDX
Rating:
(not yet rated)
Rate this
|
Briefcase
|
938 reads
The Unpopular SELECT Statement
SELECT statements should be the most popular query in SQL Server, so why are they unpopular? It's the complex, confusing MDX SELECT statement that warehousing expert Vincent Rainardi is writing about.
Read more...
By
Vincent Rainardi
2008/02/20
|
Source:
SQLServerCentral.com
|
Category:
MDX
Rating:
|
Discuss
|
Briefcase
|
13,930 reads
MDX Numeric Functions: The Max() Function
Business Intelligence Architect Bill Pearson introduces the numeric Max()function, and leads hands-on practice examples of the basic concepts.
Read more...
By
Additional Articles
2008/01/29
|
Source:
Database Journal
|
Category:
MDX
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,052 reads
Building a Localized Report on a SQL Server 2005 Analysis Service Cube Data Source
Learn how to use an Analysis Services cube as a data source by using parameterized MDX queries, as well as how to localize label strings in a report, in SQL Server 2005.
Read more...
By
Additional Articles
2008/01/07
|
Source:
TechNet
|
Category:
SQL Server 2005
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,262 reads
Set Functions: The .AllMembers Function
Business Intelligence Architect Bill Pearson introduces the useful .AllMembers function, reinforcing the basic concepts, as always, with hands-on practice examples.
Read more...
By
Additional Articles
2008/01/04
|
Source:
Database Journal
|
Category:
MDX
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,268 reads
MDX Numeric Functions: The Max() Function
Business Intelligence Architect Bill Pearson introduces the numeric Max()function, and leads hands-on practice examples of the basic concepts.
Read more...
By
Additional Articles
2008/01/02
|
Source:
Database Journal
|
Category:
MDX
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,259 reads
String Functions: The .Properties Function, Part II
Business Intelligence Architect Bill Pearson continues his hands-on introduction to the .Properties function. In this article, we examine the use of the TYPED flag within the .Properties function to deliver a strongly typed value using .Properties.
Read more...
By
Additional Articles
2007/11/05
|
Source:
Database Journal
|
Category:
MDX
Rating:
(not yet rated)
Rate this
|
Briefcase
|
1,461 reads
String Functions: The .Properties Function
Business Intelligence Architect Bill Pearson introduces the basic .Properties function, within the first of a two-part article surrounding this important member of our MDX toolsets.
Read more...
By
Additional Articles
2007/09/14
|
Source:
Database Journal
|
Category:
MDX
Rating:
Rate this
|
Briefcase
|
2,035 reads
Logical Functions: IsGeneration(): Conditional Logic within Filter Exp
Use IsGeneration() to support conditional logic within filter expressions. BI Architect Bill Pearson looks beyond employing IsGeneration() in calculations, and provides hand-on practice in its use within the MDX Filter() function.
Read more...
By
Additional Articles
2007/08/17
|
Source:
Database Journal
|
Category:
MDX
Rating:
Rate this
|
Briefcase
|
1,313 reads
Different forms of CrossJoin
This article is about different syntactical ways to write CrossJoin in MDX, all of which are completely equivalent from the functional and performance standpoint. Therefore, the article doesn't convey any practical information, and can be ignored. Readers curious about history of MDX can keep reading, however.
Read more...
By
Additional Articles
2007/03/16
|
Source:
MSDN Communities
|
Category:
MDX
Rating:
Rate this
|
Briefcase
|
3,224 reads
Logical Functions: IsAncestor(): Conditional Logic within Calculations
Use IsAncestor() to support conditional logic within calculations. BI Architect Bill Pearson introduces IsAncestor(), and then leads a hands-on practice session with this valuable MDX function.
Read more...
By
Additional Articles
2007/02/15
|
Source:
Database Journal
|
Category:
MDX
Rating:
Rate this
|
Briefcase
|
1,698 reads
Items 1 to 15 of 15
Most popular
The Unpopular SELECT Statement
SELECT statements should be the most popular query in SQL Server, so why are they unpopular? It's the complex, confusing MDX SELECT statement that warehousing expert Vincent Rainardi is writing about.
Read more...
By
Vincent Rainardi
2008/02/20
|
Source:
SQLServerCentral.com
|
Category:
MDX
Rating:
|
Discuss
|
Briefcase
|
13,930 reads
Intrinsic Member Properties: The MEMBER_KEY Property
Join BI Architect Bill Pearson in an introduction to the intrinsic MEMBER_KEY property. In hands-on exercises, we gain exposure to the use of the property in generating simple lists, as well as datasets to support report parameter picklists.
Read more...
By
Additional Articles
2008/07/11
|
Source:
Database Journal
|
Category:
Analysis Services
Rating:
Rate this
|
Briefcase
|
813 reads
String Functions: The .Properties Function
Business Intelligence Architect Bill Pearson introduces the basic .Properties function, within the first of a two-part article surrounding this important member of our MDX toolsets.
Read more...
By
Additional Articles
2007/09/14
|
Source:
Database Journal
|
Category:
MDX
Rating:
Rate this
|
Briefcase
|
2,035 reads
Copyright © 2002-2008 Simple Talk Publishing. All Rights Reserved.
Privacy Policy.
Terms of Use