Learning Documentation Community Open Exchange Global Masters Certification Partner Directory Ideas Portal
Developer Community
  • Posts
    • InterSystems Official
    • Articles
    • Questions
    • Announcements
    • Discussions
    • Tags
  • Events
    • Tech Article Contest
    • Programming Contest
    • InterSystems Ideas Contest
    • Event Calendar
  • Products
    • InterSystems IRIS
    • InterSystems IRIS for Health
    • HealthShare
    • TrakCare
    • Caché
    • Ensemble
    • InterSystems Analytics (DeepSee)
    • InterSystems Text Analytics (iKnow)
  • Jobs
    • Job Opportunity
    • Job Wanted
  • Members
  • About
    • About Us
    • FAQ
    • Feedback
    • Report an Issue
    • Share an Idea
    • Code of Conduct
    • Contact Us

EN

Search by posts, members, tags
Language
EN|
ESPTJPCNFREN
New post
  • All posts
  • InterSystems Official
    New
  • Announcements
  • Articles
  • Questions
  • More...
  • No answer
  • No accepted answer
  • With accepted answer
  • Discussions
  • Videos
  • Jobs
  • Jobs Opportunities
  • Jobs Wanted

InterSystems resources

  • Download InterSystems IRIS
  • InterSystems Container Registry
  • Early Access Program
  • Developer Hub
  • Share an idea
  • Become a partner
  • InterSystems IRIS Cloud SQL
  • InterSystems IRIS on AWS
  • InterSystems FHIR Server on AWS
  • InterSystems IRIS on Azure

Our social networks

  

#MDX

4

Multidimensional Expressions (MDX) is a query language for online analytical processing (OLAP) using a database management system. Much like SQL, it is a query language for OLAP cubes.

By replies
  • By update
  • By date
  • By likes
  • By views
  • By replies
AllTop
Article
Stephen Canzano · Jun 28 3m read
Analytics Cube Definitions and References

Maybe this is well known but wanted to help share.

Consider that you have the following persistent class defintions

An Invoice Class with a property reference to Provider

#Analytics #Cubes #Data Model #MDX #SQL #Tips & Tricks #InterSystems IRIS BI (DeepSee)
0 0
0 15

Trending posts

Celebrating a Lifelong Contributor of the Developer Community
Anastasia Dyubaylo
9 111
The last day of the InterSystems Ready 2025
Irène Mykhailova
8 100
Exposing a Basic REST API with InterSystems IRIS: Step-by-Step Docker Example
Marco Bahamondes
3 41
Show more (2)
InterSystems for dummies – Machine learning II
Kurro Lopez
0 68
First half of the InterSystems Ready 2025
Irène Mykhailova
0 63

Recently released

AnalyzeThis
by Peter Steiwer
1.2K803
IRIS Interop DevTools
by Chi Nguyen-Rettig
439
MDX2JSON
by Eduard Lebedyuk
1K34.7K
Featured
iris-vector-search
by Fan Ji
1.5K

News

Full details

  • Privacy & Terms
  • Guarantee
  • Section 508
  • Contest Terms
  • Cookies Settings
© 2025 InterSystems Corporation, Cambridge, MA. All rights reserved.

Log in or sign up

Log in or create a new account to continue

Log inSign up

Log in or sign up

Log in or create a new account to continue

Log inSign up

Log in or sign up

Log in or create a new account to continue

Log inSign up

Log in or sign up

Log in or create a new account to continue

Log inSign up