#custom defined functions

Recently the Essbase CDF sample code was moved and I thought it would be a good idea to let every one know where the new code can be found.

http://www.oracle.com/technetwork/indexes/samplecode/essbase-sample-522117.html

or

download.oracle.com

Click Sample Code Index on the left

So for an upcoming ODTUG presentation I needed to create some basic CDF's to show as examples; so I decide I had to do something more fun than just logging data or running an executable.  As I was updating my Twitter status I realized there may be an actual business case for having a Twitter account and my CDF example was born... The use case is to follow an Essbase server on Twitter and get updates as calculations are run on the server.

Here is what I did:

Set up a new Twitter account (did not want to mess with my own account) http://twitter.com/essbaseserver

Using JDeveloper I created a new CDF that sends string updates to twitter.  I did this using JTwitter an open source Java library for access to twitter.

Registered the CDF and created a calculation script to run while sending the Twitter account status updates.

RUNJAVA com.oracle.essbase.cdf.EssbaseTweet "Running a Calculaiton on the Cube Sample.Basic";

Calc ALL;

fix("Market","Sales","Jan",@LEVMBRS ("Product", 0))

"Actual"(

@EssbaseTweet (

@CONCATENATE (

@CONCATENATE (

@CONCATENATE ("Sales for ", @AlIAS(@CURRMBR("Product")))

, " are "), @JgetStringFromDouble (@CURRMBR ("Product"),@_false,@_false)));

)

endfix

 RUNJAVA com.oracle.essbase.cdf.EssbaseTweet "Calculation Complete on the Cube Sample.Basic";