Purge BI Server Cache from Dash Board

One of colleague asked me, is it possible delete server cache from dash board? So started working on it, finally got solution how to do that.
I have created a script using C# on top of obiee-webservices, built a web page and embedded it on Dashboard, as of now I have incorporated Purge All, Purge by Database and they are working cool.


I have refered following resource,

Thanks John, for a very good article on cache purge.
Oracle technical resource on cache purging.
Oracle technical guide on Web Services.

I am thinking to make it as handy tool and available to every one.
Posted by

17 comments:

  1. AnonymousJuly 10, 2009 at 12:56 PM

    Forgive me if I come off a little blunt, but you are "thinking" to make it available? why bother blogging about it and call your site "tipsonobiee" if you have to consider to share your findings?

    ReplyDelete
  2. Srinivas MalyalaJuly 26, 2009 at 1:24 PM

    Hey Anonymous,

    Thanks for your message.

    If i have to make it as common tool, I have to code a lot, right now I have hard coded few things like administrator password etc and one more part deployment i need to see which method works fine. I'm ready to share my code with you all if you want to know insight.

    I thought of checking with you all guys. If you guys really needed then I can spend sometime to make it as "Tool".

    ReplyDelete
  3. Avik BhattacharyaAugust 20, 2009 at 12:43 PM

    Hi Srinivas,

    I have been using the same links you linked when it comes to purging cache but i think it would be greatly desirable to have a OBIEE dashboard page to purge cache . Is there a way we could see the code, I can probably customise it for my environment if you would be so kind as to share it?
    Thanks

    ReplyDelete
  4. Srinivas MalyalaAugust 20, 2009 at 1:03 PM

    Hi Avik,

    Please send me your mail id i can send you code which i have...

    Thanks
    srinivas.malyala at gmail dot com

    ReplyDelete
  5. AdamNovember 4, 2009 at 7:19 PM

    can you send the code thanks

    higgs.a@gmail.com

    ReplyDelete
  6. BrahmavithNovember 13, 2009 at 6:29 AM

    Hi,

    Srinivas I am Narayana.Is there any way to get Physical Query by passing Logical Query to OBIEE Server through web service.

    ReplyDelete
  7. Srinivas MalyalaNovember 13, 2009 at 2:19 PM

    @ Narayana,

    As per my knowledge, there is no such web service which translate logical query to physical query.

    Thanks
    Srinivas

    ReplyDelete
  8. BrahmavithDecember 16, 2009 at 4:43 AM

    Thnkyou Srinivas



    Narayana

    ReplyDelete
  9. UnknownDecember 30, 2009 at 12:07 AM

    Hi Srinivas,

    Appreciate your work.
    Can you please mail me with your code to obi.rajesh@gmail.com.

    Thanks in advance

    Rajesh SSS

    ReplyDelete
  10. AnonymousDecember 31, 2009 at 12:51 PM

    Srinivas..This post is very interesting.Could you please mail me the code for purging the cache from dashboard pages to mydwcareer@yahoo.com

    I would want to look at this approach for my project.

    Thanks

    ReplyDelete
  11. Hemant JerathApril 21, 2010 at 1:56 PM

    Hi Srinivas,

    Can you please mail me with your code to hjerath@gmail.com

    Hemant

    ReplyDelete
  12. Hemant JerathApril 21, 2010 at 1:57 PM

    Hi Srinivas

    Can you email me the code please?

    Thanks

    -Hemant

    ReplyDelete
  13. AnonymousMay 18, 2010 at 12:51 PM

    Hi Srinivas,

    This looks like a very useful tool, can you please send me the code to 'pgnath1@yahoo.com'

    ReplyDelete
  14. AnonymousJune 15, 2010 at 11:36 AM

    Hi Srinivas,
    Can you share the C++ code with me? plaese emmail me at rajeevsiebel at hotmail dot com

    Thanks,
    RS

    ReplyDelete
  15. UnknownAugust 10, 2010 at 10:30 PM

    Will you give training in obiee

    ReplyDelete
  16. Srinivas MalyalaAugust 11, 2010 at 12:00 AM

    @Pradeep

    Let me know if you need any help i will try to answer you.

    Thanks
    Srinivas

    ReplyDelete
  17. carsonJanuary 10, 2011 at 12:18 PM

    Could you please supply me with the c# version of purging OBIEE cache? That would be very helpful. Thanks.

    ReplyDelete

Please give me your feed back

Subscribe to: Post Comments (Atom)