#7 execution of MDX query throws OutOfMemoryError

closed
nobody
None
5
2008-03-17
2005-09-15
Anonymous
No

The execution of MDX query which is generated
automatically throws OutOfMemoryException after a few
minutes of work.

MDX query:

with member [Workunit Status].[All WU
Statuses].[PL&AC&CO] as 'Aggregate({[Workunit
Status].[All WU Statuses].[PL], [Workunit Status].[All
WU Statuses].[AC], [Workunit Status].[All WU
Statuses].[CO]})'

member [Resource Category].[All Resource
Categories].[P].[PFE&PIK&PSI&PSL&PPA&POM] as
'Aggregate({[Resource Category].[All Resource
Categories].[P].[PFE], [Resource Category].[All
Resource Categories].[P].[PIK], [Resource
Category].[All Resource Categories].[P].[PSI],
[Resource Category].[All Resource
Categories].[P].[PSL], [Resource Category].[All
Resource Categories].[P].[PPA], [Resource
Category].[All Resource Categories].[P].[POM]})'
select NON EMPTY Hierarchize(Union({[Workunit
Description].[All WU descriptions]}, [Workunit
Description].[All WU descriptions].Children)) ON columns,
NON EMPTY Hierarchize(Union({[Person Name].[All
Persons]}, [Person Name].[All Persons].Children)) ON rows
from [Resources]
where ([Measures].[FTE], [Workunit Status].[All WU
Statuses].[PL&AC&CO], [Project].[All Projects].[APT],
[Time].[All Years].[2006], [Org (Per)].[All
Orgs].[CERN].[IT].[IT-AIS], [Org (Res)].[All
Orgs].[CERN].[IT].[IT-AIS], [Resource Category].[All
Resource Categories].[P].[PFE&PIK&PSI&PSL&PPA&POM],
[WBS].[All WBS].[CERN-PPA])

It should return a maximum of 100 rows but
unfortunately the used dimensions: Person Name and
Workunit Description are quite big: 7447 and 2902
respectively. It is a problem for JPivot/Mondrian I
suppose although the returned rowset contains just a
very small subset from this huge space of dimension values.

Discussion

  • Andreas Voss
    Andreas Voss
    2008-03-17

    • status: open --> closed