Hi Gurus ...
Planning for a MDX Training for me and my development team ...
The following has been proposed for a training course spread over three days ...
I need to know whether this will be enough or should some more things be added on to the same (anything that has been missed)...
I have the option of removing and adding from the list.
Module 1: OLAP Review
OLAP Databases
OLAP Definitions
Warehouse Data Flow
Module 2: MDX Foundations
The Role of MDX
MDX Member Names
Using the Calculated Member Builder
Working with Calculated Members
Module 3: Using MDX Expressions
Displaying Member Information
Displaying Family Tree Relatives
Working with Member Properties
Using Conditional Expressions
Module 4: Retrieving Values from a Cube
Understanding Multidimensional Coordinates
Retrieving a Value from a Cube
Percent of Total Calculations
Growth Calculations
Module 5: Creating Simple MDX Queries
Understanding MDX Query Statements
Creating Simple MDX Query Statements
Module 6: Creating and Manipulating Sets
Using Set Creation Functions
Using Set Manipulation Functions
Using Subquery Set Functions
Working with Dimension Interactions
Module 7: Using Aggregation Functions
Understanding Aggregation Functions
Using Time Set Functions
Calculating a Trend
Module 8: Case Study - Implementing Budget Allocations
Allocating Values from a Grand Total
Allocating Values from a Subtotal
Allocating Values Across Multiple Dimensions
Module 9: Using Calculated Cells
Respose needed urgently since I have to get back to the training team by tomorrow morningWhat is MDX?|||he he .. nice joke|||Originally posted by Enigma
he he .. nice joke
I'm serious...
This?
http://www.mdxsoftware.com/|||You are serious ... :confused:
Worked on OLAP ... Analysis Server ?
MDX = Multi - Dimensional Expressions
MDX is query language used for querying OLAP Cubes|||Sorry...no warehouse tools...
Had to build them manually...
No magic....
What do you think you can do with analysis services that you can't do manually?
My Multi Billion $$ Company only bought standard edition...
I did find 1 box with Enterprise though...|||Hmm ...
It seems you havent used OLAP Cubes yet ...
I agree it can be done manually too ... but you too would love the power of analysis a Cube gives you (just like a pivot table in excel) ...|||Any way I can sneak into the back of the class? I don't think Microsoft has developed a course for MDX, as yet. Probably because they know their MDX implementation has a few kinks to work out...|||MS does have a course for mdx and it has been out for about 3 or 4 years.
you will find an outline at this link.
Course 2093: Implementing Business Logic with MDX in Microsoft SQL Server 2000 (http://www.microsoft.com/traincert/syllabi/2093AFinal.asp)
it is MOC (Microsoft Official Curriculum)
i have taught it a few times and it is pretty good.
it appears that someone is going to be using the same exact outline
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment