Microsoft Technologies

SQL Server,Business Intelligence, SQL Server DBA, Share Point, Dot Net

Pages

  • SQL Server
  • SSIS
  • SSAS
  • MDX
  • SSRS
  • SQL DBA
  • PPS
  • Interview Q & A

Friday, August 7, 2015

MDX Concepts


MDX- Introduction
SQL Vs MDX
Various MDX Queries

MDX Functions
Ascendants
AVG
BottomCount
BottomPercent
BottomSum
Children
ClosingPeriod
Cousin
FirstChild
FirstSibling
Head
LastChild
LastSibling
LastPeriods
Lag
Lead
NextMember
OpeningPeriod
ParallelPeriod
Parent
PeriodsToDate
PrevMember
Siblings
Tail
TopCount
TopPercent
TopSum
Posted by Srinivas Gorantla at 4:37 PM
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: MSBI Concepts
Newer Post Older Post Home

Labels

  • Interview Questions and Answers (18)
  • Microsoft Business Intelligence (MS BI) (6)
  • Tabular Model (SSAS) (1)

About Me

Srinivas Gorantla
View my complete profile

Blog Archive

  • ▼  2015 (294)
    • ►  November (30)
      • ►  Nov 04 (1)
      • ►  Nov 03 (9)
      • ►  Nov 02 (10)
      • ►  Nov 01 (10)
    • ►  October (94)
      • ►  Oct 31 (8)
      • ►  Oct 30 (1)
      • ►  Oct 15 (1)
      • ►  Oct 11 (9)
      • ►  Oct 10 (8)
      • ►  Oct 09 (1)
      • ►  Oct 07 (3)
      • ►  Oct 06 (6)
      • ►  Oct 05 (10)
      • ►  Oct 04 (8)
      • ►  Oct 03 (14)
      • ►  Oct 02 (10)
      • ►  Oct 01 (15)
    • ►  September (34)
      • ►  Sep 10 (2)
      • ►  Sep 06 (2)
      • ►  Sep 05 (4)
      • ►  Sep 04 (7)
      • ►  Sep 03 (5)
      • ►  Sep 02 (10)
      • ►  Sep 01 (4)
    • ▼  August (84)
      • ►  Aug 23 (1)
      • ►  Aug 21 (20)
      • ►  Aug 19 (15)
      • ►  Aug 18 (24)
      • ►  Aug 17 (2)
      • ►  Aug 13 (4)
      • ►  Aug 12 (6)
      • ►  Aug 11 (4)
      • ▼  Aug 07 (5)
        • MDX Concepts
        • SQL Server Concepts
        • SSRS Concepts
        • SSAS Concepts
        • Dtabase Overview
      • ►  Aug 06 (1)
      • ►  Aug 04 (1)
      • ►  Aug 01 (1)
    • ►  July (52)
      • ►  Jul 28 (6)
      • ►  Jul 27 (12)
      • ►  Jul 25 (1)
      • ►  Jul 23 (1)
      • ►  Jul 22 (9)
      • ►  Jul 21 (4)
      • ►  Jul 17 (19)
  • ►  2013 (303)
    • ►  August (212)
      • ►  Aug 22 (2)
      • ►  Aug 21 (10)
      • ►  Aug 20 (10)
      • ►  Aug 19 (10)
      • ►  Aug 18 (10)
      • ►  Aug 17 (10)
      • ►  Aug 16 (10)
      • ►  Aug 15 (10)
      • ►  Aug 14 (10)
      • ►  Aug 13 (10)
      • ►  Aug 12 (10)
      • ►  Aug 11 (10)
      • ►  Aug 10 (10)
      • ►  Aug 09 (10)
      • ►  Aug 08 (10)
      • ►  Aug 07 (10)
      • ►  Aug 06 (10)
      • ►  Aug 05 (10)
      • ►  Aug 04 (10)
      • ►  Aug 03 (10)
      • ►  Aug 02 (10)
      • ►  Aug 01 (10)
    • ►  July (91)
      • ►  Jul 31 (10)
      • ►  Jul 30 (10)
      • ►  Jul 29 (10)
      • ►  Jul 28 (10)
      • ►  Jul 27 (10)
      • ►  Jul 26 (10)
      • ►  Jul 25 (10)
      • ►  Jul 24 (10)
      • ►  Jul 23 (11)

Reference Blogs

  • Bhushan-SSRS
  • ExactHelp
  • PHPRing
  • PassionForSQL
  • SQL Chick
  • SQL Knowledge
  • SQLAge
  • SQLCircuit
  • SQLServerLog
  • SatishMSBIWorld
  • TeachMeSQLServer
  • Tutorialgateway
Picture Window theme. Powered by Blogger.