Pentaho Analysis - Mondrian

• Type: Improvement
• Status: Open
• Priority: Medium
• Resolution: Unresolved
• Affects Version/s: 3.5.2 Suite Release
• Fix Version/s: Future Release
• Component/s: Native SQL
• Labels:

  None

An example would be this SQL issued for navigating a recursive parent/child hierarchy (captured from the Mondrian unit tests).

> select "employee"."employee_id" as "c0",
> "employee"."full_name" as "c1"
> from "employee" as "employee" where "employee"."supervisor_id" = 187
> group by "employee"."employee_id", "employee"."full_name" order by
> "employee"."employee_id" ASC

The same statement is executed repeatedly, with only the supervisor_id (187) varying. For some DBMS implementations, this can run a lot faster if a prepared statement is used. (For some, such as LucidDB, it doesn't even matter whether the statement is kept around inside of Mondrian; the DBMS can cache the plan even without a prepared statement staying around across executions.)

• Assignee:

  Unassigned User

  Reporter:

  John Sichi

• Created:

  07/Jun/10 7:57 PM

  Updated:

  10/Jun/10 8:07 AM