Search Results: COST

• 
  Slicing and dicing the income statement (4), costs

  Let's see why costs in a P&L are arranged in a specific way.

  Author:  Stray__Cat     Date: 7/12/2010     Section: Article

  tags : costs P&L, datamart, income statement, Management
• 
  Finding rolling costs for 13 months

  Hi Experts, I need urgent help on this issue I have a formula 'Sum(LastPEriods(13, CLosingPeriod([Rolling Date].[Month], [Rolling Date].CurrentMember)), [Measures].[Waste Costs])' which calculates rolling costs for last 13 months e.g today current month +

  Author:  qutesanju     Date: 9/6/2010     Section: Forum

  tags : analysis services, MDX, rolling costs
• 
  New Path to Microsoft Certified Master (SQL Server 2008)

  I came across an interesting blog link yesterday by Joseph Sack which outlines the new path to get certified for Microsoft Certified Master. The current MCM program requires you to take three written exams and a six hour lab exam which would cost around 1

  Author:  indupriya     Date: 11/15/2010     Section: Blog

  tags : Microsoft Certified MAster, Sql server 2008, MCM
• 
  Rock Your Reports Series 1 of 3

  In this article, Sherri will show you how create a report that will utilize a your toolbox items from SSRS 2008 and SSRS 2008R2. Learn how to build the report with step by step instructions, including the query to pull the back the data. This is part 1 of

  Author:  SMcDonald     Date: 3/11/2011     Section: Article

  tags : Charts, Indicators, Pragmatic Works, Reporting S, Rock your reports, SSRS, Webinars, Sherri McDonald
• 
  Which is more efficient Union or Union All

  Hi Folks, This is my first blog on BIDN.com. Recently while working on an application I had to use UNION statement to combine to query results. As a true developer, I was not concerned about the perfomance issues till then. However due to increased focus

  Author:  pratmicro_20     Date: 5/10/2010     Section: Blog

  tags : UNION, UNION ALL, sql
• 
  SSIS vs. Informatica

  Here is my thinking after looking at both products... First of all let me tell you what I like about informatica.... - Inbuilt tool to export mappings to Excel and Visio.... helpful to document Process. - Reusability of sources,Targets and Mappings (In SS

  Author:  NayanPatel     Date: 4/29/2011     Section: Forum

  tags : compare ssis vs Informatica, etl tool compare, ssis vs Informatica
• 
  SSIS Data Flow task not running, but not failing

  I'm not sure what's left, personally, I'd probably take the following steps ( top to bottom ) to see if I could get anymore info before option 4 ( support call ). Have you checked the error log for SQL server as well as the event viewer ( maybe export / c

  Author:  KeithHyer     Date: 11/30/2011     Section: Forum

  tags : ADO.Net, data flow performance, ODBC, permissions, PI WADIS
• 
  KPI - ScoreCard - Dashboards

  What tools have you used to display and manage KPI data. We have a project that we are building SSAS cubes and managing KPI information from these. We are exploring tools to build an interface for our clients and I am curious what you have used that has w

  Author:  bretupdegraff     Date: 12/17/2009     Section: Forum

  tags : Performance Point, Scorecard, Sharepoint, SSAS, KPI
• 
  Cost of Duplicate Elimination

  Hi, I am blogging after a long time now. By the way today's topic is about 'Duplicate Elimination' and why one should avoid it. One might be tempted to place DISTINCT after every SELECT, on the theory that it is harmless. In fact, is very expensive to eli

  Author:  pratmicro_20     Date: 7/12/2010     Section: Blog

  tags : COST, DUPLICATE ELIMINATION, SQL, Distinct
• 
  MS SQL BI Stack

    There are many organizations that piece meal their solutions together for many reasons. Some of the reasons might have valid reasons, however, none this include the power of the Microsoft BI stack.   Microsoft has a complete BI solution under

  Author:  ogonzalez     Date: 12/19/2011     Section: Blog
• 
  SSIS Updating a table with a temp table not an OLE DB command

  Summary There are times while using SSIS when its neccasary to update rows in your table based on source data being recieved. The simplest way to do this would be to use an 'OLE DB Command' in the data flow, however this task will be costly as it performs

  Author:  DanMatisis     Date: 5/22/2010     Section: Blog

  tags : Retain Same Connection, UPDATE, ValidateExternalMetadata, TempTable
• 
  SQL Saturday in Jacksonville April 30th!

  SQL Saturday will be in my backyard April 30th, looking forward to seeing you there! Welcome to SQLSaturday #74 SQLSaturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. This event will be held Apr 30 2011 a

  Author:  DonnyJohns     Date: 3/30/2011     Section: Blog

  tags : Jacksonville, Pragmatic Works, SQL Saturday, Donny Johns
• 
  Does the Cloud Mark the End of the Production DBA?

  While I’ve been on the Expedition Denali roadshow, a portion of the event is about SQL Azure, Microsoft’s new cloud database computing platform. I always enjoy watching and surveying the DBAs in the audience during and after the session about how they fee

  Author:  BrianKnight     Date: 7/1/2011     Section: Blog

  tags : cloud, azure
• 
  mdx cube calculation that may need to use some type of subquery

  DustinRyan said: Take out your calculations and replace it with 1. Dustin, Is this what you mean ? CREATE MEMBER CURRENTCUBE.[Measures].[LY_Fix_Act] AS NULL, VISIBLE = 1; CREATE MEMBER CURRENTCUBE.[Measures].[SumMeasure] AS [Measures].[Actual], VISIBLE =

  Author:  robbie     Date: 7/21/2010     Section: Forum
• 
  Sharepoint

  What are the advantages of integrating Sharepoint into SQL-Server Reporting Services? Are there costs associated? How is security handled? Do organizations run dual environments - SSRS & Sharepoint? What's the downside of using Sharepoint? Thanks, Jon

  Author:  TampaBayBI     Date: 4/6/2011     Section: Forum

  tags : license, Security, Sharepoint, ssrs2005
• 
  Expedition Denali Workshops by Pragmatic Works

  Did you know that Pragmatic Works is currently traveling the country doing workshops with SSAS or SSIS leading up to the latest release of SQL Server Denali? This is the same type of training that Pragmatic Works offers with its virtual classes but with 2

  Author:  ChrisAlbrektson     Date: 2/22/2011     Section: Blog

  tags : Pragmatic Works, Training, SQL Server Denali
• 
  Blogging and Saving Money at the Same Time

  I enjoy blogging. I enjoy passing on the information that I have gathered over the years. I also enjoy doing this while watching television. Currently I subscribe to Directv, but that is all about to change. This blog is about blogging in general, but mor

  Author:  briankmcdonald     Date: 11/9/2010     Section: Blog

  tags : Streaming Video, Blogging
• 
  Aggregates vs. calculated measure

  Aggregates In SSAS any column in a fact table that is not a foregin key is set up as a measure. The default aggregation is a SUM. If you need another form of aggregate like an average it may not be simple to arrive at. The built in average funtion in SSAS

  Author:  indupriya     Date: 6/13/2010     Section: Blog

  tags : SSAS, MDX
• 
  LookUpCube Function MDX Query Performance Test

  In my previous blog post , I mentioned that there was a performance cost for using the LookUpCube function. Well recently a coworker asked me just home much of a performance hit was the LookUpCube function going to cause. So I decided to conduct a test. I

  Author:  DustinRyan     Date: 7/7/2010     Section: Blog

  tags : MDX query performance, LookUpCube Function
• 
  KPI - ScoreCard - Dashboards

  Egan, How does Panoramo NovaView and Tableau compare to the demos that you have seen on iDashboards? I am hoping to pull down the eval of iDashboards this weekend and evaluate. if it can't use SSAS that will likey be a show stopper. Does Panoramo and Nova

  Author:  bretupdegraff     Date: 12/18/2009     Section: Forum
• 
  SSIS vs. Informatica

  Well ... Informatica was pioneer in ETL market … they came very first in the market they dominated many fortune 500 hundred companies... But since then MS Seriously invested in BI Segment and current trend is MS BI is the fastest growing trend due to many

  Author:  NayanPatel     Date: 7/14/2011     Section: Forum

  tags : INFORMATICA POWERCENTER, MS BI
• 
  Traveling and Airtran

  I am a pretty frequent traveler, as you would imagine. Running a consulting company, and being on it’s principals assets keeps me pretty busy. I have always been a delta guy, but lately the price of airline tickets has gone up dramatically and I have begu

  Author:  AdamJorgensen     Date: 12/7/2009     Section: Blog

  tags : consulting, travel
• 
  Introduction to Parallel Data Warehousing

  What are we talking about? Recently Microsoft released a new version of SQL Server 2008 R2 called Parallel Data Warehouse Edition. there has been a lot of buzz about this new architecture because it is Microsoft’s entry into the Massive Parallel Processin

  Author:  AdamJorgensen     Date: 7/29/2010     Section: Blog

  tags : Parallel Data Warehousing, PDW
• 
  No Complaining Rule

  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 struggli

  Author:  Dean.Brown     Date: 3/24/2013     Section: Blog
• 
  Intro to TSQL Statements – Subqueries

  If you understand how to use a SELECT statement you have the ability to create a subquery. When you use a SELECT statement within another TSQL statement you are using a subquery. One example is within a WHERE statement. The simplest form of a WHERE statem

  Author:  MichaelSimon     Date: 11/23/2011     Section: Blog