Visão Geral

O Curso MDX Developer, é para qualquer pessoa que precisa da linguagem MDX para criar membros calculados, definir KPIs, ir além dos assistentes do Reporting Services e usar funções de cubo do Excel.

Esta é uma linguagem diferente do SQL, por isso o treinamento aborda os fundamentos e, em seguida, aprofunda seus conhecimentos nesta área.

Publico Alvo

• Gerentes de projeto,
• Desenvolvedores
  

Pre-Requisitos

Bons conhecimentos de cubos, dimensões, medidas

Informações Gerais

• Carga horaria 16h
• Se em horário integral este curso e realizado das 09h às 18h, total de 2 dias;
• Se noturno este curso e ministrado de segunda a quinta das 19h às 23h, total de 4 noites;
• Se aos sábados este curso e ministrado das 09h às 18h, total de 2 sábados;
• Se in-company este curso e ministrado de acordo com agenda do cliente;
• Apostila em arquivo digital

Formado de Entrega do Curso:

• on-line ao vivo, via Microsoft Teams, na presença de um instrutor/consultor Curso MyReport Builder, MyReport Data

Materiais

Conteúdo Programatico

Fundamentals of the MDX language

1. Dimension, Measure, Member, Attribute Hierarchies, User
2. Tuple, Set
3. Member designation
4. By name
5. By key
6. Tuple
7. designation Set designation
8. In extension, by ranges
9. Our 1st query
10. Slicing, row data and columns
11. The Where clause and its limits
12. Crossjoin , No empty

Navigating in hierarchies

1. Members, all, allmembers, children
2. Parent, PrevMember, Nextmember
3. CurrentMember
4. Descendants, ascendants
5. Siblings

Calculated Members and Named Sets

1. Named members
2. Definition with the WITH clause
3. Formatting results
4. Named
5. sets with the WITH clause Combination of set and member

Control program flow

1. Case
2. Iif
3. Management of empty values ​​with isempty
4. Capture of errors by error

Filter data

1. The limits of the Where clause
2. Sub-queries
3. Sub-cubes
4. The exists
5. Filter clause on measures, on dimension members
6. VBAMDX functions in filtering expressions
7. Remove duplicates by distinct Set
8. difference with except
9. Intersection with intersect
10. Union of sets

Order data

1. Order
2. Sorting by default with Hierarchize
3. Break the
4. TopCount hierarchies , bottomcount
5. Head to extract the 'best'
6. Tail to extract the last
7. Subset

Aggregation functions

1. Count
2. Existing to count in the context
3. Distinctcount
4. Max
5. Min
6. Sum
7. Avg
8. Members calculated with aggregation
9. Give a ranking with Rank

Manipulations on time dimensions

1. The Traps of the Time Dimension
2. Parrallelperiod
3. Cousin
4. OpeningPeriod, ClosingPeriod
5. PeriodsToDate
6. LastPeriods
7. Wtd, Mtd, Qtd,
8. Ytd Slippery totals with Mtd

Access to given metas

1. Name, UniqueName, membervalue, member_caption
2. Properties typed and untyped
3. Caption, Key, Value
4. Management of composite keys
5. Conversions from / to strings
6. Strtomember, MemberToStr
7. Strtoset, SetToStr
8. StrToTuple, TupleToStr
9. Produce a CSV with Generate
10. Case of Reporting Services parameters

Working with KPIs

1. What are KPIs?
2. KPIValue
3. KPIGoal
4. KPIStatus
5. KPITrend
6. How to manage the objectives?
7. Define a KPI: Value, objective, status, trend
8. A method of debugging KPIs
9. Recommended methods for writing high-performance and maintainable MDX code