What-If Analysis needs JavaScript on OBIEE
Posted by sranka on July 9, 2009
Hi All,
Apologies for not replying the comments and pings. Was caught up with OAUG conference in May, June was equally tough. My wife has started with her internship and daughter with day care. Life is getting hectic, but can’t complain. Coming back to the jargon of — WHAT-IF ANALYSIS –. This was one the topic, at least talked about few time during OAUG. But it was always talked in conjunction with hyperion. After putting some thought, came to conclusion that some of the basic What-If can be done using Java Script.
At one of the client place, there was requirement for implementing a report, in which punching some number can project how many more $ worth of product selling needs to be done to attained the goal booking for the current quarter. This requirement was met using custom Java Script and few text box. Since it was very specific requirement, hence not sharing the code. But thought will just share the idea, so that any one want to create WHat-If in OBIEE dashboard, Java Script could be the way.
If you need more detail, you can send me email, I will be more than happy to answer the question.
Thanks
Sunil S Ranka
Christi@n said
Hi Sunil,
quite some things are actually possible without using JS. You can “fake prompt” conversion values or rates and then apply them as multiplicators or within mathematical functions in the criteria blocks.
Works like a charm, just isn’t as fancy as the Hyperion funtionalities of course. That being said…it’s still nicer than JS since you don’t need to to maintain any code.
Cheers,
Christi@n