Tag: Business Analytics

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

Filter Reports in Report Manager using Keywords

, ,
Microsoft’s Report Manager has already proven its capabilities as a powerful frontend portal, for easy distribution of reports to the business. The folder based interface in a browser makes navigation intuitive and comfortable for most users…
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…
An Easy Step-By-Step Guide: How to hide unrelated dimensions in a business intelligence tool!

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…
An Easy Step-By-Step Guide: How to hide unrelated dimensions in a business intelligence tool!

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…
An Easy Step-By-Step Guide: How to hide unrelated dimensions in a business intelligence tool!

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…
An Easy Step-By-Step Guide: How to hide unrelated dimensions in a business intelligence tool!

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…
An Easy Step-By-Step Guide: How to hide unrelated dimensions in a business intelligence tool!

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.…
An Easy Step-By-Step Guide: How to hide unrelated dimensions in a business intelligence tool!

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…
An Easy Step-By-Step Guide: How to hide unrelated dimensions in a business intelligence tool!

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…