Writing a Basic MDX Query Pt.2

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Brian Knight » Writing a Basic MDX Query Pt.2 - SQL School...

Writing a Basic MDX Query Pt.2 - SQL School Video

Rate Topic

Display Mode

Topic Options

Author

Message

Brian Knight

Posted Tuesday, November 25, 2008 7:18 PM

SSCommitted

Group: Moderators
Last Login: Monday, August 13, 2012 1:06 PM
Points: 1,928, Visits: 224

Comments posted to this topic are about the item Writing a Basic MDX Query Pt.2 - SQL School Video

Brian Knight
Free SQL Server Training Webinars

Post #608790

Tobar

Posted Thursday, December 11, 2008 9:00 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 7:01 AM
Points: 167, Visits: 549

Brian,

Create videos. Thanks.

I have a question. When you demonstrate creating multiple calculated measures you say that "you can use the data from the first one". I don't get what you are saying. The only similarity is the measure [Internet Order Quantity], but that is just a standard measure. I don't consider that one "data from the first [calculated measure]". Am I missing something? Did you mean to demonstrate something like

WITH MEMBER [MEASURES].[FirstCalcMember] AS
[MEASURES].[SOMETHING] /
[MEASURES].[SOMTHING ELSE]

MEMBER [MEASURES].[SecondCalcMember] AS
[MEASURES].[FirstCalcMember]*
[MEASURES].[YET SOMETHING ELSE] [\code]

Thanks.

<><
Livin' down on the cube farm. Left, left, then a right.

Post #618010

Anipaul

Posted Thursday, December 11, 2008 10:06 PM

SSCarpal Tunnel

Group: General Forum Members
Last Login: Yesterday @ 6:03 AM
Points: 4,787, Visits: 1,335

Nice one...

Post #618378

aragornguan1972

Posted Monday, August 24, 2009 5:36 PM

Forum Newbie

Group: General Forum Members
Last Login: Wednesday, November 14, 2012 9:08 PM
Points: 2, Visits: 41

Hi Brian, it's a fantastic one and I will expect more vedio in the future.
But Could you please post your script on your vedio so that's really benefit for our programming.
Thanks in advance!
aragornguan1972@gmail.com

Post #776379

irshadmohideen

Posted Tuesday, March 09, 2010 11:44 PM

Valued Member

Group: General Forum Members
Last Login: Tuesday, May 29, 2012 8:32 AM
Points: 57, Visits: 108

Nice demonstration of MDX. Very Cool.

Irshad

Post #879959

Prashanth Babu T

Posted Monday, November 01, 2010 10:14 AM

SSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 10:22 AM
Points: 128, Visits: 156

The video was really helpful. Looking for more tutorials on MDX...

-Prashanth

Post #1013934

« Prev Topic | Next Topic »

Permissions