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

Dean.Brown

BI xPress Package Deployment Wizard Feature Overview 101

3/24/2013 by Dean.Brown  -  Comments: 0  -  Views: [1219]

BI xPress Package Deployment Wizard Overview BI xPress is one of our many software products here at Pragmatic Works. One of the features of BI xPress is the Package Deployment Wizard. My goal is to introduce the feature, why it’s important and the benefits that can be gained by using it. So inside of BIDS right now, for 2005, and 2008 when you deploy packages, you’re kind of limited in what you can do with that, right? You know you have to do it either all the packages in your projec...

Read More

Dean.Brown

BI xPress Notification Framework Overview 101

3/24/2013 by Dean.Brown  -  Comments: 0  -  Views: [853]

BI xPress Notification Framework Overview BI xPress is one of our many software products here at Pragmatic Works. One of the features of BIxPress is the Notification Framework. My goal is to introduce the feature, why it’s important and the benefits that can be gained by using it. So lets say that you have a developer who deployed a package and something went wrong while it was executing on an agent job. So once the agent job is over you have to go and look through the agent job history an...

Read More

Dean.Brown

BI xPress Variable Dependency Scanner Feature Overview 101

3/24/2013 by Dean.Brown  -  Comments: 0  -  Views: [669]

BI xPress Variable Dependency Scanner Overview BI xPress is one of our many software products here at Pragmatic Works. One of the features of BIxPress is the Variable Dependency Scanner. My goal is to introduce the feature, why it’s important and the benefits that can be gained by using it. Say that we’re using a template package from somebody else that’s on our development team. Somebody else created this template. We also noticed there are a lot of variables and we don’...

Read More

Dean.Brown

BI xPress Quick Config Editor Feature Overview 101

3/24/2013 by Dean.Brown  -  Comments: 0  -  Views: [576]

BI xPress Quick Config Editor Overview BI xPress is one of our many software products here at Pragmatic Works. One of the features of BIxPress is the Quick Config Editor. My goal is to introduce the feature, why it’s important and the benefits that can be gained by using it. Let’s say you have a package and are using config files.So what if we needed to make changes in those configuration files? Say that, you’ve gone through testing this package and everything is fine. Maybe yo...

Read More

Dean.Brown

BI xPress Monitoring Console Feature Overview 101

3/24/2013 by Dean.Brown  -  Comments: 0  -  Views: [626]

BI xPress Monitoring Console Feature Overview 101 BI xPress is one of our many software products here at Pragmatic Works. One of the features of BIxPress is the Monitoring Console, which is one of our most popular features. My goal is to introduce the feature, why it’s important and the benefits that can be gained by using it. The SSIS Monitoring Console will display data that is recorded by the auditing framework. There are numerous reports that will display a variety of data, from real t...

Read More

Dean.Brown

BI xPress Package Builder Wizard Feature Overview 101

3/24/2013 by Dean.Brown  -  Comments: 0  -  Views: [641]

BI xPress Package Builder Wizard Overview BI xPress is one of our many software products here at Pragmatic Works. One of the features of BIxPress is the Package Builder. My goal is to introduce the feature, why it’s important and the benefits that can be gained by using it. BIxPress can help you with rapid package development. You may have found yourself in situations especially if your loading to a data warehouse where you happen to create one package and then spend a lot of time on that ...

Read More

Dean.Brown

BI xPress Auditing Framework Feature Overview 101

3/24/2013 by Dean.Brown  -  Comments: 0  -  Views: [874]

BI xPress Auditing Framework Feature Overview 101 BI xPress is one of our many software products here at Pragmatic Works. One of the features of BIxPress is the Auditing Framework, which is one of our most popular features. My goal is to introduce the feature, why it’s important and the benefits that can be gained by using it. For a lot of developers when they have errors or warnings inside of a package they spend a lot of time trying to going through the agent history to try to decipher w...

Read More

Dean.Brown

Service is King!

3/24/2013 by Dean.Brown  -  Comments: 0  -  Views: [448]

Service is King! As I was reading the book, “The Simple Truths of Service”, by Ken Blanchard and Barbara Glanz I came across a lot of good reinforces for the service industry. Sure, some of the cliché and might not be mind blowing, however I think it’s always good to refresh and reinforce important ideas, especially to people who are working directly with clients. The book itself is very small, full of pictures and simply hits the main points of providing the best servic...

Read More

Dean.Brown

No Complaining Rule

3/24/2013 by Dean.Brown  -  Comments: 0  -  Views: [514]

Lately I’ve been reading a lot of Jon Gordon’s book and I thought I’d blog about the most recent one I read called, “The No Complaining Rule”, which in my view is one of his best books. The book paints a picture of a struggling company, whose share price is sinking, company morale is lackluster. This is a common theme throughout companies, many are struggling and the morale of employees is low. How does one turn itself around against the negativity that embedded fro...

Read More

Dean.Brown

Chief Energy Officer- Energy Bus

3/24/2013 by Dean.Brown  -  Comments: 0  -  Views: [1017]

Chief Energy Officer What does CEO stand for? Most of you would probably say the Chief Executive Officer, while a few of you might be thinking Centrum Edukacji Obywatelskiej, which is Polish for Center for Civic Education). I just recently finished reading a book called, “The Energy Bus” by Jon Gordon and he mentions how a leader must be a CEO, a Chief Energy Officer. What does he mean by that exactly? The main premise of the book is in order to run a successful organization you must...

Read More

Dean.Brown

Soup For You- Food for thought

3/24/2013 by Dean.Brown  -  Comments: 0  -  Views: [431]

Soup For You When anybody brings up the topic of soup, the first thought to my mind is the Seinfeld episode where the chef tells them, “No Soup for you”. But after reading the book entitled, “Soup” by the infamous Jon Gordon, the Seinfeld quote will be second to mind. The main concept the book illustrates is the, “Stirring of the pot phenomenon”, which states that no matter how carefully different chefs follow the same recipe, the final product always varies a...

Read More

MMilligan

Generational Changes to Enterprise Data Warehouse Architecture

3/24/2013 by MMilligan  -  Comments: 0  -  Views: [1666]

I had been on the job only three weeks before I began work on my secret plans. It started out as just a simple BUS matrix; but, very quickly became a drill down BUS matrix of epic proportions. I knew from the onset if my schemas were ever to hit a database I would need to be clever, patient, and a maybe even a little cunning. I would have to keep my cards close to my chest, revealing my intentions only in bits and easily digestible bytes, sometimes as if they were not even of my own creation. Pr...

Read More

DevinKnight

Consuming News Through Social Media and Read It Later With Pocket

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

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: [15148]

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: [1121]

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: [7739]

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: [4489]

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: [2854]

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: [5009]

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: [5964]

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: [2868]

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: [2154]

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: [1297]

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: [755]

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: [1130]

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