The Question I misread a question about a table that contains "Parent -> Child" data in the SSRS forums here on BIDN recently and I decided to attempt answering it. I thought it was a question that many of us have no doubt run across before - "how do you show a hierarchy for data when you have a table with "parent" and "child" information listed in the row values? So I thought I'd give it a shot and share my results. Let's get into it Like my math professor always said, "first, make sure you ...
Read More
My team and I recently had an issue with our SSAS instance in which users were receiving the following message from Excel: Data Could not be retrieved from the external data source. Error message returned by the external data source: Server: The operation has been cancelled due to memory pressure. Ok Another user reporting a different error from Excel when trying to create a new connection to the Analysis Services database: An error has occurred in the transport layer. Errors in the OLE DB provi...
This is just a quick post to share a lesson learned while I was on an engagement where the client's reporting environment was using SAP Business Objects (BO)running on Linux for reporting. We were doing a test to move the underlying data warehouse from another database platform to SQL Server 2008 R2. As we changed connections over, however, we quickly ran into a roadblock. It seems when we tried to make a connection to SQL Server via BO we got the error of 'Unable to bind to Configuration Object...
I hope you were able to attend my free webinar on Ad-hoc Reporting with SharePoint on May 21, 2013. If you weren’t you can now watch the recording here . As usual there were many great questions that I wasn’t able to answer and I thought I’d follow up on those now. Q: In the organization that I work in, SharePoint 2013 is stood up but is somewhat barren, just some team pages. Where would I be able to locate the ReportBuilder environment in a 2013 implementation? Is it apparent ...
Whats New BI-wise This is going to be the page I update when I have quick links and blurbs related to business intelligence that I'd like to share. Put your email in the widget at the very bottom if you'd like to be notified when the content changes. BI from g8rpal on 8tracks . Shelfari: Book reviews on your book blog ------------------------------------------------------------------------------- 5/22/2013 "The survey findings would seem to suggest that the CFO prioritizes business applications ...
I'm happy to officially announce that I'll be presenting at this year's PASS Summit in Charlotte, NC! I'll be presenting my talk "What is a BI DBA?" as a Spotlight Session (90 minutes). This is the second time I'll have presented at the Summit and I'm honored and beyond excited to have a Spotlight Session so we can cover more material! This year the conference runs from October 15-18. I hope to see you at the Summit this year! http://www.sqlpass.org/summit/2013/
It's official!! I will be presenting a session on HDInsight and Predictive Analytics at PASS Summit 2013 in Charlotte, North Carolina. This is the first time the event is being held in Charlotte instead of Seattle and while I have attended previous Summits for many years in various capacities, this year is special as it will be my first time presenting. I hope you will consider joining me this year at PASS Summit! For more information and check out the official website at: http://www.sqlpass.org...
Description: Java Online Training with 100% Job Placement Assistance Java/J2EE training from H2Kinfosys by certified professional with live projects. We successfully complete multiple batches with good success ratio, now going to start new regular and weekend batches shortly for more course visit our website h2kinfosys.com. We have great reviews by our Java Trained students with their achievements after our successful training completion. H2Kinfosys offering online and onsite Java Training Cours...
If someone tries to rename the column of table then we write a query as SP_RENAME 'TableName.[OldColumnName]' , '[NewColumnName]', 'COLUMN' --we use as SP_RENAME 'DimCustomer.[FirstName]' , 'CustomerName' , 'COLUMN' --Mistakenly, SP_RENAME 'DimCustomer.[FirstName]' , '[CustomerName]' , 'COLUMN' -- which gives the column the name [CustomerName], not CustomerName. For rename the column http://blog.sqlauthority.com/2008/08/26/sql-server-how-to-rename-a-column-name-or-table-name/ You don't use the [...
I recently had to set up another Date Dimension and went through the process of setting up all the properties in the date dimension so that when it is used in Excel, the end users would then be able to use the Date Filters built into Excel. The Excel Date Filters are very handy when creating Excel documents. As an example if you create your Date Filter to be for the last month. Every time you open your Excel document it will automatically filter to the current month. So below are the details on ...
Introduction: Informatica is a tool, supporting all the steps of Extraction, Transformation and Load process. Now a days Informatica is also being used as an Integration tool. Informatica is an easy to use tool. It has got a simple visual interface like forms in visual basic. You just need to drag and drop different objects (known as transformations) and design process flow for Data extraction transformation and load. These process flow diagrams are known as mappings. Once a mapping is made, it ...
Through this post , I want to share about the problem we faced while working in Windows Server 2003/2008. In our day to day work , we might frequently need to connect to remote Windows Server machine and while we try to connect to the Windows Server which allows multiple login session, sometimes we get an error message as : if there is no any free sessions “ If you need to connect the server urgently for your high priority task to complete then you simple need to find the sessions in that ...
Who's driving this car? At first glance it appears that as a developer, you have very little if no control over how MapReduce behaves. In some regards this is an accurate assessment. You have no control over when or where a MapReduce job runs, what data a specific map job will process or which reducer will handle the map's intermediate output. Feeling helpless yet? Don't worry the truth is that despite all that, there are a number of ninja techniques you can use to take control of how data moves...
I have been writing a lot of T-SQL scripts lately for regression testing. I identify test cases and write scripts to modify the data. Then the data can be verified as the rows go through ETL. As I tweak the scripts, I need to continually restore the source databases to get the data back to the starting point. Instead of doing restores, I am using the Database Snapshot feature. Database Snapshots were introduced in 2005 in Enterprise and Developer editions. They allow you to quickly revert a data...
I am late for posting this in time for T-SQL Tuesday, but I thought I would contribute anyway. This month the topic is about your career path. My career has focused on SQL Server since 2002, but it was a long, winding road to get here. I didn’t start out in technology at all; I began my adult working life in pharmacy. After getting to play with a TRS 80 computer in a class during my last year of pharmacy school, I became obsessed with computers. Programming became my hobby, and I learned s...
It appears that Microsft has silently refreshed some Services/Management portal as no blog or In specific im referring to the vizualization added to Windows Azure SQL Database We can now view Deadlock Failed Conections Throttled Connections etc You may view those by Logging into the HTML5 Management Portal Once in, you can navigate the new information as below Hit SQL Databases (on the Left Menu) --> Select a server --> Select a Database --> Select Monitoring Attached are a few Screensh...
This is just a quick tip to help with folks who present SQL code at events such as SQL Saturday. While most presenters use tools like ZoomIt (which if you present, please please learn to use this wonderful, free tool) sometimes it can get nauseating for attendees to watch you constantly zooming in and out, especially on code. A quick way around this is by using the magnification feature in SQL Server Management Studio 2012. To do this simply hold down the Ctrl button on your keyboard and with yo...
SP_SPACEUSED 'TableName' name rows reserved data index_size unused TableName 4 16 KB 8 KB 8 KB 0 KB
So I've decided to take a step in the right direction and begin the data modelling phase of my project. For those who didn't read my last blog post, I'm trying to find ways to study and get ready to take the BI Cert exam in September. I thought working on something for work might be a good way to start. So I'd like to begin by creating a small datawarehouse that tracks positions for investments. A position is the value of a portfolio of stock at a specific moment in time. So for example, the pos...
SSIS (SQL Server Integration Services) is well known for extracting data from a variety of sources. It can extract data from online sources as well. Google Spreadsheet is one of the online source which stores data online. In this post, we will learn to extract data from Google Spreadsheet using our favourite tool – SSIS. Pre-requiste: Before we talk about SSIS package, there are few concepts that we need understand. #01. To use Google Spreadsheet data you must have a Google account. With a...
In my last post ( HERE ) we talked about troubleshooting and resolving issues with problematic MDX queries. In this post we will look at techniques to tune and troubleshoot the processing side of your Analysis Services cube. Understanding Cube Processing Some of the common questions I hear as a consultant are "Why does my cube take 4 hours to process?" or "How can I reduce the time it takes to process my cube?". The answer to both of these questions starts with identifying the processing bottlen...
In this post I am going to deviate from Hadoop and HDInsight to focus on SQL Server Analysis Services Mutli-dimensional and more specifically MDX queries. As a consultant one of the common issues I encounter more so than design is that of performance. Typically, the performance issues SSAS users encounter occur in one of two realms: cube processing and query execution, while this post will focus on the latter we start by establishing a higher level of understanding of what happens when an XMLA c...
The D word...Documentation! I guess I am nutty but I think the product (whatever you making) is NOT complete until the documentaion is filed. There are two schools of thought here: documentation is not really important, who reads that stuff or sure do it but do not let that stop the deployment. The later is a half hearted attempt to appear that the higher ups are for it but they really do not care. HA! It should stop the deployment! I have worked only ONE and I mean one postion that had dcoument...
It's 2013, and I have several goals. Study for and pass the SQL BI certification exam - Implementing a DW with SQL 2012 Build a simple datawarehouse solution to practice with while I study Convince the powers that be, that it's a better idea to build something that buy something For #1, I need some advice on study guides, places to start, or essential books. For #2, I'd like to post my findings, mistakes, versions, and at times - frustrated rantings. Hopefully someone besides me will read this a...
Recently I was looking at the Adventure Works database and I noticed how Product, ProductCategory, and ProductSubCategory are their own separate tables. It got me to thinking about how someone might want to take attributes from each of those tables and create one hierarchy for reporting when you are looking at it. In DAX, this can be accomplished by using the RELATED() function. By using the related function in our table with our lowest level attributes, we can bring in the higher levels and cre...