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
When exporting from SSRS to Word, the resulting document always has a "Normal" style font of Times New Roman. In a common scenario, a report is exported from SSRS to Word, then an analyst/author uses Word to add commentary. If they click in any empty area and start typing, the "Normal" style will be applied with Times New Roman font. Ideally this could be set as a Report-level Property and passed to Word during the export process.
... View more
There are a couple of scenarios where column widths are not respected when exporting to Word. The most common is where a nested table has a column with "narrow" content - the column width sometimes shrinks to contents. The other is when a column contains a long word with no spaces or breaking characters - the Word column width is increased to the width of that word.
... View more
For SSRS Text Box controls, add a "Justify" option for the Horizontal/TextAlign property. This would produce fully justified text, as in Word. This feature supports automated production and distribution of documents of publication quality. This has been an open Connect item for over 5 years, gathering over 500 votes: https://connect.microsoft.com/SQLServer/feedback/details/404966/full-justification-in-reporting-services-2008-needed
... 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
The example I have is I'm working with a ~300MB CSV file. Every time I make any transforms on the file in Power Query, it goes and fully retrieves the CSV, performs the transform, then dumps it out again. Needless to say this gets really tedious in development mode. It would be nice to be able to cache a dataset in memory, sacrificing real-time access to the data for performance while in Power Query (and perhaps Power View as well.)
... View more
Sometimes when there is a difference in the sample sizes for two groups it is important to look at the proportions instead of just the counts or sum. This at least helps to see visually if there is a difference among the groups (of course statistical testing would reveal if there is truly a significant difference between the groups or not). It would be ideal if every time we don't have to create a calculated field to do that.
... View more