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

Either through a PivotTable, Excel cube functions, or Power BI tools ... 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

NULL ... View more

Improve functionality of MS BI products on PCs, laptops, tablets, smart-phones etc by integrating with touchscreen capability in a similar way to Roambi, Tableau and Qlikview. Ability to play with BI in such an intuitive way would be awesome. ... View more

If I understand correctly, currently Power BI Q&A only have "count" formula and not support distinct count functionality. Will be very helpful for Operations data, where both count and distinct count are valuable. Thanks! ... View more

Add an OData Extension so SSRS can easily access such data sources ... View more

I have several smaller customers who have needed something like the old report models. Obviously they would need to be a bit better than they were and would need to be queryable by tools other than just SSRS / Report Builder. Ideally some sort of exploration of the model from within Excel. ... View more

Enjoy! http://prologika.com/CS/blogs/blog/archive/2015/02/05/my-wish-list-for-sql-server-vnext.aspx ... 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

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

Add spatial data types as attributes which can then be added to visualizations. For example drag in custom polygons to overlay on maps rather than rely on PowerMap geocoding. ... View more

Create a data modeling Language based on a textual representation (such as SQL DML, no XML) that would enable comparison between versions and easy copy/paste between data models ... View more

Add dynamic actions and effects to reports to make them more interactive. There are several great examples of after-market products and projects that demonstrate what could be accomplished by adding JavaScript support to SSRS rendering, such as d3js.org. I think this is what many users consider to be a "modern" report UI. The work that Jason and his group have done at ForeRunner SW using JSON to layer JavaScript over SSRS in the rendering phase demonstrates how the current product could be enhanced in very specific ways. ... View more

Remove the requirement to have powerview require SharePoint integration. Use power view as the experience for self service and remove report builder. This way we have symmetry between on premise and our cloud PowerBi offering ... View more

Parameters are the key to building interactive reporting solutions but complex report designs can become difficult to maintain. Let's say that I have ten items on a dashboard style report that pass all the parameters back to the same report (which is necessary to maintain the state of previously-selected parameter values)... Now I add one more parameter to the report and I have to find every item with an action to add that parameter. If there were some kind of a parameter collection object, similar to the property bag in old VB or the Request/Response/Application/Cookies objects commonly used in ASP.NET; this could be used to add the new parameter to the collection and simply pass the whole thing as an object to maintain the state of previously selected values. I have several specific thoughts and examples to share on this subject. ... View more

NULL ... View more

This is often needed where the table of account has to satisfy more than one legal requirement. Now I have to use (misuse) some kind of many-to-many relationship that sometimes makes MDX expressions somewhat complex. ... View more