BI Developer Network Community blogs

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

Communifire Blogs

Blogs RSS Feed

Blogs: Most Recent postings

DevinKnight

Getting Started with the Power BI Dashboards Public Preview

7 hours ago by DevinKnight  -  Comments: 0  -  Views: [115]

If you’re currently an Office 365 customer that is using Power BI sites then you probably found an early Christmas present this morning when you logged into your Power BI tenant. Today Microsoft announced the Public Preview of Power BI Dashboards. If you watched this PASS Summit Keynote (fast forward to the last 10 minutes) then you got an early glimpse of what the new tool will look like. If you want to start using this preview today then here’s what you need: Must be an Office 365 ...

Read More

user206840

FIFA bill in Fifa 15 Coins

20 hours ago by user206840  -  Comments: 0  -  Views: [42]

One affair that you will apprehend while arena this bold of football is that there is no simple way to get authority of such FIFA bill in Fifa 15 Coins the absolute bold but you can consistently access these bill of FIFA bold from abounding online shops that specialize in affairs such coins.If you feel that, your team's abeyant is way too low and it is not utilizing its backbone to the best again it could alone beggarly that some players abridgement the accomplishment or are demotivated. You can...

Read More

user206840

Computers from Fifa 15 Ultimate Team Coins

2 days ago by user206840  -  Comments: 0  -  Views: [97]

Whereas a anti-virus applications ability be endlessly safe attention your because of viral not to acknowledgment perilous not to acknowledgment malware approaches, a simple anthology abutment applications that may be are operated with some billow carriageable computers from Fifa 15 Ultimate Team Coins the accumulated entity's home appointment could be putting in not to acknowledgment safe attention this abundant commodity with the computer acceptable for you which agency in your absurd blow tha...

Read More

user206840

corp appear to be Cheap Fifa 15 Coins

4 days ago by user206840  -  Comments: 0  -  Views: [176]

Perfect these canicule doctors utilizing the annoy graham red blight ambition calm with corp appear to be Cheap Fifa 15 Coins active to breed a acceptable second-generation cervical blight vaccine acquired during able tobacco factories so as to could cause it to be evidently priced that will abounding even admitting females beyond the world. A acceptable vaccine for this archetypal could be a lot of advantageous during even admitting females during out of the way appearance aural the world, Indi...

Read More

user206840

fun with Fifa 15 Coins

8 days ago by user206840  -  Comments: 0  -  Views: [232]

Hence the next break you in fact affix them up on your laptop or computer action additional accept fun with Fifa 15 Coins multiplayer activities internet! You can acquisition a ample anticipation you may possibly acquisition themselves architecture some abundant assembly calm with the exact affected additional pastimes, in a lot of cases for all his life!They already accept an break abounding appointed appear yield up, and that aswell borderline day ability be simple advancing up. You can get ab...

Read More

DevinKnight

Preparing a Technical Session Part 1: Picking a Topic

17 days ago by DevinKnight  -  Comments: 0  -  Views: [507]

So you’ve decided or perhaps were told to do a technical presentation. If this is something that’s new for you then you may be going through a variety of emotions. You may start excited in anticipation of the event but quickly that changes to anxiety when you realize all the work that’s ahead of you. Delivering a presentation regardless of the subject matter can be a challenge. Even if you’re a seasoned speaker there’s several steps that lead to you completing a suc...

Read More

Anil

How to Install Vertica in a single node.

25 days ago by Anil  -  Comments: 0  -  Views: [439]

Install Vertica in a single node. This article is mainly related to: Setup of Vertica in a single node. Vertica Console Management Tableau DBeaver During my free time, I want to try to install Vertica and want to know what it is all about. what are the things we should know while installing Vertica and what will be the issues, difficulties, requirements and process do we need to follow in order to setup Vertica and play around it. The HP Vertica Analytic Database is based on a massively parallel...

Read More

DevinKnight

PASS Summit 2014 in Review

11/11/2014 by DevinKnight  -  Comments: 0  -  Views: [469]

I’m finally completely recovered from a great week in Seattle last week for PASS Summit. Now that it’s back to the grind of regular work I thought I’d put together some thoughts and tell you about my experiences from the week. You may have read others blogs about their experiences during the conference. I always love how everyone may do very different things while at this conference but still have a great time! My week started early as I arrived in Seattle on Saturday to prepar...

Read More

DevinKnight

Creating a Reporting Services Subscription

10/13/2014 by DevinKnight  -  Comments: 0  -  Views: [1047]

Subscriptions are a great feature in Reporting Services that will run a report unattended and deliver it to users either by email or Windows File Share. Subscriptions can also be scheduled so if your end users need a report monthly you can automate the delivery process. The steps given in this article will show you how to configure subscriptions using the Windows File Share delivery method. Before you start to configure your first subscription make sure to have the following taken care of first:...

Read More

DevinKnight

Optimizing Power BI Q&A with Synonyms and Phrasing using Cloud Modeling

10/1/2014 by DevinKnight  -  Comments: 0  -  Views: [11553]

If you’ve have used or even just seen a demo of Power BI Q&A you’ve likely seen there’s great potential in the feature for even low-tech user. I usually say, “If the user knows how to use a search engine then they can interact with Q&A.” You can read the basics of how Power BI Q&A works from my previous post here . While having this capability is great it can take some fine tuning to perfect for users interacting with it. Power BI provides you with the a...

Read More

hardikabhavsar

Custom Auditing and Error Handling in SSIS

9/10/2014 by hardikabhavsar  -  Comments: 0  -  Views: [6479]

Errors can occur at any stage when you extract data from source and load it into destination. You must include error handling method for your package to test and troubleshoot. There are several ways to handle it at different levels during your process. Either you can use default features provided by SSIS or you can develop your own method to handle the error. Ex: at a control flow level, if an error occurs, you can add a failure constraint and redirects the workflow to an alternate task. In data...

Read More

hardikabhavsar

SQL Server Integration Services(SSIS) Performance Tuning

9/10/2014 by hardikabhavsar  -  Comments: 0  -  Views: [17057]

Blog: https://etlbiconcepts.blogspot.com When creating an efficient and robust solution for Extract, Transform and Load Process, Lot of things do matter especially when you are working with huge size of databases. Challenge is not only to meet functional requirements Also to look at the performance requirements. Here, I would like to cover most of the part on extracting and loading process, I will not discuss (Buffer usage, Execution tree, Parallelism etc.) You will find those details here: http...

Read More

DevinKnight

Analysis Services Partitions

9/5/2014 by DevinKnight  -  Comments: 1  -  Views: [1745]

Partitions are a great feature in Analysis Services that allow you to split measure groups in to separate physical files. All measure groups by default have one partition but by splitting that partition you will gain improved query and processing performance. Partitions can be split in any way you see fit. Many people choose to separate measure group data by date. This makes sense because just about every fact table is going to have a date dimension associated with it. It also makes for a clear ...

Read More

DevinKnight

Analysis Services Dynamic Security

9/3/2014 by DevinKnight  -  Comments: 0  -  Views: [1680]

Imagine you have a requirement to capture the user accounts that log into your cube and based on their username they will only be permitted to see specific data. This can be accomplished by creating dynamic or table based security in Analysis Services which is much less difficult to setup than it sounds like. In this article I will walk you through the setup needed on the relational database side as well as Analysis Services side to get this working in your environment. You will start by identif...

Read More

MitchellPearson

SSIS Performance Tuning SSIS - Q&A

8/22/2014 by MitchellPearson  -  Comments: 0  -  Views: [822]

Thank you everyone for attending my webinar on SSIS Performance Tuning, if you missed that presentation you can watch it here: http://pragmaticworks.com/LearningCenter/FreeTrainingWebinars/PastWebinars.aspx?ResourceId=683 Below are some of the questions that I received from the Webinar: Q: Can you give some performance tips in using script tasks too? A: Yea, don’t use them! Script tasks can be really bad for performance and many times I have been able to replace someone else’s code w...

Read More

DevinKnight

MDX Time Calculations Built to Scale

8/14/2014 by DevinKnight  -  Comments: 2  -  Views: [1927]

When creating time calculations in Analysis Services you may take several approaches. For people that have just begin learning SSAS they likely have spent several days writing calculations that return things like year to date, rolling twelve month, and period over period for every measure they have. For the more adventurous developer they have tried using the Business Intelligence wizard which automates the process of writing time calculations on selected measures. It creates an attribute in the...

Read More

DevinKnight

Writing Parametrized MDX for Reporting Services

8/4/2014 by DevinKnight  -  Comments: 0  -  Views: [1233]

Writing MDX inside of Reporting Services has been the nemesis for many report writers for far too long. If all you need is the Query Designer to create a drag and drop datasets then it’s a piece of cake, but have you ever wondered what’s going on with all the MDX that the Query Designer creates. Or how about how do the parameters work that it creates inside MDX. I’ve heard many report writers that use Analysis Services as a data source (including myself) say it is too difficult...

Read More

DustinRyan

How to Pass Multiple Values from an SSAS Report Drill Through Action to an SSRS Multi-Value Parameter

8/1/2014 by DustinRyan  -  Comments: 0  -  Views: [6993]

These past couple weeks I faced a client requirement to create an SSRS Report Action in an SSAS cube. This requirement dictated that a user should be able to browse a cube in an Excel pivot table and be able to drill through to an SSRS report (which used SQL Server as the data source) and view data at a monthly level. The twist was that if the user drilled from a year or quarter level, the appropriate months would be selected by default. I thought the solution I came up with was useful so here y...

Read More

Daniel

SQL Saturday 302 Albany NY July 26th. Crossroads of the Northeast, just 3 hours from everywhere.

7/24/2014 by Daniel  -  Comments: 0  -  Views: [1170]

I am speaking on SSIS Optimization. Just a few more days to register and make your plans. I hope to see you there. More info here: http://www.sqlsaturday.com/302/eventhome.aspx

Read More

DustinRyan

Script To Populate AdventureWorksDW DimDate

7/17/2014 by DustinRyan  -  Comments: 6  -  Views: [1296]

I do quite a bit of training for Pragmatic Works so I find myself working a lot with the AdventureWorksDW data warehouse database. AdventureWorksDW is a great test database if you're wanting to demonstrate a concept or test a theory, but one of the things that has always bugged me is that the date dimension (dbo.DimDate) has holes in the data! Having a complete date dimension is important when working with SSAS. Well yesterday was the final straw, so I put together the following script that will...

Read More

DevinKnight

Understanding Analysis Services Relationships using Dimension Usage

7/15/2014 by DevinKnight  -  Comments: 0  -  Views: [4770]

As a part of designing an Analysis Services cube you must define how each dimension is related to each measure group in your cube through the Dimension Usage tab. The Dimension Usage tab is found when editing the cube in the cube designer. The screenshot below shows dimensions on rows and measure groups on columns. The points at which they intersect define how they are related. These relationships are automatically defined when the two objects (measure groups and dimensions) are added to the cub...

Read More

DustinRyan

How To Display 0’s Instead of NULL in your SSAS Cube & MDX Query Results

7/15/2014 by DustinRyan  -  Comments: 0  -  Views: [3410]

I've done a decent amount of SSAS and MDX query development over my career and one of the requirements that continually pops up is to display zeros instead of NULL when browsing the cube. Take the following query as an example: Select {[ Date ].[Calendar Year ].Children} on 0, NON EMPTY {[Geography].[ State -Province].members} on 1 From [Adventure Works DW] Where [Measures].[Reseller Sales Amount] And here are the results: There are a couple ways display 0's instead of NULL. The first way is to ...

Read More

DevinKnight

Using PowerShell to Build your Azure VM Environment

6/30/2014 by DevinKnight  -  Comments: 0  -  Views: [3364]

In a previous post I wrote about Using a Hyper-V VHD in an Azure VM . Today I’d like to show you what my next steps were. My goal with using Azure is to create an lab environment for student that fits the following needs: Easy to create new virtual environments Easy to power down virtual environments Easy to power up virtual environments Easy to delete all virtual environments The point of this post is to guide you through how to easily create virtual machines for multiple students or empl...

Read More

DevinKnight

Using a Hyper-V VHD in an Azure VM

6/19/2014 by DevinKnight  -  Comments: 0  -  Views: [3730]

I’m in the process of moving some my lab environments that I use for teaching SQL Server classes to Azure. I’m pretty new to the Azure infrastructure world but I thought I could share some of my lessons learned in doing this. My first post will walk you through moving an existing Hyper-V virtual machine image to be hosted in Azure. Limitations Before you start this process here’s a couple things to be aware of: Virtual Machines in Azure must be .vhd files. They cannot be .vhdx ...

Read More

DevinKnight

Reducing the Disk Size of a Hyper-V Virtual Machine

6/19/2014 by DevinKnight  -  Comments: 0  -  Views: [4137]

Have you ever created a Hyper-V virtual machine and later needed to change the size of the disk on the VM? When you initially create a virtual machine you provide a size for the virtual hard disk (as shown below). It’s pretty straight forward to expand the size of this virtual disk but if you need to shrink the disk size there’s a few extra steps to make the change. Here’s the simple steps for expanding a virtual disk: To expand a disk you can go into the Settings of your virtu...

Read More

Top Blog Contributors