Sumários

Lab 9

22 novembro 2018, 12:30 • Diogo Ribeiro Ferreira

Lab guide and exercises about MDX queries over an OLAP data cube.

Lab Guide 9: MDX language

20 novembro 2018, 15:30 • João Pedro Lebre Magalhães Pereira

Resolution of the lab guide 9 exercises.

Lab Guide 9: MDX language

20 novembro 2018, 14:00 • João Pedro Lebre Magalhães Pereira

Resolution of the lab guide 9 exercises.

MDX Language (cont) and Slowly Changing Dimensions

19 novembro 2018, 15:30 • Helena Galhardas

MDX language (cont.):

  • Calculated members and Named Sets
  • Relative Navigation
  • Filtering
  • Sorting
  • Top analysis
Slowly Changing Dimensions:
  • Definition
  • Types 1-7

MDX queries

19 novembro 2018, 15:30 • Diogo Ribeiro Ferreira

MDX concepts: tuple and set of tuples. MDX queries with slicing and navigation. MDX functions. Cross-join function and notation. Calculated members. Static and dynamic named sets. Relative navigation. Filtering with a function. Sorting and top analysis of results.