Questions tagged [multidimensional-cube]
59 questions
0
votes
1 answer
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 16GB', '2021-01-01', 200),
(2, 'Storage', 'Seagate…
Pragmateek
- 13,174
- 9
- 74
- 108
0
votes
1 answer
SSAS Two Data Sources in one Cube
I have 2 data source which is Hospital A and Hospital B that have same structure.
On Data Source View , I add same table for Hospital A and Hospital B like this ->
enter image description here
then I add hospital_key attribute in the fact table…
merry
- 17
- 7
0
votes
1 answer
How to Rank in order without skipping in MDX query
I have a MDX query that Rank clients but in the WHERE Clause I added
With Member [Measures].[Rank2] As
IIF([DimClient].[Client].CurrentMember.member_caption = [ClientBenchmark].[ClientGroup].currentMember.member_caption,0,
Rank…
Mike Eale
- 101
- 1
- 9
0
votes
1 answer
SSAS calculated measure not slicing with its filtered dimension
I have created a measure like this, the problem is it's not slicing with its own dimension. Is it expected this way or am I missing something. I am new to MDX scripting, any help would be highly appreciated.
CREATE MEMBER…
Arjun
- 1,049
- 6
- 23
- 37
0
votes
1 answer
SSAS - multi-dimensional - forecasting options
I am using SQL Server 2019 (Enterprise Edition) and looking for enhancing our SSAS model (MD) to provide foresting capabilities. Which are the options I have?
I saw that data mining feature was deprecated since SQL Server 2017. The next option is…
bjnr
- 3,353
- 1
- 18
- 32
0
votes
0 answers
How does SSAS Multidimensional engine works?
I was googling about "How does SSAS Multidimensional works?" but unfortunately couldn't get any related post.
Basically my question is how does it's engine works and why it works faster than the SQL server database. I actually want to know the…
Shahab Haidar
- 625
- 3
- 11
- 25
0
votes
1 answer
Funtion to Generate a Unit hypercube in any Dimesion (Python)
I need to write a python function that returns a list or tuple of coordinates for a unit hypercube, (square/box/tesseract etc.) based on starting coordinates that will be placed in the top left. I have a vector class that takes a list of any length,…
Bagel03
- 725
- 7
- 22
0
votes
1 answer
MDX Combine two queries
I need two join two queries, I tried with members but it didn't work. I am new to MDX, please let me know if there a way of doing this. Error is due to list in the calculated member.
SELECT NON EMPTY { [RR TYPE].[Item].[Item].ALLMEMBERS *…
Arjun
- 1,049
- 6
- 23
- 37
0
votes
2 answers
Create Calculate Measure Based On One Dimension And 2 Relations In SSAS
Please Consider this Fact Table:
Sender Receiver Amount
----------------------------------------
Reseller1 Resseler2 100
Reseller1 Resseler3 200
Reseller3 Resseler1 150
Reseller3 …
Arian
- 12,793
- 66
- 176
- 300
0
votes
2 answers
MDX - Display the labels/values for dimensions for this MDX query
Usually I display a value for dimensions by using the CurrentMember.Value/caption as as an alias.
For the following query this breaks with an error along the lines of
'The hierarchy [Measures] appears in more than one axis or in an axis/axes and a…
TilleyTech
- 441
- 5
- 13
0
votes
1 answer
MDX - Dimension on rows and Measure and a Dimension on Columns
I am now adding to something I am writing and need to offer the user the ability to place dimensions and measures on either the rows or columns.
I am about to test an idea to make the MDX for the example in the picture but realised I should also ask…
TilleyTech
- 441
- 5
- 13
0
votes
2 answers
MDX query works but ignores the EXCEPT clause
I have been working on a custom dll (that is called via a custom xll / Excel Addin) to construct MDX and return 2D data.
It's working nicely and I just went to work out how I add the ability to send in an exclusion list using EXCEPT.
I built up a…
TilleyTech
- 441
- 5
- 13
0
votes
1 answer
How to join time intervals with measure groups within a cube in SSAS?
I would like to create a intersection between a dimension that has following attributes:
Customer ID | Customer Level | Date From | Date To
1234 | Level 1 | 01.01.2018 | 31.12.2018
1234 | Level 2 | 01.01.2019 | 31.05.2019
And a measure group such…
markoo
- 19
- 3
0
votes
0 answers
Creating a calculated measure to display prev month value
I have a cube(multidimensional) in SSAS which contains a dimension with a period hierarchy(year, month, periodcategory, periodcode) and a measure "Amount"
Now i try to make a calculated measure which returns the value Amount for the previous month -…
Tim
- 21
- 2