nTuple, LLC

What's an nTuple?

So, what's an nTuple, anyway?

Wikipedia defines it as an ordered list of elements in mathematics, computer science, linguistics, or philosophy.  In set theory, an (ordered) n-tuple is a sequence of n elements, where n is a non-negative integer.

For example, latitude and longitude are 2-tuples; latitude, longitude and altitude are 3-tuples; add time, and it becomes 4-tuples.  
To put it in EPM Essbase terms:

  • Sample/Basic data consists of 5-tuples: Year, Measures, Product, Market, Scenario  

  • ASOsamp data consists of 10-tuples:  Measures, Years, Time, Transaction Type, Payment Type, Promotions, Age, Income Level, Products, Stores

    Note: The attribute dimensions are not, strictly speaking, members of the nTuple. They can be used in queries, in replacement of the base dimension to represent the n-tuple:

    • Sample/Basic:  Product - or Caffeinated, Intro Date, Ounces, Pkg Type
    • Sample/Basic:  Market - or Population
    • ASOsamp:  Stores - or Square Footage or Store Manager
    • ASOsamp:  Geography - or Area Code

    Finally, yes, a query can contain more than one of the above lists (a base dimension and its attributes), but in reality it's an “overspecification” of the nTuple that requires the query engine to resolve the AND/OR logic of the combination.


    [en-too-puhl, -tyoo-, -tuhp-uhl; en-too-puhl, -tyoo-]