Dashboards done DIFFERENT! Next-Gen Information Workers UNITE! AtlasBI.com #analytics

atlaswebversion

In my years of doing business intelligence, one thing has been constant.  Reporting and Dashboards haven’t changed in nearly 25 years.  Sure, there are some new chart types and animations, but that is about it.   This type of reporting solution has been fine for the Boomer Generation and half of the X-Generation, but not the Millennials.

Wow, that is a crazy statement, right?!  Nope.  This new generation of business information workers look at data differently than the previous generations.  Does this new generation of business workers get excited to sit down and fire up SAP, IBM or Oracle applications?  I don’t think so! They basically consume nearly 80% of their business information via a mobile phone which means information needs to be accurate, informational and in an instant.

“Dashboards and data have to be re-thought for the next 10 years!”

When building my new Atlas Insights app, I wanted to provide this new generation of information worker with access to metrics in minutes that other traditional vendors provide in weeks or month.  I focused on building an app for EVERY platform and that includes iOS, OSX, Android, Windows and Web so that no matter where a person might me, their metrics are available to them.  The metric tiles are instant views into the heartbeat of the business.  The metrics become your living business logic nutted down into a view you can see and understand in seconds and make the right decision.

That is why Atlas Insights is completely different than ANY business intelligence reporting solution from the BIG vendors.  As proven many times in technology history, innovation comes from the little startup that is agile and not the big elephant in the room who is slow.

Go!… NOW!!!  Download for ANY computing device you own!

Have fun!  Patrick

BSM 2005 Compatibility Release and Rendering issues in SharePoint

If you are one of the lucky ones to install BSM 2005 Compatibility Release, it is an install that has all the updates built into it, there is a new file that gets written to your C:\Program Files\Common Files\Microsoft Shared\web server extensions\wpresources\Microsoft.PerformanceManagement.Scorecards.WebParts\[version]\BSM.CSS.

This file allows you to change attributes of the style of sharepoint when rendering scorecards.  Cool, BUT… It causes a rendering issues with the tabs in SharePoint.  If you are experiencing the issues, just rename the BSM.CSS file to something else (BSM.CSS.OLD) and then issue an IISRESET and everything should render just find.

Let me know if you have any questions.

Patrick

Passing Parameters from a Scorecard to a OWC Report View

I had a person email me this morning saying he was having issues with his Report View not accepting the parameters being passed from the scorecard.  I had this happen a LONG time ago and it took a little while to figure out what I was doing wrong, but it is a simple setup thing my OWC chart. 

Go ahead and design your OWC view exactly like you want.  Drop your measures and dimensions on your rows and columns.    BUT, do not put any page filters on the control.  You see, if you do that, BSM will not overwrite those page filters because it thinks you need those specific page filters there.   If you leave your page filters blank, BSM will then append its page filters to your OWC view.

Hope that helps.

Thresholds: Using the Banded by Stated Score (Advanced)

Not many people know and I got a chance to use it on a project.  But if you have thresholds down to your member level, it would be great to automatically have your banding change with it right?  Well, there is this little known feature, that a lot of people glance over, is “Band by Stated Score (Advanced)” that will allow you to do it.  Here are some simple steps to get started using it.

First and foremost, you need a measure for banding that relates to your members within the fact table.  If you don’t, you could use fixed values to see how it works.

1.  Change your Banding method to “Band by stated Score”

2. Click the Specify Data Mapping button

3. Now map your threshold to the appropriate measure in the cube.

4. Oops, forgot to mention that your banded stated score needs to be returned is a simple decimal.  You can figure our the calculated measure you will need to create in SSAS.   Look at the following example of my banding.  Pretty straight forward.

Now publish it and give it a try! 

Later

Patrick

The Business Scorecard Manager Compatibility Release

Microsoft is releasing an update to Business Scorecard Manager 2005.  Below is an excerpt from the release I have received.  You should be able to download the update via the Microsoft PerformancePoint web site.

Overview

The Business Scorecard Manager Compatibility Release is now available for the following languages:

  • English
  • Chinese (Simplified)
  • Japanese
  • German

This Compatibility Release will be available for the following languages in February:

  • Chinese (Traditional)
  • Danish
  • French
  • German
  • Italian
  • Japanese
  • Korean
  • Polish
  • Spanish
  • Swedish

Issues that the Compatibility Release fixes

This Compatibility Release fixes the following issue that was not previously documented in a Microsoft Knowledge Base article:

  • When you install Business Scorecard Manager 2005 on a computer that also has Microsoft Office Share Point Server 2007 or Microsoft Windows Share Point Services installed, the Setup program does not detect an extended site. Therefore, the Setup program is not completed successfully.

    Note This Compatibility Release enables users to install the Business Scorecard Manager 2005 Web Parts to a Microsoft Office Share Point Server 2007 site or a Microsoft Windows Share Point Services site. This Compatibility Release does not fix the deployment functionality that is provided in the Business Scorecard Manager Builder. To deploy a Web Part, you must publish the Scorecard in the Business Scorecard Manager Builder, and then manually open the Web page and add the required Scorecard Web Parts.


An updated Read-me for this release is available at:

http://download.microsoft.com/download/f/d/4/fd4261fc-b0a7-4f14-a2b8-f8ef732eca9c/ReadMe.htm


For more information about how to do this, see the “Publishing Scorecards to Microsoft Office Share Point Services 2007 (MOSS 2007)” whitepaper. The whitepaper is located at the following Microsoft Web site:

http://www.microsoft.com/downloads/details.aspx?FamilyID=d5d1b0f9-99e1-44ff-9640-96a716098f8e

  • Additionally, this Compatibility Release contains all of the previously released updates for Business Scorecard Manager 2005.

 

More Information Section

Compatibility Release information

The Compatibility Release for Business Scorecard Manager 2005 is now available from Microsoft, but it is only intended to correct the problem that this article describes. Apply it only to systems that are experiencing this specific problem.

To resolve this problem, contact Microsoft Product Support Services to obtain the Compatibility Release. For a complete list of Microsoft Product Support Services telephone numbers and information about support costs, visit the following Microsoft Web site:

http://support.microsoft.com/contactus/?ws=support

Note In special cases, charges that are ordinarily incurred for support calls may be canceled if a Microsoft Support Professional determines that a specific update will resolve your problem. The usual support costs will apply to additional support questions and issues that do not qualify for the specific update in question.

The media will be sent out in the VL KIT shipments for the first 4 languages in the March2007 VL KIT. Customers can now download the bits for the first 4 languages through the MVLS download.

 

Also the Compatibility Release is available on MSDN and TechNet.

 

Prerequisites

The following list contains prerequisites for the Compatibility Release:

  • You must remove Business Scorecard Manager 2005 from the computer before you install the Compatibility Release. To remove Business Scorecard Manager 2005, use Add or Remove Programs in Control Panel.

    Note Removing Business Scorecard Manager 2005 from the computer does not remove the Scorecards, database, or other Business Scorecard Manager 2005 files you created.

  • If you install the Compatibility Release on a computer that also has Microsoft Office Share Point Server 2007 or Microsoft Windows Share Point Services installed, the Application Pool of the Business Scorecard Manager Web service should be selected such that the Application Pool does not run any .Net 2.0 sites.

    For example, create a separate Application Pool for the Business Scorecard Manager Web service and assign this Application Pool only to the Business Scorecard Manager Web site.

    Note If the Application Pool that is running the Business Scorecard Manager Web site also runs a .Net 2.0 site, there will be process conflicts and neither of the Web sites will function as expected.

BSM Server installation with SharePoint Portal (Office Server) 12 beta

Has anyone gotten this to work?  I started building a VPC with all the software and there is a certain install process you need to do.

  1. Create a Clean Windows 2003 Server VPC
  2. Install SQL 05 with all the goodies
  3. Install SharePoint 12 beta but use the FARM setting and then Web Client.  Then choose the local DB instance.  The reason for doing this is if you choose the default install option, it overwrites SQL05 with SQL05 Express Beta.  Breaks.
  4. Reboot
  5. Install Office Professional 12 beta bits.

Ok, here is the issue.  When you install BSM Server, you get the following pre-req checks and one fails.  Don’t know how to get by it.  Do you?

Web Parts
Passed Microsoft .NET Framework 1.1
Passed Microsoft ASP.NET 1.1
Passed Microsoft Internet Information Services (IIS) 6.0
Passed Windows SharePoint Services 2.0 or Microsoft SharePoint Portal Server 2003
Failed Microsoft SharePoint Extended Site
Web Service
Passed Microsoft .NET Framework 1.1
Passed Microsoft XML Core Services (MSXML) 4.0
Passed Microsoft OLE DB Provider for OLAP Services (MSOLAP) 2000 SP4 (8.00.2039)
Passed Microsoft ADOMD.NET 8.0
Passed Microsoft ASP.NET 1.1
Passed Microsoft Internet Information Services (IIS) 6.0

BSM Deployment Documents

Deployment Considerations White paper (look under Scalability and Performance)          

http://www.microsoft.com/downloads/details.aspx?familyid=6B4C74E4-94A9-456C-8699-F5628F2D0D30&displaylang=en

 

Technical White Papers

http://www.microsoft.com/downloads/details.aspx?familyid=D5D1B0F9-99E1-44FF-9640-96A716098F8E&displaylang=en

 

Operations White Paper

http://www.microsoft.com/downloads/details.aspx?familyid=BCD72419-33D3-4B6A-9ECC-B8FFDBADD725&displaylang=en