Category: Data Analytics

An Easy Step-By-Step Guide: How to hide unrelated dimensions in a business intelligence tool!

Hiding Unrelated Dimensions in a BI Tool!

, ,
The main power of OLAP viewers (Business Intelligence Tools) is the ability for employees to do Ad Hoc reporting and analysis.  If one simply chooses the measures and dimensions they want to look at, the tool will return the data they are requesting…
Authorization placement example greatvines software

The Next Big Thing: TARGIT 2k13

, ,
Business Impact hosted last month ViewPoints, our customer appreciation day in Napa, where we invited our partner TARGIT to present their new product, TARGIT 2k13 – coming out this summer (expected in June). We were all excited to finally…
Authorization placement example greatvines software

Snapshot Tables Data Warehouse

, ,
Often our customers ask us to capture a specific point in time – say inventory or how much they are owed in Accounts Receivable – so that they can refer back to it later. Of course, this can be recreated by rolling back all the transactions…
Authorization placement example greatvines software

Microsoft’s Master Data Management as a system?

, ,
Master Data Management (MDM) is important because dirty data means poor adoption, poor decisions and poor BI, but to think of it as a separate system is very difficult.[quote align=”right” color=”#999999″]Imagine SAP having to accept…
Authorization placement example greatvines software

How to Install Pubs Database in SQL Server 2012 in 1 query

, ,
Upon request I published how to install Pubs database for SQL Server 2012. Several have had trouble attaching it following the guide for How to install Northwind for SQL Server 2012. One can download Northwind and Pubs here: http://www.microsoft.com/en-us/download/details.aspx?id=23654 where…
Authorization placement example greatvines software

Stock out counts and other inventory balances

, ,
A client recently asked why their measure for Zero Inventory Counts (stock out counts) was running long, and you’d think getting a list of times you didn’t have inventory would be easy. Except, it depends on how you are figuring that out.…
Authorization placement example greatvines software

Identifying Product Line Profitability through Landed Cost Analysis

, ,
Edit: The webinar is closed for registration (February 5th 2013) Establishing landed costs for the products that a company handles can be a tricky business. There are freight costs, but they are not generally by SKU. There is trade promotional…
Authorization placement example greatvines software

SQL Server 2012 SP1 is out!

, ,
To all Business Impact Clients: Microsoft released on the 19th November, the first Service Pack (SP1) for SQL Server 2012. One can find the list of fixes in their support article: http://support.microsoft.com/kb/2674319 and read more about…
Authorization placement example greatvines software

GreatVines National Account Authorizations and Mandates

, , ,
Welcome to the first in a new series of website posts dedicated to cutting-edge new features of GreatVines and Force.com in 2012. Hopefully by now you are already aware of and utilizing our new “Account Call” capability, affectionately…