Posted by sranka on July 9, 2009
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.
Sunil S Ranka