While all the PowerView dashboarding capabilities are very nice and highly used, majority of our customers are analysts who'd like to be able to browse through a cube to perform ad-hoc analysis. A need for an ad-hoc cube browser tool is very strongly felt in such cases. A parallel would be tools like ProClarity (while it was still available),Cognos Analysis Studio and even SQL Management Studio! We can't deploy Management Studio across all work machines for Business Analysts and no, Excel is not the best cube browser out there. Please provide a finer version of an ad-hoc cube browser so that people don't have to custom build their own. ... View more

Provide the same support for SSAS Failover Clustered Instances (FCIs) as for the relational engine. This means support for SMBv3 and Clustered Shared Volumes (CSVs). This would enable a more consitent architecture for larger clusters which hosts relational als well as SSAS FCIs. ... View more

It would be handy to secure attributes in SSAS OLAP in a way that confidential attributes are only shown to a specific user group. Example: if you take customer-dimension in Adventure-Works attribute "birth date". (out of simplification) all user should be able to see all customers but only some users should be able to "see" birth-date. An allowed User should be able to show "birth date" as a propertie of costumer. if a restricted user opens the same report attribute "birth date" shouldn't be shown at all but still all other customer-related informations. ... View more

To add a logical folder for dimensions. For example, we have many date role-playing dimensions ... View more

When you have to design multiple partitions it's a good idea to have a partition generator that can create multipe partitions in you project in Vusial Studio. Like you provide a pattern SELECT * FROM FactTable Where PartitionValue = {0} and then {0} is enumerated through the all months of several years, or through whatever partition strategy is. ... View more

In Visual Studio (BI/SSAS/OLAP Cube). When you have a lot of attributes and mesures in perspectives, it is hard to find any specific attribute. Right now you cannot even sort them much less to filter or find by name. Some better interface is needed to nevicate throught items in perspectives. Additionally, when you add a new item (measure, attribute, etc.) the option is warranted that these are by default are checked (included) into certain perspectives. Otherwise one has to watch that item in visible through perspective. Alexey Voronin, BI Senior Developer, Moscow ... View more

Being able to drag and drop members on to the rows and columns, as well as filters and sub-cube filters was so much more useful when checking the validity of a cube I just built. ... View more

Integrate both Tabular and Multidimensional into a true semantic layer and allow mixing of both forms of SSAS. Allow developers to utilise either MDX or DAX. ... View more

In SSAS FE is always a bottle neck, hope we can make FE to support multi-thread. And improve MDX Rank function to dynamically work with more than one dimensions. ... View more

A way to relate dimension attributes simply for the purpose of accessing what used to be called member properties, rather than defining aggregation paths ... View more

A SSRS grid control (possibly with a pre-specified number of columns) that sources data from SSAS OLAP, is aggregate-aware and can accept mostly any MDX queries thrown at it (without any result set flattening). ... View more

As sad as it is, there needs to be focus on one way forward - that appears to be tabular. A migration path is needed, but having the two models is confusing and becoming unnecessary. Even if full support for MD features is not available I think this should still happen. ... View more

Today SSAS generates the TSQL when dimension and facts are loaded. BISM Tabular allows You to enter your own queries. The SSAS generated SQL is not the best and in order to do optimization in the loading scenarios you should be allowed to enter your own queries. ... View more

This is a frequent requested feature and useful for salary spread calculations and other areas. ... View more

This function has not been optimized in any release and is useless. If it was working it iwould be extremely important. ... View more

Lineage from ETL to DB to SSAS to Reports. Impact analysis on changing any point in the chain. ... View more

Add a capability so that annotations can be added to reports. So that explanations of numbers can be attached to reports. An example might be looking at a report and seeing one number that is particularly low and adding a note that explains this was because that division was closed/flooded/struck by ligtening. ... View more

Right now MS AS issues a table lock and that is not compatible with the in-memory optimized tables ... View more

Fix drillthrough in SSAS Multidimensional and Tabular. It needs to work with calculations (which means that devs can use MDX or DAX expressions that specify the rows returned when a user drills through on a calculation). We also need to be able to return user-friendly column names and control column order. ... View more