ASSTOREDPROCEDURES.CODEPLEX.COM

101mdx.blogspot.com

MDX101: Calculating Median and Percentile

http://101mdx.blogspot.com/2014/08/calculating-median-and-percentile.html

My collection of how to use MDX in a SSAS 2012 / 2014 environment. Sunday, August 10, 2014. Calculating Median and Percentile. MEDIAN or 50th Percentile. The median or 50th percentile is the numerical value separating the higher half of a data sample, a population, or a probability distribution, from the lower half. Some examples:. Median / 50th percentile. MEMBER [Measures].[Median Sales Per Week]. Date][Calendar Weeks].[Calendar Week],[Measures].[Sales Amount]). Measures].[Median Sales Per Week]}.

codeplex.com

CodePlex - manowar

http://www.codeplex.com/site/users/view/manowar

Project Hosting for Open Source Software. Member Since June 3, 2006. Last Visit February 28, 2016. Power Pivot SQL Agent Job Monitor. To discover more about myself and my work visit my homepage: http:/ www.davidemauri.it. No activity in the last 60 days. Analysis Services Parent-Child Dimension Naturalizer. Analysis Services Stored Procedure Project. Azure Machine Learning Excel Add-In. Big Data Twitter Demo. DAX Editor for SQL Server. DotNetAge CMS for ASP.NET Mvc. Internals Viewer for SQL Server.

jpedroalmeida.wordpress.com

Road to BI | You can't manage what you can't measure | Página 2

https://jpedroalmeida.wordpress.com/page/2

You can't manage what you can't measure. Connecting SSRS Report to Bing Maps. Today i read an interesting article at mssqltips.com talking about drill through actions in order to connect and map your Report Data to external sites such as Bing or Google Maps. Here is the link : http:/ www.mssqltips.com/sqlservertip/2926/ssrs-data-specific-report-drill-through-to-bing-maps/? Utm source=dailynewsletter&utm medium=email&utm content=headline&utm campaign=20130410. List All SSAS Roles and Users Membership.

sqlblogspot.com

SQL Journey: August 2012

http://www.sqlblogspot.com/2012_08_01_archive.html

This blog was created as a way for me to share some of the challenges and ideas that I have experience. August 12, 2012. MDX Wildcard search in parameters dropdown - SSRS. Recently I got a request from my insurance client to filter the SSRS MDX report based on the Policy holder, one choice is to give them the complete list but as we have more than 5,000 policy holders(that is only commercial insurance), it is really impossible for them to choose even with alphabetical ordered list. Using Custom library .

electrovoid.wordpress.com

Calculating Quartiles in Analysis Services | ElectroVoid

https://electrovoid.wordpress.com/2011/06/24/ssas-quartile

A black hole for bits. Uninstalling Visio Breaks Windows XP Backup. Color-coded Rows in Excel) →. Calculating Quartiles in Analysis Services. June 24, 2011. In SQL Server Analysis Services 2008, there is a native Median function in MDX, but no native Quartile. The first option is to use the Excel QUARTILE() function. Many native Excel functions can be used directly from MDX via the EXCELMDX assembly that ships with Analysis Server. One immediate problem with this is that you must have a copy. Below is a ...

farouq-abukhamireh.blogspot.com

Business Intelligence Notebook: Display Cube Last Processed Date and Time

http://farouq-abukhamireh.blogspot.com/2011/02/cube-last-processed-date.html

Farouq Abukhamireh - Business Intelligence Architect. Monday, February 14, 2011. Display Cube Last Processed Date and Time. I came across a requirement where the user wanted to display the cube’s last processed date and time on an Excel Services PivotTable report. My approach to this was to create a calculated member and display it using an Excel Services PivotTable (or any other client tool). I resorted to creating. A Net assembly (C#) with a user-defined functions called. This function used the. I am a...

farouq-abukhamireh.blogspot.com

Business Intelligence Notebook: February 2011

http://farouq-abukhamireh.blogspot.com/2011_02_01_archive.html

Farouq Abukhamireh - Business Intelligence Architect. Monday, February 14, 2011. Display Cube Last Processed Date and Time. I came across a requirement where the user wanted to display the cube’s last processed date and time on an Excel Services PivotTable report. My approach to this was to create a calculated member and display it using an Excel Services PivotTable (or any other client tool). I resorted to creating. A Net assembly (C#) with a user-defined functions called. This function used the. I am a...

sqlservermsbiblog.blogspot.com

Gaurav Gupta - MS BI Blog: July 2015

http://sqlservermsbiblog.blogspot.com/2015_07_01_archive.html

Gaurav Gupta - MS BI Blog. Thursday, 30 July 2015. SSIS : Lookup Vs Merge Join. In many interviews you will be seeing interview asking what is difference between merge join and lookup component. Most of the people think Merge and lookup are same, well if that was the case than Microsoft would have not created two separate component. Lookup and Merge join are two different activities they perform in different way and are meant of different purposes. Input needs to be sorted. Need 2 input source. Right - I...

sqlservermsbiblog.blogspot.com

Gaurav Gupta - MS BI Blog: Uing Custom assembly in SSAS

http://sqlservermsbiblog.blogspot.com/2015/07/uing-custom-assembly-in-ssas.html

Gaurav Gupta - MS BI Blog. Wednesday, 15 July 2015. Uing Custom assembly in SSAS. Following is an example where we have used an assembly to create a custom drillthrough. Requirement is to have huge text column (BLOB) to be displayed when doing a drillthrough in SSAS using excel as tool. By default column which included into drillthrough needs to be present in cube. If we don’t have columns in cube we can not see then in drill through. We come up with a solution where we will not keep the required BLOB co...