2 Replies Latest reply: Mar 2, 2012 4:29 PM by Nancy Cobaxin RSS

Custom Hierarchy with Calculated levels - not working

Nancy Cobaxin
Currently Being Moderated

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.