You are currently browsing the category archive for the ‘ProClarity’ category.

Today, I got to experience things first hand with the installation of the following pieces of software.

Box1 – SQL Server 2005 SP3 (RDBMS, SSAS, SSRS, SSIS) installed and configured
Box2 – PerformancePoint Monitoring Server, ProClarity installed and configured
Box3 – MS Office 2007 Enterprise and MOSS 2007 Enterprise installed, configuration pending

Some interesting things of note:
1. ProClarity tries to connect using SQL authentication, and does not like to have a password that begins with ‘;’ – I almost lost it when it would not connect to the SQL Server, though I could see the connection coming to the back end and getting thrown in the error logs. Finally, I gave it a not-so-cryptic password and boom – it worked like a charm.

Next tasks:

  • Configure MOSS
  • Setup Excel Services
  • Setup Kerberos Authentication
  • Deploy Dashboard on MOSS
  • Setup accounts and permissions and trusts
Advertisements

This is the place I will come to gather my thoughts and keep a record of all that I will go through on my journey to becoming a BI guru, mainly dealing with the Microsoft suite of products geared towards Business Intelligence.

Microsoft Office 2007, including MOSS, more commonly known as the Sharepoint Server.
Microsoft SQL Server 2005/2008 – mainly Enterprise Edition, though I have the standard edition running on my laptop.
Microsoft SQL Server Analysis Server, to work on creating cubes and other fun stuff with the dimensional data models.
Microsoft PerformancePoint Server 2007, for dashboard design and deployment, integration into Sharepoint, using webparts.
Microsoft ProClarity Analytics 6.3, for dashboards and intricate layouts.

If you are interested in following my journey, feel free to stop by, join and chime in…

Timeline

December 2017
M T W T F S S
« Mar    
 123
45678910
11121314151617
18192021222324
25262728293031

Blog Stats

  • 43,267 hits