Wednesday Apr 10, 2013

How to track MDX queries against Essbase

(in via Nancy)

Nancy pointed me at a newly created KM Doc that talks about MDX tracking unsurprisingly called:  Tracking MDX Queries Against an Essbase Database [ID 1543793.1].

This CFG setting is not yet fully documented, but may make it into the next documentation update.

MDX queries run against an Essbase application can be tracked by adding a line in the Essbase configuration file,
...\Oracle\Middleware\user_projects\epmsystem1\EssbaseServer\essbaseserver1\bin\essbase.cfg:

TRACE_MDX appname dbname 2

The appname and dbname refer to the specific application and database that you want to track.
Both are optional. Omit them if you want all applications tracked.

The MDX queries are dumped to a file named mdxtrace.log in ARBORPATH/appname/dbname folder,
i.e. /Oracle/Middleware/user_projects/epmsystem1/EssbaseServer/essbaseserver1/app/Sample/Basic

The log contains:

  • The time stamp at the time of completion of the query.
  • The elapsed time for the query
  • it does NOT contain the user who issued this statement - for that you would need to cross check in the Application log file

So for example, executing an MDX query against the Sample/Basic database, the mdxtrace.log contains:

===============================================================
Following MDX query executed at Mon Apr 08 08:56:13 2013
===============================================================
SELECT
{[100-10], [100-20]} ON COLUMNS,
{[Qtr1], [Qtr2], [Qtr3], [Qtr4]} ON ROWS
FROM Sample.Basic

=== MDX Query Elapsed Time : [0.009] seconds ===================

Please Note:

Only queries that were executed successfully are printed to file. Queries that end in error are not printed.

We hope that this can assist you in tuning your Database/MDX queries.

Monday Mar 11, 2013

ADVISOR WEBCASTS: EPM Log Hide and Seek with the PSD Team

As tracking down logfiles has become similarly difficult, Maurice has prepared two webcasts for our EPM customers, named after the childrens game "Hide and Seek".

EPM Log Hide and Seek (with Hyperion tools) March 21, 2013
EPM Log Hide and Seek (with generic Oracle tools) March 27, 2013


Both of these one-hour session are recommended for technical and functional users investigating EPM-related applications who need to find logs, process logs, analyze environments, access hidden values, and avoid wasting time by using tools written by Oracle developers. Attendees will watch the setup of Remote Diagnostic Agent, Enterprise Manager Fusion Middleware, Oracle Diagnostic Framework, and JRockit Mission Control.

TOPICS WILL INCLUDE:

  • Access "obscure" logs and use tools to slice and dice them
  • Identify the strengths and weaknesses of each instrumentation tool
  • Pinpoint resources you may cross-reference after forgetting this presentation!
  • Customize broad tools to target narrow issues


You can register for these free live Webcasts through My Oracle Support:
Choose which session interests you most or register for both:

EPM Log Hide and Seek (with Hyperion tools) March 21, 2013:
March 21, 2013 at
5:00 pm, Europe Time (Berlin, GMT+01:00)
4:00 pm, GMT Time (London, GMT)
12:00, Eastern Daylight Time (New York, GMT-04:00)
10:00, Mountain Daylight Time (Denver, GMT-06:00)

EPM Log Hide and Seek (with generic Oracle tools) March 27, 2013:
March 27, 2013 at
5:00 pm, Europe Time (Berlin, GMT+01:00)
4:00 pm, GMT Time (London, GMT)
12:00, Eastern Daylight Time (New York, GMT-04:00)
10:00, Mountain Daylight Time (Denver, GMT-06:00)

We hope to welcome you as one of the attendees.

You are unable to attend at the scheduled time?
No worries - all Advisor Webcasts are recorded and can be watched at a more convenient time.

But what about my questions?
All EPM Webcasts are now accompanied by a thread in the communities, so that you can get in touch with the presenter, even if you can not make it to the live event.

You did not find the webcast you were looking for?
You find more Webcasts and the recordings on the "Advisor Webcast current schedule" KM Doc.

About


This blog talks about the latest news and upcoming events initiated by the EPM/BI Proactive Support Team.

Authors:

italia.nowodworska@oracle.com
paul.anderson@oracle.com





Search

Archives
« April 2014
SunMonTueWedThuFriSat
  
3
5
6
9
12
13
15
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today