Tagged Questions
-1
votes
0answers
28 views
DAX's level of Business Logic [closed]
From what I have seen about DAX's ability, is it used for doing advanced business logic to be enable to do advanced calculation in the same level as a C sharp developer?
Would you see that DAX's ...
0
votes
0answers
37 views
When to use MOLAP or Tabular
What choice and factor do I need to consider if I gonna have my data mart database to use SSAS MOLAP or tabular?
Is there a guideline in what context to use MOLAP or tabular?
3
votes
1answer
214 views
How do I display subtotals in cube browser in SSAS 2012 (Sql Server Data Tools)?
Apparently this feature was available in previous versions but has now been removed.
What are some alternatives?
10
votes
1answer
227 views
MDX Query for RANK regardless of hierarchy
I'm hoping to add a calculation to my SSAS Cube (SSAS 2012) that will show the relative rank of whatever the current member is against all other members in that grouper, without specifying the ...
7
votes
1answer
136 views
Dynamic Dimension Security
I have a cube in SSAS 2012 with about 30 dimensions, one of which is Company.
The Company dimension contains a list of companies, of which there are several hundred in the cube. Our security model ...
6
votes
2answers
170 views
Few Questions about SSAS Cubes
I am newbie to SSAS 2012 and here are my questions:
Can we have measures of complex types (table)?
Is it possible to order the results by a specific measure or attribute?
My cube can be modeled as ...