Technologies
- Popular Resources
  
  White Paper
  
  .NET Workflow Solutions for SharePoint
  
  Workflows are available within Microsoft SharePoint, and help users track and monitor documents or files associated with a specific business process.
  
  White Paper
  
  10 Reasons You Need Half a DBA
  
  Nearly all companies need database administrators– but not all companies need a full time DBA. Sometimes you might need “half a DBA.” Sometimes it’s for a one-time need, such as during a transition to a new platform or a surge in overflow work.
  
  Service Overview
  
  360-degree Hyperion Support Overview
  
  Every organization has unique needs, which is why we offer 360-degree Hyperion support tailored to what will help your organization to improve the most.
  
  Webinars
  
  5 Reasons to Choose a Managed Services Approach to Database Administration
  
  Datavail commissioned Forrester Consulting to evaluate the viability of a managed service approach to database administration. With the explosion in the variety, velocity and volume of data and databases, coupled with the scarcity of DBA talent, the time is right to consider an alternative approach to managing databases. Forrester Consulting conducted the survey of executives in mid to large enterprises who are using managed services to augment their in-house DBA.
- CLOSE MENU

Resources
- Popular Resources
  
  White Paper
  
  .NET Workflow Solutions for SharePoint
  
  Workflows are available within Microsoft SharePoint, and help users track and monitor documents or files associated with a specific business process.
  
  White Paper
  
  10 Reasons You Need Half a DBA
  
  Nearly all companies need database administrators– but not all companies need a full time DBA. Sometimes you might need “half a DBA.” Sometimes it’s for a one-time need, such as during a transition to a new platform or a surge in overflow work.
  
  Service Overview
  
  360-degree Hyperion Support Overview
  
  Every organization has unique needs, which is why we offer 360-degree Hyperion support tailored to what will help your organization to improve the most.
  
  Webinars
  
  5 Reasons to Choose a Managed Services Approach to Database Administration
  
  Datavail commissioned Forrester Consulting to evaluate the viability of a managed service approach to database administration. With the explosion in the variety, velocity and volume of data and databases, coupled with the scarcity of DBA talent, the time is right to consider an alternative approach to managing databases. Forrester Consulting conducted the survey of executives in mid to large enterprises who are using managed services to augment their in-house DBA.
- CLOSE MENU

Blog
- Popular Resources
  
  White Paper
  
  .NET Workflow Solutions for SharePoint
  
  Workflows are available within Microsoft SharePoint, and help users track and monitor documents or files associated with a specific business process.
  
  White Paper
  
  10 Reasons You Need Half a DBA
  
  Nearly all companies need database administrators– but not all companies need a full time DBA. Sometimes you might need “half a DBA.” Sometimes it’s for a one-time need, such as during a transition to a new platform or a surge in overflow work.
  
  Service Overview
  
  360-degree Hyperion Support Overview
  
  Every organization has unique needs, which is why we offer 360-degree Hyperion support tailored to what will help your organization to improve the most.
  
  Webinars
  
  5 Reasons to Choose a Managed Services Approach to Database Administration
  
  Datavail commissioned Forrester Consulting to evaluate the viability of a managed service approach to database administration. With the explosion in the variety, velocity and volume of data and databases, coupled with the scarcity of DBA talent, the time is right to consider an alternative approach to managing databases. Forrester Consulting conducted the survey of executives in mid to large enterprises who are using managed services to augment their in-house DBA.
- CLOSE MENU

About Us
- Popular Resources
  
  White Paper
  
  .NET Workflow Solutions for SharePoint
  
  Workflows are available within Microsoft SharePoint, and help users track and monitor documents or files associated with a specific business process.
  
  White Paper
  
  10 Reasons You Need Half a DBA
  
  Nearly all companies need database administrators– but not all companies need a full time DBA. Sometimes you might need “half a DBA.” Sometimes it’s for a one-time need, such as during a transition to a new platform or a surge in overflow work.
  
  Service Overview
  
  360-degree Hyperion Support Overview
  
  Every organization has unique needs, which is why we offer 360-degree Hyperion support tailored to what will help your organization to improve the most.
  
  Webinars
  
  5 Reasons to Choose a Managed Services Approach to Database Administration
  
  Datavail commissioned Forrester Consulting to evaluate the viability of a managed service approach to database administration. With the explosion in the variety, velocity and volume of data and databases, coupled with the scarcity of DBA talent, the time is right to consider an alternative approach to managing databases. Forrester Consulting conducted the survey of executives in mid to large enterprises who are using managed services to augment their in-house DBA.
- CLOSE MENU

Select Page

Art of BI: Clearing BIServer Cache Using Analysis Request

Christian Screen | | July 29, 2011

I had a question the other day from a client about clearing the Oracle BI Server cache.

I had recently saw this post talking about using a very basic connection pool and direct database request to call one of the BI Server procedures, SAPurgeAllCache(), and saving this as an Analysis request that could then be scheduled as an Agent.

Ultimately the code in the SQL Statement for the database request is, Call SAPurgeAllCache().

This is very helfpul. Props to Srini!

Update 2011/07/30

We’ve see this logic in other places like here and Gerard’s full explanation of the ODBC-functions here but this was a great reason for me to post this topic as I ran across it Srini’s blog by accident.

Blog Author

Christian Screen

Christian is an innovator in analytics and data warehousing design, best practices, and delivery. With more than fifteenyears of decision support and data warehousing with key experiences at Office Depot HQ, Sierra-Cedar, and Capgemini, he oversees the Oracle Analytics Practice which includes the technical development and delivery of Oracle BI collaboration software, data warehouse solutions, Oracle BI/EPM projects, and packaged analytics solutions at Datavail.

Popular Posts

This blog post outlines steps to take on Oracle upgrade 11.2 to 12.1 if you’re having performance problems. Oracle offers a patch and work around to BUG 20540751.

Megan Elphingstone | March 22, 2017

EPM applications help measure the business performance. This post will help you choose the best EPM solutions for your organization’s needs and objectives.

Bobby Ellis | April 10, 2018

AWS EC2 RDS

Ready to migrate your MySQL database to Amazon Web Services (AWS)? Which is better, Amazon RDS or Amazon EC2? Learn the pros and cons of each option.

Charleste King | September 7, 2017

Work with Us

Let’s have a conversation about what you need to succeed and how we can help get you there.

Work for Us

Where do you want to take your career? Explore exciting opportunities to join our team.