Skip to Content
author's profile photo Former Member
Former Member

Scheduling a CR report with BW Hierarchy node variable in a publication, the list is flattened


System: BOBJ 3.1 SP5

BW: BI 7.3 SPS 7

Crystal reports: 2008 (

We are attempting to schedule a few CR reports together in a publication. These CR Reports are based on Bex Queries with a Hierarchy Node Variable and the reports are set to SSO in the database configuration.

When scheduling the reports individually, the parameter pick list for the hierarchy node variable appears as it should be, with expandable and collapsible levels.

However when scheduling a publication with the same CR report, the pick list of the hierarchy is flattened.

We have tried hard coding the database logon and password and this also does not bring the hierarchical pick list.

Is there a configuration or step we may have missed?



Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Posted on Jul 26, 2012 at 11:59 PM

    Hi Nick,

    When scheduling or viewing reports (against an SAP datasource) on the BusinessObjects Enterprise, the default prompt screen is Not used. Instead the SAP style prompting page is used and this is what enables the hierarchies to be rendered properly.

    Unfortunately, the same functionality is not available when Scheduling the reports.

    This looks like a missing functionality, however a 'Bug' request has already been submitted to Product Group. Here's the ID for your reference: ADAPT01503977.

    It was scheduled to be fixed in SP5, however the request is still 'Open', meaning it has not been fixed in SP5. And, I see that you're already on SP5.

    We do not have a workaround at this point in time. We'll have to wait until a fix is available.

    Hope this helps!

    - Abhilash

    Follow us on Twitter

    Got Enhancement ideas? Try the SAP Idea Place

    Share Your Knowledge in SCN Topic Spaces

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.