oracle biee 11g 500 错误,BIEE 11gError Codes: OPR4ONWY: U9IM8TAC: OI2DL65P HY000.&nbs

n Oracle Business Intelligence 11g when you create reports

using the 11-or more dimensions or columns from different levels of

Essbase database error:

Error Codes: OPR4ONWY: U9IM8TAC:

OI2DL65P

State:

HY000.Code:

10058.[NQODBC] [SQL_STATE: HY000]

[nQSError: 10058] A general error has

occurred.[NQSError: 43113]

Message returned from OBIS.[NQSError: 43119] Query Failed: [nQSError: 42015] Cannot

function ship the following expression: AggrExternal

(.....

Problemma in the study found that the case in the

repository, in the parameter base physical level

MAX_COLUMNS_IN_GROUP_BY

(Features).Through experiment, it

was determined that the Oracle BI 11g Analytic Server in the query

uses 3 column gruppiroke the level of measurement,

ieto query the Essbase built without

errors is necessary to calculate the value of the formula

"MAX_COLUMNS_IN_GROUP_BY = number of levels of measurement X

3".

To change the setting, open the repository in Oracle BI

Administration Tool and go to properties (Properties) database on

the physical level.

Click the Features and setting MAX_COLUMNS_IN_GROUP_BY

Increase from 32 to sufficient, for example, up to 90.

If the reader of this note, or other niceties known problemma

combination BI 11g + Essbase propose to discuss in the

forum.