Skip to Content
0
Former Member
Feb 29, 2012 at 11:48 PM

Custom Hierarchy with Calculated levels - not working

36 Views

Hello experts,

My environment is BOE Server and client 4.0 JCO connection to 7.01.08 BW server. Business Objects patch level 2.11.

I have created a custom Hierarchy using the custom navigation path in the business layer of my relational universe. two of the dimensions I am using (Week and Month) are derived using functions of a date dimension. i.e. Month(date_field) and Week(date_field) Every time I try to use drill down in a WEBi report on this navigation path it errors out with the following:

Database Error: [Data Federator Driver] [Server] The optimizer failed to produce an executable plan. Internal Message: 'Query cannot be optimized: Optimizer Exception'' (IES 10901) (WIS 10901).

If I remove the two dimensions my drill down works fine. Is this a known issue or expected behavior? Are calculated levels of a custom hierarchy not allowed?

I appreciate your help with this.

Nancy