Tag Archives: corporate

Building An Online Community – Organisational Intranet

You may find that colleagues, especailly senior colleagues are cautious over the implimentation of so-called community building or collaborative software. However, with the correct departmental governance and policing, and best practice of this area, community software can be utilised to its full benefit as a useful and integrated business tool.

Community building software can promote organic connections between colleagues. This will, as a by-product, act as a structured storage mechanism for unstructured corporate knowledge which otherwise would only be held between individuals in an un-retrievable unstructured manner.

These types of electronic storage mechanisms are used to great effect within industry leading technology companies such as IBM and Microsoft. Organically structured groups of colleagues are able to liaise from a single recordable point removing the obvious issues of geographical displacement. There is also an instant removal of cottage industries updating and managing phone lists, structure charts, etc. The community area can remove pressure from traditional means of business communication such as email.

Software such as Microsoft SharePoint MySite’s potential, for instance, can be realised if embedded within already established business processes. For the majority, people associate social networking with Internet based networks such as Facebook and MySpace; certainly at the opposite end of the spectrum and barely recognisable as productivity tools! The potential though to improve performance and cut costs is certainly possible should such an Intranet community be used productively and ring-fenced in a business setting.

The key to successfully utilising social media at work lies in comprehending it is very different in nature to its vaguely similar consumer cousins. With a different approach social networking can exploit the simple rationale pulling individuals into consumer resources: that of a simple purpose! Business social networking requires a defined business purpose with specific usage guidelines providing real leverage such as building teamwork, organisation around projects, and organically building a corporate knowledge base.

A community Wiki building a corporate knowledge base, for instance, categorising and built from what would otherwise be unobtainable unstructured data kept in varying hetrogeneous systems, paperwork, peoples heads, can be fashioned to store searchable data and information access to the entire organisation – of what would generally only be available to the few.

Historically, teamwork built through staff meetings, company team building workshops, team nights out, departmental parties, etc. are face-to-face interactions. The flip-side can be an electronically stored impressionistic sense of business activity formed around colleagues actively publishing activities around them. Largely self-organising and leaving a permanent organic record of communication around, say, a project otherwise not existing, can generate implicit awareness to colleague work groups.

Ultimately this can replace, but probably not in its entirety, traditional communication mediums such as the email list which lacks structure and is difficult to manage. An Intranet social network on the other hand provides many-to-many communication within a structured and collaborative environment.

  • Share/Bookmark

Hyperion Essbase -> Excel -> Access -> automagic

Accessing Hyperion Essbase is no problem directly from their MS Excel plugins. Though what happens if one wants to import on-the-fly and put that into MS Access so you can deliver your MI: Management Information, alongside current data without having to analyse and alter Hyperion Essbase output in Excel before exporting to textfile format or CSV before manipulation?

Well, why not try the below code!

The below function run within MS Access will write an “Essbase connection plugin” before instantiating a copy of MS Excel to run Essbase from. Unfortunately if you don’t write out and pull in the textfile to create a module in Excel as is within the code Microsoft’s security permissions now deny access. Give them their due – it was a good move for certain issues.

After the “plugin” is pulled into the MS Excel workbook it fires a connection to Essbase and in this case draws down and partitions the relevant info to worksheets. Note the code will require setting up against whatever Essbase fields you require from your system.

The code as you will see at the bottom will clear down any previous retrieval before using MS Access’  TransferSpreadsheet import functionality to pull in the retreived workbook. The code also requires a table within MS Access to hold your Hyperion Essbase login details. In this case the table is called tbl_essbase_credentials and can be seen within the code. The Excel workbook is cleared down and you are left with your Hyperion Essbase MS Excel retrieval in your MS Access database.

Way to go!

So the process from MS Access is to run function and -> create a module for import into MS Excel -> start a virtual copy of MS Excel -> import the module into the virtual copy of MS Excel -> run virtual module to connect to Hyperion Essbase and download required data -> save MS Excel workbook and transfer the spreadsheet into MS Access -> clean up. All from within MS Access!

  • Share/Bookmark

HBOS: Corporate Finance & Planning – 2

This was a continuation of previous contract from November last year again involving many differing Information System (IS) processes to achieve final products.

Projects included Lead Developer role to new-build database driven Business Intelligence & Management Information reporting tools; Corporate Intranet sub-websites;

  • Intranet based be-spoke interactive Intranet Mangement Information Dashboard fed from business accessible MS Access database driven backend fed to Intranet SQL Server XML driven Flash/JavaScript frontend;
  • Intranet Leadership Commitment web portal;
  • Web enabled risk data integrity checker;
  • MS Access based reporting tool for IFRS7 data display of entire Corporate balance sheet;
  • Basel II compliance reporting application with full Corporate balance sheet drill down;
  • Be-spoke Corporate Cost Allocation model for entire Corporate book and associated reporting built in MS Excel;
  • First Corporate web enabled Debt Instrument drilling tool;
  • Ad-hoc Business Objects Reports;

Tools used included:

HTML, CSS, JavaScript, MS Access, MS Excel, XML, VBA, Business Objects

  • Share/Bookmark

HBOS: Corporate Finance & Planning – 1

Intranet development and client-side web enabled applications development.

Excellent contract involving many differing Information System (IS) processes to achieve final products.

Client-side web application utilising Internet Explorers Data Island technology to hold source and data bind dynamically built resultant data for on-screen viewing. Heavy use of JavaScript to build dynamic search drop-downs and to traverse the DOM of an XML source document held within a source XML Data Island.

Utilised JScript to traverse the dynamic result display for exporting via ActiveX to Microsoft Excel. XML Source document built from 6+ Business Objects reports output; manipulated; cleaned; and combined within a bespoke MS Access database before exported to XML.

Creation of a Intranet “Portal” for the Business Intelligence department within Corporate Finance & Planning.

  • Share/Bookmark

HBOS: Vehicle Finance Intranet

The Intranet site was upgraded to adhere to XHTML Strict markup and to use CSS purely for its styling. Upgrade was inclusive of several self-built dynamic web-based applications.
Employed by HBOS: Vehicle Finance as Systems Analyst,  I took over the role of Lead Intranet Developer: inclusive of server management, and moved towards upgrading their flat HTML based Intranet site into a dynamic ASP: VBScript based portal to pull in the three distinct geographical areas making up Vehicle Finance: Edinburgh, Chester, Bushey.

Due to server restrictions, and cross domain users, I was unable to use a standard database format such as MS Access or MS SQL for a backend. Instead I opted for my own built flatfile XML based relational database.

As part of the upgrade an XML/JavaScript/ASP, based dynamic phonebook was produced to aide communication between the three geographical sites. A standalone MS Access “phonebook repository” exports XML for the Intranet when an entry is added/updated. This database extended to be the central Vehicle Finance Human Resources Repository, and again upgraded to also incorporate all Financial Services Authority details.

Other own built web applications to streamline business processes included a News CMS, and a Systems self-help tool (SOS) as well as an Online Systems Status tool.

Further projects integrated into the Intranet included business areas KPI (Key Performance Indicators) being updated direct to the Intranet from each core system / department through the use of Business Objects reporting software and MS Acess databases to export pertinant data into XML schema to be fed into Macromedia Flash graphic reporting .swf files.

XHTML, JavaScript, CSS, XML, ASP:VBScript, Flash, BusinessObjects, MS Windows IIS
Intranet Logo Design

  • Share/Bookmark