The best is yet to come
The pain and the agony
Not the square peg in the round hole
Not really, no not at all. And I can’t even surf. And yes, that is a scary video for me to know about (thank you, Oh Great False God Google) and even more scary for you if you clicked on the link.
Nor do I wear a wimple whilst flying, or at any other time.
But I can say, “You like me, you really like me”.
I know, more blathering, but that’s just me being bashful about something that you, my adoring/tolerant/frankly bored reading public have done: elected me a member of the ODTUG board.
All kidding aside, I never thought I would get elected, particularly on the first go round. I am beyond pleased, humbled, and more than a little scared.
Thank you so much for taking a flier on me. I hope I don’t disappoint.
Here are we happy few in the 2011 ODTUG Board of Directors:
It’s often dangerous to make promises if you aren’t sure you can deliver on them. This may be why I am a semi-successful consultant and not a fan of politicians. Regardless, getting onto the board was the outcome of an election.
What I know I can do is to serve you, the Oracle EPM community, and the rest of the Oracle world as best I can. I am more than open to suggestions and comments. You can always contact me through LinkedIn.
I look forward to this – it’s going to be a lot fun.
And thanks for your confidence in me.
This is number four in my series of short tricks and tips.
I debated about the utility of this until I spent an hour trying to figure out how to search MaxL scripts with Windows Explorer’s Search function.
The fix is easy and oh so useful.
Let’s say I want to find all of the MaxL scripts that use the “spool” command.
If I searched all of the .txt files in a given folder, Explorer’s Search function would give me a nice list of files that contain the string “spool” in the file body.
To prove this, I renamed a MaxL file so that it has an extension of .txt.
Here are the results:
But if I search the same folder for the same file with a .msh extension I get this:
Of course, I could:
1) Find every MaxL script (in my world, they end with a .msh, and yes, that is important) in a given folder, harddrive, computer, etc.
2) Open up every one of those MaxL scripts and search within for “spool”.
But there is a Better Way. The cockroaches of Sidi-Bel-Abbes will thank me for that one.
Go to the Start->Run menu and type regedit.
If you’ve already changed .msh files in Explorer to open with Notepad or my personal favorite TextPad, this step isn’t necessary as the main key will exist in the registry.
Add a new Key:
The Registry Editor will stick this new key at the bottom of the list – don’t worry about the order.
Rename the selected text to .msh and hit Enter.
Add another new key to the .msh key – I guess you could call this a subkey – by right clicking on .msh.
Here’s what it looks like:
Now give that key a default String value:
It is not going to be set by default.
Right click on (Default) and select Modify.
Now we need to give the Default key a very specific value. Just copy and paste this into Regedit:
After you click on OK, you should see the following:
Log off and log back on; rebooting shouldn’t be necessary.
Search now lets you look inside .msh files.
Not a big deal, or the world’s best hack, but it sure is a nice way to search for a string within a non-standard file type. Of course you can extend this technique to .csc, .rep, and .whatever files you need to scan. Useless 99% of the time, but when you need it, you need it.
Happy hacking till next time.
Number three in my series of short tricks and tips.
This is a case of misleading documentation. Or a stupid programming trick. You decide.
The Most eXcellent Awesome Language (MaxL) maybe isn’t
display variable all ; will display all variables on your Essbase server.
display variable on database Sample.Basic ; will display all of the variables in My Very Favorite Essbase Database In The Whole Wide World (MVFEDITWWW).
But what if you have a variable called Test defined in MVFEDITWWW?
Here's the syntax from the Tech Ref:
display variable test on database sample.basic;
display variable 'test' on database sample.basic;
They don't and will kick out an error near 'on'.
The actual syntax is:
display variable sample.basic.test ;
Do so and you will get back:
application database variable value
Sample Basic Test "Jan"
You could also type display variable othertest ; and get back the results if the variable was at the server level. I think otherwise you have to start using the appname.dbname.varname nomenclature. I believe (and I haven't tested this, but it seems reasonable -- hey, this gives you something to do if in case you are casting about for something to play around with) display variable appname.varname ; also works.
I’ve named these short posts “Stupid programming tricks”. Surely this post fits the description. Until you can’t figure it out.
Happy MaxL hacking till next time.
RAM in GB
Disk in GB
Extra Large Instance
4 virtual cores with 2 EC2 Compute Units each
High-Memory Extra Large
2 virtual cores with 3.25 EC2 Compute Units each
High-Memory Quadruple Extra Large Instance
8 virtual cores with 3.25 EC2 Compute Units each
Windows 2003 Server
Work in progress
Work in progress
MS Office 2007
You must supply a valid key
SQL Server 2005
Part of the AMI
Demo to client
Demo to client