Questions tagged [multidimensional-cube]
59 questions
6
votes
1 answer
Linked dimension performance issue
I am working with 2 star schema data warehouses, each data warehouse contains a fact table and the dimensions tables are located in separate databases (one database used by both data warehouses).
I created a multidimensional analysis project for…
Yahfoufi
- 2,220
- 1
- 22
- 41
3
votes
1 answer
How to create Analysis Services Multidimensional Project template in Visual Studio 2019?
I'm trying to follow this tutorial. I use VS2019 Community and I've installed Microsoft Analysis Services Project extension. But when I try to create a new "Analysis Services Multidimensional and Data Mining Project" all I can see in the list of…
Svetlana
- 163
- 1
- 15
3
votes
1 answer
Multidimensional cube in AZURE
My database is created on Azure SQL environment and for reporting purpose I want to create multidimensional cube. But the problem is Azure didn't support multidimensional cube. So, Is there any alternative solution to perform multidimensional cube…
Manisha Chauhan
- 63
- 5
3
votes
1 answer
Are tabular and multidimensional models built the same way?
I'm having a real hard time understanding what the difference is between a tabular vs multidimensional model.
Don't both use dimensions and fact tables?
Can't both have a star or snowflake schema?
Don't both have measures and calculated…
JJ.
- 9,580
- 37
- 116
- 189
2
votes
1 answer
Find Sales Ratio To Target in MDX
I have an MDX query resulting this value
+-----------+----------+--------------+--------+----------------+------+
| | Sales Cumulative | Sales Ratio To Target |
+ …
gill23
- 593
- 1
- 5
- 19
2
votes
0 answers
MDX Calculated Member on Fact Dimension
I have written below query to get count of job numbers from a fact dimension. It is working fine.
WITH SET V_Lots AS
{[ABC Lots].[ABC Type].&[A]
,[ABC Lots].[ABC Type].&[O]}
*
{[ABC Lots].[ABC Load Nbr].[ABC Load Nbr]}
MEMBER
…
Arjun
- 1,049
- 6
- 23
- 37
2
votes
0 answers
MDM Cube browsing Fast vs Excel pivot being too slow
I have a MDM cube with fact having just 84K records. Simple STAR schema structure. All regular relationships and no calculations or KPIs.
While trying to browse the cube by pulling 15-20 attributes from various dimensions with no filters applied,…
Amit Singh
- 21
- 1
2
votes
0 answers
SSAS Calculated Member Aggregation Issue
I have a very simple Calculated Member:
CREATE MEMBER CURRENTCUBE.[Account].[Account Parent].&[NA_1].[Beginning Subscribers]
AS -[Account].[Account Parent].&[Beginning_Subscribers]
However, the Parent doesn't seem to calculate or simply…
Rob Allison
- 21
- 3
1
vote
1 answer
Multidimensional to Tabular SSAS Cube - KeyColumns/NameColumn Equivalent
I have a MutliDimensional Cube, it has a Dimension(Hierarchy) named "Scenario", within the Scenario dimension I have a "SA - Scenario" level which refers to a DimensionAttribute "Scenario ID", with the following configuration:
So for the Key…
David Rogers
- 2,601
- 4
- 39
- 84
1
vote
2 answers
Simple summation of a column that has its own formula in mdx
I have 3 measures: A, B, C
Measure c is this calculation:
IF(A>B)
THEN A-B
ELSE 0
This formula run for every records, which works fine. The problem is that.
I want to get sum of the measure c, the above formula work.
A B C
…
user21165597
- 11
- 1
1
vote
0 answers
SSAS MDX Calculated Measure - Grand Total not updating
Below in the snippet of Geography Hierarchy:
PFB the calculated measure query:
CREATE MEMBER CURRENTCUBE.[Measures].[Metric - vs PY %]
AS
IIf([Geography].[Geography Hierarchy].LEVEL.ORDINAL <> 5,
sum(existing [Geography].[Geography Hierarchy].[1…
Sudhir Upadhyay
- 11
- 2
1
vote
1 answer
Are threads in a multi-dimensional CUDA kernel blocks packed to fill warps?
NVIDIA GPUs have schedule complete warps to execute instructions together (well, sort of; see also this question). Thus, if we have a "linear" block of, say, 90 threads (or X x Y x Z = 90 x 1 x 1) - a GPU core will have three warps to schedule…
einpoklum
- 118,144
- 57
- 340
- 684
1
vote
0 answers
Error with Dynamic Row level security in Multidimensional OLAP
I tried to run a Multidimensional project with Dynamic RLS.
I used a Sample for implement it.
In my sample scenario, I've a cub like below :
I tried to write correct MDX query for test result of users permission.
SELECT {[Measures].[Point…
Amirhossein
- 1,148
- 3
- 15
- 34
1
vote
1 answer
Excel Version 2109 - October 14 - Build 14430.20306 Certain Multidimensional Cubes Become "Frozen" After Hierarchy Change
Say you have a excel file containing a cube(referencing a Multidimensional cube on a SSAS server) configured such that you have a hierarchy in the rows:
And this hierarchy has been expanded so that certain nodes are visible within this…
David Rogers
- 2,601
- 4
- 39
- 84
1
vote
1 answer
MDX - How to access only a given level of a hierarchy
I have a hierarchy that follows the following pattern:
Date - Dimension name
DateID - Hierarchy name
Year - Level1 name
Month - Level2 name
Day - Level3 name
I want to get the number of hotel stays per month (level2), without it being expanded by…
Miguel
- 401
- 5
- 13