BI Developer Network Community blogs

Who is online?  0 guests and 0 members
Home  »  Blogs  »  Blogs

Communifire Blogs

Blogs RSS Feed

Blogs: Most Recent postings

DevinKnight

Consuming News Through Social Media and Read It Later With Pocket

3/20/2013 by DevinKnight  -  Comments: 0  -  Views: [2739]

These days the fastest way, not always the most accurate, to get news is through social media. Technology, sports, politics, and breaking news will always be found first on social media outlets like Twitter. For example, I’m a huge fan of American Football or most known as the NFL. Every year the NFL teams draft players from college teams to play professionally. This is done through a big televised spectacle called the NFL Draft and is held across multiple days once a year generally in Apr...

Read More

DevinKnight

SSRS – Using Lookup Function for Multiple Column Join

3/20/2013 by DevinKnight  -  Comments: 5  -  Views: [11091]

When SQL Server 2008 R2 was released several new Reporting Services expressions were made available that would help join multiple datasets together. Those functions were the Lookup Function , LookupSet Function and the MultiLookup Function . My general recommendation for these function is not to use them when you have two dataset from the same data source. They’re really intended for connecting datasets together that are not directly related because otherwise I could just handle it in my s...

Read More

KathiKellenberger

Questions from My AlwaysOn Availabilty Group Presentation

3/19/2013 by KathiKellenberger  -  Comments: 0  -  Views: [980]

I gave a Training on the Ts Webinar today on AlwaysOn Availability Groups (AG) today. The recording should show up in a couple of days. My session was focused on showing how AG compares to SQL Server Failover Clustering and Database Mirroring as well as a quick tour of the features. One of the questions at the end of the presentation asked about licensing all the nodes. At the time, I could not recall if this is something that I had looked at since leaving Microsoft last year, a few months befor...

Read More

ChrisSchmidt

Creating a site collection in SharePoint 2013

3/12/2013 by ChrisSchmidt  -  Comments: 0  -  Views: [6614]

SharePoint 2010 was worlds apart from SharePoint 2007, and SharePoint 2013 continues that change with an updated interface, performance improvements, etc.. SharePoint 2013 looks very metro-ish, in line with Microsoft’s new Windows 8 operating system. I was recently creating a new SharePoint 2013 site collection, and thought I’d share it here. To create a new site collection, you’ll need access to the SharePoint Central Administration window. One of my favorite things about it i...

Read More

KathiKellenberger

Create a chart showing current and previous year

3/10/2013 by KathiKellenberger  -  Comments: 0  -  Views: [3544]

SQL Server Reporting Services (SSRS) has several features that you can use to create visualizations of your data like charts, gauges, KPIs, and maps. These features are great for creating dashboards. The chart feature can be used to show multiple data points or series on the same chart. For example, you might want to show this year’s sales compared to last year’s sales. This is how the report might look: Recently, I decided to create such a report and wondered how to write a query th...

Read More

jamesbrown2kjb

Why SharePoint isn't for Everyone

3/8/2013 by jamesbrown2kjb  -  Comments: 0  -  Views: [2501]

1. It's a Platform, Not a Product The biggest problem most businesses will have with SharePoint is that it isn't really a product, it's a platform. To make it work for your business, you'll generally need to customize it with the help of an army of programmers and IT experts. For most businesses, who just want a simple tool to help them share documents, organize projects, and replace email with something more organized, it's not a good fit. This is, in large part, because SharePoint tries to be ...

Read More

ChrisSchmidt

SSAS Parent Child Dimension Properties

3/6/2013 by ChrisSchmidt  -  Comments: 0  -  Views: [3970]

I’ve saved the best for last, so they say. Well, depending on how you look at it. Over the last week, I’ve blogged about all of the other sections in Analysis Services dimensions except for parent-child, so now it’s time to finish off our series. Parent-child dimensions in Analysis are equipped to handle the ragged and unbalanced hierarchies that the world gives us.You can get decent performance out of them, name your different levels, customize your calculations with unary ope...

Read More

DevinKnight

Getting Started with Microsoft Data Explorer

3/6/2013 by DevinKnight  -  Comments: 0  -  Views: [4666]

What is Data Explorer Data Explorer simplifies the data discovery phase for Excel users that are creating self-service Business Intelligence solutions. It does this by provided straightforward methods for connecting to data previously unheard of, without a developer, in Excel. It also provides a basic ETL tool for those involved in self-service BI projects all within Excel. What do I need Currently Data Explorer is only available as a preview and works with Excel 2010 SP1 or Excel 2013. You can ...

Read More

MarkGStacey

Persisting DAX queries

3/6/2013 by MarkGStacey  -  Comments: 0  -  Views: [2597]

This blog has moved to : http://markgstacey.net/2013/02/11/persisting-dax-queries/ In this post, I’m going to show you how to connect a tabular mode query to the cube it is sourced from – the question that I got asked by Marco Rus when I worked this out was : Why? Why would you do that? Well, there are a couple of reasons. If we think about SQL, we have the ability to persist a query that we have written, and then query it as if it was a table – our goal is to persist a DAX que...

Read More

ChrisSchmidt

Hierarchies in SSAS Multidimensional: What’s really happening up (or down) in there?

3/5/2013 by ChrisSchmidt  -  Comments: 0  -  Views: [1730]

A few days ago I got an interesting question. The question was “When you build an hierarchy in SSAS, what’s actually happening to it on disk?” As in, how does the file system actually place it in files so it can easily identify the hierarchy and keep performance up? Sure, dragging all of those attribute relationships around in the dimension GUI is “fun”, but what does it do, and what do you gain? To answer these questions, let’s look at the process from beginn...

Read More

ChrisSchmidt

SSAS Dimension Properties : Misc and Source

3/4/2013 by ChrisSchmidt  -  Comments: 0  -  Views: [1141]

Previously I’ve blogged about both Basic dimension properties ( here ) and Advanced dimension properties ( here ), so today I’d like to finish off this initial set by blogging about the misc and source sections of the properties of an attribute in a dimension. The source section, above everything else, is where you define your key for that attribute and the name and value properties, so it’s definitely one of, if not the, most used property sections. Source KeyColumns Specifies...

Read More

MitchellPearson

SQL Saturday 192 - Follow up Links

3/4/2013 by MitchellPearson  -  Comments: 0  -  Views: [690]

I had a great time at SQL PASS 192 in Tampa. I presented on Introduction to SSIS with a focus on building your first SSIS package. What’s better? SQL Server MVP Jorge Segarra aka SQLChicken attended the session. As a whole it went well, I felt like the session was interactive and I had some good questions. Listed below are some links I referred to in my session for anyone who wanted them. 1) S SIS: Suggested Best Practices and naming conventions http://consultingblogs.emc.com/jamiethomson/...

Read More

DustinRyan

Thanks For Attending My SQLSat192 Session!

3/4/2013 by DustinRyan  -  Comments: 0  -  Views: [1027]

Thanks to all who attended my session MDXplosion! Intro to MDX at SQL Saturday 192 in Tampa over the past weekend! It was a great event and I had a blast presenting, networking, and hanging out with some great friends. And a special thanks to all the sponsors, volunteers, and Pam Shaw for making this great event possible. If you'd like to download my slide deck and code examples from the presentation, you can get that here . If you have more questions about MDX and want to learn more, you can fi...

Read More

ChrisSchmidt

SSAS Dimension Properties : Advanced

3/2/2013 by ChrisSchmidt  -  Comments: 2  -  Views: [4119]

Yesterday I blogged about the properties of a dimension in the basic folder, and what each property means. Today I’m going to cover the advanced folder. In the advanced folder, there are 13 different properties, all of which do (in my opinion) some pretty cool stuff. Here’s screenshot of our properties window: AttributeHierarchyDisplayFolder This specifies what the folder is in the client tool that the attribute displays under. If you leave it blank it shows up directly under the dim...

Read More

ChrisSchmidt

SSAS Dimension Properties : Basic Properties

3/1/2013 by ChrisSchmidt  -  Comments: 0  -  Views: [1695]

If you’ve ever spent some time looking around in SSAS, you’ll notice there are a lot of properties. So what are all of these properties, and what do they do? I’ve usually found that when I’m initially setting up an SSAS database, at least 50% of my time is configuring properties appropriately. I’m going to start in the basic folder within the dimension at the attribute level, which includes the Description, FormatString, ID, Name, Type, and Usage properties. Below i...

Read More

DustinRyan

Gotchas With Referenced Dimensions

3/1/2013 by DustinRyan  -  Comments: 2  -  Views: [4066]

A referenced dimension relationship allows us to create a relationship between a measure group and a dimension that is indirectly related to the measure group using an intermediate dimension. This is great, because we can now create relationships between our facts and dimensions that may not be directly related. Unfortunately, there are a couple of gotchas that you may not be aware of, which I read about here and here . I'm just offering my take on these issues, so thanks to Alberto and Jesse fo...

Read More

DustinRyan

SQL Saturday Is Coming To Jacksonville, FL and I’m Speaking!

3/1/2013 by DustinRyan  -  Comments: 0  -  Views: [855]

On April 27th next month, SQL Saturday #215 will be here in beautiful, sunny Jacksonville, Florida and none other than yours truly will be speaking, bright and early at 8:30 in the morning! I'll be presenting MDXplosion! Intro to MDX . The MDX query language is a powerful tool for extracting data from your cube but can often seem confusing and overwhelming to the untrained eye. But have no fear! It's easier than you might think. In this session, I'm going to walk you through the basic MDX query ...

Read More

Anil

The power of SIMBA into the world of BI on top of BIG DATA.

2/27/2013 by Anil  -  Comments: 0  -  Views: [1227]

It been long time and I really miss this BIDN family Network ,after a long time gap I would love to post this blog regarding the power of SIMBA into the world of BI on top of BIG DATA . It’s really interesting and exciting to see these kinds of new technology and tools on the way. Well ,I am talking about the SIMBA MDx Provider developed by the simba Technologies . Yesterday, while I was researching regarding BIG DATA and reading some great blog post then I came to know about the SIMBA MDx...

Read More

CraigLove

SSIS Configurations: Connection String vs. Connection Properties

2/26/2013 by CraigLove  -  Comments: 0  -  Views: [524]

SQL Server Integration Services package configurations (parameters in SQL 2012) are a wonderful way to make your packages dynamic. The most obvious use for configurations is setting database connections so that your packages can move be deployed to different environments without needing to change the packages. I usually will pass the properties of the connection- ServerName, InitialCatalog, UserName, Password. Every so often I will get asked why I do not simply pass the entire connections string...

Read More

KathiKellenberger

March is WIT Month at Pragmatic Works!

2/26/2013 by KathiKellenberger  -  Comments: 0  -  Views: [981]

March is Women’s History month in the US, and Pragmatic Works is celebrating by featuring female speakers all month in our Training on the Ts webinars . We are coordinating with the Women in Technology (WIT) PASS virtual chapter to bring you some of the best speakers in the SQL Server Community. So, be sure to check out our Training on the Ts lineup for March! At least here in the US, men far outnumber women in technology jobs, and SQL Server careers are no exception. There are many possib...

Read More

KathiKellenberger

What is the AlwaysOn Listener?

2/22/2013 by KathiKellenberger  -  Comments: 0  -  Views: [2867]

With AlwaysOn Availability Groups (AG), you can fail a group of databases over to another node. You may be wondering how to configure your application so that it always connects to the primary replica of the database – the replica that allows writes as well as reads. The good news is that there is no special connection string or application configuration that you must implement for redirection with AG. When setting up AG, you configure a listener which is a virtual name that always points ...

Read More

RCharCox

Using Messages to Navigate in an MVVM Structure

2/21/2013 by RCharCox  -  Comments: 0  -  Views: [2534]

As a C# Noob, I've pretty much thrown myself in head first with my latest project. However, to do it right, I wanted to use the MVVM structure that's all the rage these days (and for good reason). I won't go into detail about what MVVM is, or why it can help your code. There's a lot out there on that. This post is all about navigation. Historically, a programmer would tie event handlers to their buttons and handle the action tied to it in the .xaml.cs file attached. That method doesn't work in M...

Read More

KathiKellenberger

Slides and code from Enterprise Edition Session

2/21/2013 by KathiKellenberger  -  Comments: 0  -  Views: [793]

If you attended my session February 19, 2013, or watched the recording, here are the files from that presentation. http://www.bidn.com/Assets/Uploaded-CMS-Files/EE-c5260012-7658-4fce-b85d-cc38a883e4bd.zip

Read More

stellarobinsons

Increase Web Traffic By Not Being So Pushy

2/20/2013 by stellarobinsons  -  Comments: 0  -  Views: [1528]

Everyone's in a rush to get more traffic, better traffic, and any kind of traffic that converts. The problem is that - in the rush to get traffic - a lot of companies are failing to recognize the value of pushing people away. That's right, there's a value in pushing people away from your services. Why would you want to do this? For starters, there are many prospects who aren't really your ideal customers. You don't these people, and they would likely make for poor customers. Secondly, pushing pe...

Read More

ChrisSchmidt

SSAS Date Utility Dimensions: Pre-Aggregating Over Time

2/16/2013 by ChrisSchmidt  -  Comments: 0  -  Views: [3563]

A pretty common question in business intelligence (and within SSAS cubes specifically) is numbers at points in time. How does my performance from this month compare to last month? How about this month last year? What is the actual difference? Luckily, there is a great way that we can easily build this out and give this functionality to business users, without having to create huge, complex MDX scripts. It involves creating a date utility dimensions, bringing it into the SSAS database, and then w...

Read More