python (12.9k questions)

javascript (9.2k questions)

reactjs (4.7k questions)

java (4.2k questions)

java (4.2k questions)

c# (3.5k questions)

c# (3.5k questions)

html (3.3k questions)

Questions - multidimensional-cube

Why MAX is NULL when projecting along the same dimension

Here is a vanilla "Sales" database: CREATE TABLE Sales(id INT, category VARCHAR(50), item VARCHAR(50), date DATE, amount DECIMAL(10, 2)); INSERT INTO Sales VALUES (1, 'Memory', 'Corsair ...
test-img

Pragmateek

ssas

mdx

olap

cube

multidimensional-cube

Votes: 0

Answers: 1

Latest Answer

You are correct in what you observe. Each dimension can only be used in one section of the MDX: either on ROWS, on COLUMNS, in the WHERE clause, or within a calculated member. Sometimes an MDX stateme...
test-img

Magnus Smith

Posts

Questions

Blogs

Jobs