This month's installment of "MDX Essentials" examines the HIERARCHY_UNIQUE_NAME intrinsic member property. Join SSAS Architect Bill Pearson in an introduction of this intrinsic member property, which Bill complements with hands-on exercises and sample uses.
2009-02-13
1,582 reads
Discover, through a hands-on practice exercise, a more sophisticated business use for the MDX BottomCount() function, in combination with the Generate(), Descendants(), Ancestor() and other functions we have explored within our series. Join BI Architect Bill Pearson in this, the second part, of an extended examination of the MDX BottomCount() function.
2008-12-05
1,889 reads
Most of the time we move data from an RDBMS to a cube, but there are places where you might want to provide a feedback loop to the RDBMS. Andrew Muyobo shows how SSIS can help you do this.
2008-11-21
12,013 reads
Business Intelligence Architect Bill Pearson continues his exploration of Attribute Members, in another member of a subseries surrounding significant components of the Analysis Services dimensional model. In this article we examine the attribute member Name property, whose appropriate use is important to good model design and overall system performance.
2008-10-24
2,199 reads
Isolate worst / lowest performers from the member population at large, and perform sophisticated analysis with BottomCount(). Join MSAS Architect Bill Pearson in the first of a pair of articles focusing upon the powerful BottomCount() function, where we experience “hands-on” some of the possible ways it can offer multi-perspective decision support.
2008-10-15
2,879 reads
MSAS Architect Bill Pearson leads hands-on exercises providing exposure to the use of the MEMBER_VALUE intrinsic member property. Join us in generating simple lists, as well as datasets to support report parameter picklists.
2008-09-23
2,026 reads
Join MSAS Architect Bill Pearson in hands-on exercises, where we gain exposure to the use of the MEMBER_UNIQUE_NAME property in generating simple lists, as well as datasets to support report parameter picklists.
2008-08-21
1,615 reads
Writing high-performance reports against Analysis Services cubes means learning MDX to some extent. Parameterization of MDX functions is one of those things that cannot be delivered solely via graphical MDX Editor. BI Architect Bill Pearson demonstrates a way to parameterize the highly useful TopCount() function.
2008-08-08
1,846 reads
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.
2008-06-24
1,399 reads
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.
2008-05-02
3,531 reads
By Brian Kelley
The following came across my YouTube feed today. It’s an interview with General James...
By Steve Jones
“You don’t need more time because you already have all the time that you...
I don’t currently manage Microsoft 365 Copilot in an enterprise environment, but it is...
Hi all, I’m looking for a SQL Server 2014 Developer Edition DVD. Does anyone...
I do have a question. At work, some groups of people have an inordinate...
Comments posted to this topic are about the item What Did Healthy Look Like?
How many types of DML triggers are there?
See possible answers