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.