A few folk have asked how to just connect automatically to Essbase from Excel VBA. Please find below a simple VBA sub stripped back to show this. Use the following to initialise with your own details in place.
Call initialise("xxx","xxx","xxx","xxx","xxx")…
Having used GUP from Netlobo http://www.netlobo.com/comments/url_query_string_javascript for some time to pull back parameters from the URL in JavaScript for fiddling with, I decided to create a handy JQuery extension for reuse.
Extending this further with the gpn section to get all parameters, which is also from their website, you’ll find …
When designing pages utilising CSS for their styling and splitting the semantic content away in an attempt to move legacy systems into the dot com era it might be necessary to show why kicking a browser into CSS Compatability mode might be a good idea. Not least that you can …
Still sometimes need to use batch files to do stuff even in this day and age? Yes, is the usual answer but, unfortunately many of the standard errorlevel checking tools such as CHOICE etc. have either been removed or cannot be used without administrator access in Enterprise environments.
It’s not …
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 …
Found yourself in a strictly locked down Windows desktop environment? Hate those sodding grouped windows on the taskbar and can’t get rid of them? Try out the below code by saving in a .vbs file and double-clicking to ungroup your windows. To group again, just re-launch the script.
There are …
Having found on more than a few occasions that MS Excel’s output to HTML is more than a little bloated and not very editable I needed a way to output clean HTML markup to a simple shared folder area.
This was originally used in Excel 97 and has not been …
Thinking that there was a hold up at the back of the site I decided to dig up some of the original ‘turn of my hand’ development from way back yesteryear.
Here is an incarnation of the Edinburgh Flat site from 2005 onwards?!
Thinking that there was a hold up at the back of the site I decided to trip around the WayBackMachine and dig up some of the original ‘turn of my hand’ development from way back yesteryear.
Here is an incarnation of the Edinburgh Flat site from 2004:
Thinking that there was a hold up at the back of the site I decided to trip around the WayBackMachine and dig up some of the original ‘turn of my hand’ development from way back yesteryear.
Here is an incarnation of the Puffin Music site from 2003/4:
