File Library
MDX is an industry standard language that is at the heart of Essbase ASO calculations. It can be used to query both ASO and BSO. It also shows up in plenty of other places such as triggers and Smart Query.
This session starts at the beginning and using hands-on exercises, quickly develops MDX concepts, basic syntax and the most commonly used functions. Next we will make some comparisons and conversions from BSO Calc language. Last we will cover some intermediate topics including conditionals and rolling calculations.
Topics include:
· Syntax basics and concepts
· Basic queries and member calculations
· Hierarchical and cross dimensional references
· Controlling calculation order
· Simple and complex ratios
· IIF and CASE
· rolling calculations
Become a member of ODTUG to gain access to more than 12,500 files in our technical database.
- Not a member? Click through to the topic of interest to browse a list of available presentations.
- Already a member? Log-in here to access the full database
Click here to see the Full Techincal Resource Database