Submitted on02-04-201511:47 AMSubmitted byahmedhosnyon02-04-201511:47 AM
Ability to define data driven 'alerts's like in SSRS or subscribe to an interactive "copy of the report". For eg, getting a copy in PowerBI Designer format so the report is still interactive for that days data.
... View more
Submitted on02-04-201511:45 AMSubmitted byahmedhosnyon02-04-201511:45 AM
Add the option for end users to comment on dashboards (something similar to PowerBI dashboards). Commentary should be "global filter" sensitive, for eg, if this is a daily dashboard, going back to yesterday should show yesterdays comments only. Got a couple of customer requests for this.
... View more
Submitted on02-04-201509:30 AMSubmitted byAngryKoalaon02-04-201509:30 AM
There are many situations where SSAS Tabular models are infrequently used. Having them permanently in memory is wasting resources. Would be useful if they only attached (loaded into memory) on first end user query, and detached after a certain amount of time. And or a setting that says you want a particular model in memory permanently...
... View more
Submitted on02-04-201509:02 AMSubmitted byfbcideas_migusron02-04-201509:02 AM
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
Submitted on02-04-201508:59 AMSubmitted byfbcideas_migusron02-04-201508:59 AM
Add a method by which you can see the reports you have navigated through to get where you are now. This enables you to jump back and also gives you a good idea of where you are in complex report heirarchies
... View more
Submitted on02-04-201507:54 AMSubmitted bytivarssonon02-04-201507:54 AM
Since it is possible to import an Excel Power Pivot model to Tabular the reverse should also be possible in order to reuse existing development work and to add improvements outside a development environment.
... View more
Submitted on02-04-201507:41 AMSubmitted bythomas_martens1on02-04-201507:41 AM
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
Submitted on02-04-201507:34 AMSubmitted bytivarssonon02-04-201507:34 AM
There is no working editor today in Data Tools /Visual Studio. We need one with IntelliSense and syntax checking that do not erase everything when something is wrong.
... View more
Submitted on02-04-201507:29 AMSubmitted bytivarssonon02-04-201507:29 AM
Since there are already translations between DAX and MDX in both directions I think it should be possible to convert the models to each other with the exception of MDX scripting and DAX expressions. I have converted a MD model to a Tabular manually without any unsolved issues.
... View more
Submitted on02-04-201503:31 AMSubmitted byfbcideas_migusron02-04-201503:31 AM
Currently Tabular models don't scale well on servers with multiple NUMA nodes. Proper NUMA support should be built in as it is for Multidimensional models. This can be a limiting factor for very large models.
... View more
Submitted on02-04-201503:29 AMSubmitted byfbcideas_migusron02-04-201503:29 AM
I want to build the DAX for a Month-to-Date member of a Date Calculation dimension and have it apply to every measure in the model. This would require scope statements to do in a maintainable way.
... View more
Submitted on02-04-201503:27 AMSubmitted byfbcideas_migusron02-04-201503:27 AM
Currently the SSAS Tabular engine doesn't process partitions in the same table in parallel when loading data into the model. This is a major limiting factor on very large models.
... View more
Submitted on02-04-201501:31 AMSubmitted byfbcideas_migusron02-04-201501:31 AM
Integrate SSIS with the Power Query Excel Add-In as a Data Source. Solution needs to be all on-prem to avoid typical cloud concerns. Ideally can reach into a workbook for a specific Query or function, pass in function values if required, and trigger a refresh of a Query or all Queries.
... View more