Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
This article lists all articles that participated in the TechNet Guru Contributions SQL Server Reporting Services, Power View, & SQL Server Integration Services category.
2016
September 2016
2015
July 2015
- SQL Server Analysis Service Performance Improvement
- SQL Server: Best way to add additional parent child attribute
2014
October 2014
- Random SSRS Musings 1 : Rowset Concatenation Using Native SSRS Expressions by Visakh16 - Gold medal winner
- Dates in Excel files rendered from reports are displayed as plain numbers by Jan D'Hondt - Silver Medal
- Integrating Power View with SharePoint Server 2010/2013 - Multidimensional Mode by Anushka Weerakkodyge - Bronze medal winner
- Make a dynamic selection from SharePoint list data with the SSIS 2012 OData Source by Jan D'Hondt
- Error occurred while the attribute of the dimension from the database was being processed–snowflake dimension by Jan D'Hondt
September 2014
- Finding SSIS Packages having References to a Table or Column by Visakh16 - **Gold **medal winner
- SSIS: Export Multiple File With Fixed Size by Ch. Rajen Singh **- Silver **Medal
- Power BI Community Council by **Ed Price - MSFT - Bronze **medal winner
- How to show Measure values as either 0 or NULL in Cube? by Anil Maharjan
- Adding Custom Formats Within Textbox Data by visakh16
August 2014
- Import SSIS2012 Project From Catalog Using T-SQL Script by Visakh16 - **Gold **medal winner
- SSIS 2012 new REPLACENULL function by Jan D'Hondt - Silver Medal
July 2014
- Getting Started with Forecasting and Hindcasting in Power View by Firdous S -MSFT - Gold medal winner
June 2014
- Using Power Query to tell your story form your Facebook Data by Anil Maharjan - Gold medal winner
- SSRS Expressions: Part 1 - Program Flow by - Silver Medal
- How to Schedule and Automate backups of all the SSAS catalogs within the Server Instance by Anil Maharjan - BronzeMedal
May 2014
- SSIS - Event Handling with "OnError" or "OnTaskFailed" by Durval Ramos - Gold medal winner
- Expansion of Time dimension in Analysis Service by S Kamath - **Silver **Medal
- SSAS – Ignore unrelated dimension or not by Sherry Li - BronzeMedal
April 2014
- Creating friendly week names in Power Pivot and SSAS Tabular models with DAX by Michael Amadi - Gold medal winner
- Power Pivot DAX: SUMX - Application on Price and Quantity Effect Analysis by TC0098
- Hide/Unhide a Measure irrespective of 'IgnoreUnrelatedDimensions' Property of its Measure Group by S Kamath
March 2014
- A Practical Example of How to Apply Power Query Data Transformations on Structured and Unstructured Datasets by Michael Amadi - Gold medal winner
February 2014
- Geocoding by HimanshuSharma - Gold medal winner
- The Devil is in the Details by Tim Pacl - Silver medal winner
January 2014
- Consume Web-Service via a SSIS Script Component by AB82 - Bronze medal winner
- Power Pivot: Dynamic Filtering Using Slicers Post Convert to Formulas by AB82 - Silver medal winner
- Power Pivot: Casting DateTime to Date in SQL Server Source Query by Paras Doshi
- How to generate XML files in SSIS for each row of a SQL table without any custom code (No script task) by Firdous S- Gold medal winner
- How to generate incrementing numbers in SSIS using script component by Sqlsaga
- Reporting Services: Dynamic zoom for maps in Reporting Services 2008 R2 by AndrewBorgCardona
- SSRS: Working with Tablixes by Tim Pacl
2013
December 2013
- A practical example of how to handle simple many to many relationships in Power Pivot/SSAS Tabular models by Michael Amadi - Silver medal winner
- Execute SSIS 2012 package with parameters via .Net by SSISJoost
- Functional Reports: Making a Report Into a Management Tool by Tim Pacl - Gold medal winner
- Populate Excel table with custom MDX query & PivotTable filters by Christian Wade
- SSAS time dimension with semi-additive measures; dynamic set; calculated members by Minnie Shi
- SSRS - Dependent Parameter and Wild Search in Parameter by Rishab Sachdeva
- Using parameters and variables in a Script Task by SSISJoost
- Using parameters and variables in a Script Component by SSISJoost
- Using a Date Picker for an Analysis Data Query Parameter by Tim Pacl - Bronze medal winner
November 2013
- Calculating the % difference between the same measure evaluated in two user selected contexts by Michael Amadi - Bronze medal winner
- How to add JPEG and PNG report export when SSRS 2012 is integrated with SP 2013 by johnsom - Gold medal winner
- MDX CurrentMember and DAX HASONEVALUE by Christian Wade
- SSRS: Chaining Parameters by Tim Pacl
- SSRS: Converting Between Tablix Controls (Matrix, Table List) by Tim Pacl - Silver medal winner
October 2013
- DAX ISCROSSFILTERED function performance vs. DAX HASONEVALUE function by Christian Wade
- Exists v.s Existing and Auto Exist in MDX by MNisharMSDN - Silver medal winner
- SSRS - How to calculate total of dynamic columns by SathyanarrayananS
- SSRS - Sorting by SathyanarrayananS - Bronze medal winner
- Using a View to Mask Multi-Server SSIS Package Configurations by Jason Brugger - Gold medal winner
September 2013
SQL Server Analysis Services
- SSAS: Custom MDX Query for Excel Filters by ShankarGS - Bronze medal winner
- PowerPivot: Query Power Pivot DMV's with VBA by Olaf Helper - Gold medal winner
- Profile MDX & SQL queries from SSRS by MnisharMSDN - Silver medal winner
SQL Server Reporting Services, Power View, & SQL Server Integration Services
- SSRS (Matrix) - How to Repeat Headers on Each Page and Keep Headers Fixed while Scrolling by SathyanarrayananS - Bronze medal winner
- SSRS - RDL Compare by SathyanarrayananS - Silver medal winner
- SSIS - Import Excel to table - Cannot convert between unicode and non-unicode string data types by SathyanarrayananS
- SSRS - Multi-valued Parameter as Stored procedure Input by SathyanarrayananS - Gold medal winner
- SSIS - Lineage ID SSIS by Yogish Bhat
August 2013
SQL Server Reporting Services, Power View, & SQL Server Integration Services
- SSRS: Multiple Ways to Split a String into Multiple Lines** **by SathyanarrayananS *** **- **Bronze **medal winner
- SSIS - Move Folder from one Drive to Another Drive Using File System Task by** SathyanarrayananS ***
- SSIS - How to Add Missing Control Flow Items / Data Flow Items to the SSIS Toolbox by** SathyanarrayananS ***
- SSIS - Flat File Source - Datetime Column Format - Issue & Solution by Rajkumar5055 - Gold medal winner
- SSRS - How to repeat headers for each group by SathyanarrayananS
- SSRS: How to Group Same Row Data with One Column Having Varying Data by SathyanarrayananS
- SSRS - How to set Column Visibility property for many columns based on Parameter value by SathyanarrayananS - Silver medal winner
- SSRS - How to display multiple columns (header and value) horizontally stacked in one row cell by SathyanarrayananS
- SSRS: How to Repeat Headers on Each Page by SathyanarrayananS
July 2013
SQL Server Analysis Services
- Custom Calculations for Invoice & Returns using PowerPivot DAX formula** **by Paras Doshi - Bronze medal winner
- Currency Conversion in SSAS 2012 (Multidimensional & Tabular) by Christian Wade - Silver medal winner
- SSAS Tabular Models: The Good, the Bad, the Ugly and the Beautiful by Paul Turley
- We’ve Got The Power: “Power BI”, New Microsoft BI Suite Announced by Paul Turley - Gold medal winner
SQL Server Reporting Services, Power View, & SQL Server Integration Services
- How to Transfer Records from SQL Server to Postgres** **by Shanky_621 - Silver medal winner
- SSRS - Multi Font Color / Multi Font Size within Single Field / Textbox by SathyanarrayananS - Gold medal winner
June 2013
SQL Server Analysis Services
- Aggregations in SSAS By Yogish Bhat
- Gold medal winner - MOD Function in MDX By Yogish Bhat - Silver medal winner
SQL Server Reporting Services/Power View
- Adding Links in SSRS Reports by Tim Pacl - Silver medal winner
- Concatenating Data Column Values Into a Single String by Tim Pacl - **Bronze **medal winner
- Counting Occurrences in a Concatenated String by Tim Pacl
- Preset Date Parameters by Tim Pacl
- Setting Subreport Visibility From User Input by Tim Pacl
- Sorting Elements of a Concatenated String by Tim Pacl - Gold medal winner
See Also
- [[TechNet Guru Contributions]]
- [[SQL Server 2012]]
- SQL Server Integration Services Portal
- SQL Server Reporting Services Portal
- List of Award Winning TechNet Guru Articles
- TechNet Guru - All Gold Winner Contributions
- TechNet Guru - All Silver Winner Contributions
- TechNet Guru - All Bronze Winner Contributions