-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 ...