Using MDX for queries 36 SELECT, FROM, ON COLUMNS, ON ROWS WHERE 50 Summary 52

39

v

Contents

Chapter 4 ! MDX syntax

53
53

Brackets, braces and the odd dot and comma

Chapter 5 ! MDX expressions

58

Recapof cell naming 59 The concept of the current cell 61 Relative cell referencing 62 The practicalities – how to look at the data in a cube 65 1 Comparing values 69 The practicalities – how to create a calculated member 72 2 Comparing values between years 74 3 Calculating values to date 77 Summary 78

...Chapter 3: Introduction toMDX
Page 1 of 1
Chapter 3: Introduction toMDX
In Chapter 2 you ran a simple MDX query to retrieve data from Analysis Services 2005. Building on that, in this
chapter you learn the fundamental concepts underlying MDX and how you can manipulate and query
multidimensional objects within Analysis Services using MDX. This chapter forms the basis for...

Empresa

Seguir

{"essaysImgCdnUrl":"\/\/images-study.netdna-ssl.com\/pi\/","useDefaultThumbs":true,"defaultThumbImgs":["\/\/bts-study.netdna-ssl.com\/stm\/images\/placeholders\/default_paper_4.png","\/\/bts-study.netdna-ssl.com\/stm\/images\/placeholders\/default_paper_2.png","\/\/bts-study.netdna-ssl.com\/stm\/images\/placeholders\/default_paper_3.png","\/\/bts-study.netdna-ssl.com\/stm\/images\/placeholders\/default_paper_4.png","\/\/bts-study.netdna-ssl.com\/stm\/images\/placeholders\/default_paper_5.png"],"thumb_default_size":"160x220","thumb_ac_size":"80x110","isPayOrJoin":false,"essayUpload":true,"site_id":2,"autoComplete":false,"isPremiumCountry":true,"userCountryCode":"US","logPixelPath":"\/\/www.smhpix.com\/pixel.gif","tracking_url":"\/\/www.smhpix.com\/pixel.gif","cookies":{"unlimitedBanner":"off"},"essay":{"essayId":1390152,"categoryName":"Informes de libros","categoryParentId":null,"currentPage":1,"format":"text","pageMeta":{"text":{"startPage":1,"endPage":50,"pageRange":"1-50","totalPages":228}},"access":"free","title":"Fast track to mdx","additionalIds":[],"additional":[],"loadedPages":{"html":[],"text":[1,2,3,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50]}},"user":null,"canonicalUrl":"http:\/\/www.buenastareas.com\/ensayos\/Fast-Track-To-Mdx\/463275.html","pagesPerLoad":50,"userType":"member_guest","ct":0,"ndocs":"11,100,000","pdocs":"","cc":"10_PERCENT_1MO_AND_6MO","signUpUrl":"https:\/\/www.buenastareas.com\/inscribirse\/","joinUrl":"https:\/\/www.buenastareas.com\/join.php","payPlanUrl":null,"upgradeUrl":"\/contribuir?newuser=1","freeTrialUrl":null,"showModal":"get-access","showModalUrl":"https:\/\/www.buenastareas.com\/inscribirse\/?redirectUrl=https%3A%2F%2Fwww.buenastareas.com%2Fjoin.php","joinFreeUrl":"\/contribuir?newuser=1","siteId":2,"facebook":{"clientId":"117783761627229","version":"v2.8","language":"es_ES"},"analytics":{"googleId":"UA-18439344-1"}}