Login or Sign Up to become a member!
LessThanDot Site Logo

LessThanDot

A Technical Community for IT Professionals

Less Than Dot is a community of passionate IT professionals and enthusiasts dedicated to sharing technical knowledge, experience, and assistance. Inside you will find reference materials, interesting technical discussions, and expert tips and commentary. Once you register for an account you will have immediate access to the forums and all past articles and commentaries.

Browsing "ssas"

0

Overview of Published Articles – 2014Q4

Here is an overview of the articles I published in the last quarter of 2014. INTENSE SCHOOL MCSE Prep: Overview of T-SQL Windowing Functions Part 1 MCSE Prep: Overview of T-SQL Windowing Functions Part 2 The third and final part of this series will probably be published this month, so keep an eye on the site […]

Read More...
0

Formatting Durations in SSAS: Caveat

I recently published an article on MSSQLTips.com titled Format Durations in SQL Server Analysis Services. For those who haven’t read it I’ll summarize it quickly: it explains how to create an MDX formula that formats durations into an [hh]:mm:ss format, where [hh] can go over 24 hours. For more detailed information, please check out the […]

Read More...
1

Nominated for Author of the Year

I have the great pleasure to announce that I have been nominated for the “Author of the Year” award at the MSSQLTips website. This means however I have to persuade people to vote for me, hence this blog post 😉 You can vote for me at the following URL: http://www.mssqltips.com/MSSQLTipsAuthorVoting.asp Note that you can cast a […]

Read More...
1

Overview of Published Articles – 2014Q3

Here is an overview of the articles I published in the third quarter of 2014. INTENSE SCHOOL MCSE Prep (SQL) – Using Parameters in Reporting Services Reports (Part 2) Book Review: SQL Server 2012 Integration Services Design Patterns MSSQLTIPS Adding Custom Reports to SQL Server Management Studio More Text Analysis with the SSIS Term Lookup […]

Read More...
18

Building a SharePoint 2013 BI Demo Environment Part 10 – Creating a BI site

In the final part of this series, we will create a BI subsite in our site collection. You can use this site as the starting point for your SharePoint BI demos. Browse to the PowerPivot site we created earlier in part 7 and go to Site Contents. Click on…

Read More...
2

Building a SharePoint 2013 BI Demo Environment Part 9 – Installing Reporting Services

Finally we are getting to the really sweet stuff: Power View. But first we have to install Reporting Services in SharePoint integrated mode. The steps we are going to follow are described in the following MSDN document: Install Reporting Services ShareP…

Read More...
3

Building a SharePoint 2013 BI Demo Environment Part 8 – Verifying PowerPivot Integration

After configuring SharePoint in the part 7, we will now verify if the configuration was successful and if everything works correctly. The verification process is described in the following MSDN article: Verify a PowerPivot for SharePoint Installation. F…

Read More...
0

Building a SharePoint 2013 BI Demo Environment Part 7 – Configuring SharePoint

In this blog post we go over one of the most important parts of the series: running the PowerPivot Configuration Wizard in order to configure our SharePoint installation. If you followed the previous walkthroughs, you can find the wizard in the start me…

Read More...
3

Building a SharePoint 2013 BI Demo Environment Part 6 – Installing PowerPivot for SharePoint

In this part of the series we will install the Analysis Service instance that will host the PowerPivot workbooks used in SharePoint, also known as “the PowerPivot instance”.
The first step is to create a service account for this instance. I named it SP…

Read More...
0

SQL Server 2012 Business Intelligence Whitepaper and Data Tools released

If you are into Business Intelligence, you are in luck, this week Microsoft has released a SQL Server 2012 Business Intelligence whitepaper as well as SQL Server Data Tools – Business Intelligence for Visual Studio 2012 (SSDT BI) templates.

The white…

Read More...
Next Page »