EuclidOLAP

Overview Quick Start Demo Docs Download GitHub

Concepts

MDDB introduction What is EuclidOLAP? Multidimensional Model Demo Example

Setup

Get Started

Run EuclidOLAP binary Docker OLAP Web Console

MDX Manual

MDX Introduction Member Functions

ClosingPeriod CurrentMember FirstChild FirstSibling Lag LastChild LastSibling Lead OpeningPeriod ParallelPeriod Parent PrevMember

Set Functions

BottomPercent Children CrossJoin Descendants Except Filter Intersect LateralMembers Members Order Tail TopCount TopPercent Union Ytd

Numeric Functions

CoalesceEmpty Count (Set) IIf LookUpCube Sum

Logical Functions

IsEmpty

String Functions

Name

Examples

Simple queries

Create Dimensions Create Levels Build Cube Create Members Insert Measure Data Building Example Model Basic MDX Queries Data Aggregation Tuples and Sets Roll-Up and Drill-Down Slicing and Dicing Pivoting Cube

SDK

Java

Members

The MDX Members function returns all members of the specified dimension or layer.

Syntax

Members ( dimension )

Arguments

dimension

A dimension specification.

Notes

Examples

select
members([Goods], NOT_LEAFS) on 10,
members(Calendar, LEAFS) on 100
from [Online Store];

	ALL	Kitchen & Dining	Home Electronics	Cell Phones & Accessories	Computers & Cameras	foods	electronic product	household appliances
M1	0	0	0	0	0	0	0	0
M2	0	0	0	0	0	0	0	0
M3	0	0	0	0	0	0	0	0
M4	0	0	0	0	0	0	0	0
M5	0	0	0	0	0	0	0	0
M6	0	0	0	0	0	0	0	0
M7	0	0	0	0	0	0	0	0
M8	0	0	0	0	0	0	0	0
M9	0	0	0	0	0	0	0	0
M10	0	0	0	0	0	0	0	0
M11	0	0	0	0	0	0	0	0
M12	0	0	0	0	0	0	0	0
M1	1440	360	360	360	360	0	0	0
M2	1440	360	360	360	360	0	0	0
M3	1440	360	360	360	360	0	0	0
M4	1440	360	360	360	360	0	0	0
M5	1440	360	360	360	360	0	0	0
M6	1440	360	360	360	360	0	0	0
M7	1440000	360000	360000	360000	360000	0	0	0
M8	1440000	360000	360000	360000	360000	0	0	0
M9	1440000	360000	360000	360000	360000	0	0	0
M10	1440000	360000	360000	360000	360000	0	0	0
M11	1440000	360000	360000	360000	360000	0	0	0
M12	1440000	360000	360000	360000	360000	0	0	0
M1	1440	360	360	360	360	0	0	0
M2	1440	360	360	360	360	0	0	0
M3	1440	360	360	360	360	0	0	0
M4	1440	360	360	360	360	0	0	0
M5	1440	360	360	360	360	0	0	0
M6	1440	360	360	360	360	0	0	0
M7	7238	1744	1836	1761	1897	0	0	0
M8	7359	1721	1697	1787	2154	0	0	0
M9	7491	1887	1993	1909	1702	0	0	0
M10	7290	1751	2049	1640	1850	0	0	0
M11	7148	1840	1939	1923	1446	0	0	0
M12	6793	1699	1493	1899	1702	0	0	0

About

What is EuclidOLAP?
Architecture

Code & Docs

EuclidOLAP
Olap Web Console
Getting Started
Download

Community

Contact Us

euclidolap@outlook.com

Copyright © 2023 euclidolap.com. All Rights Reserved