Questions about olap
Read more about olap
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)
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 ...
Pragmateek
Votes: 0
Answers: 1
Mdx Query axis specification
Welcome to everyone.
I would be very thanks if anyone help me. I am not too expert writing mdx query.
I am working in a software that build a mdx query to get info from a OLAP structure.
I get the res...
erpota
Votes: 0
Answers: 1
Which is the best place to do intermediate Data Processing before building Power BI Visualisation?
This is a newbie question. Currently, I connect to an SSAS service from Excel and bring back data from multi-dimensional cubes. Some calculations (using cube data and one or two numbers are hardcoded ...
learner
Votes: 0
Answers: 1
Retrieve only existing combinations of dimensions
Here is a basic model with 2 tables in a 1-1 relationship:
CREATE TABLE CountriesNames(countryId INT, countryName VARCHAR(50));
INSERT INTO CountriesNames VALUES
(1, 'France'),
(2, 'Germany'),...
Pragmateek
Votes: 0
Answers: 1