Skip to Content

h5. Introduction

Recently, I’ve had lots of people ask about how to segment the navigation pane or deal with lots of objects within the navigation pane? In this blog I describe options for working with the navigation pane in SAP NetWeaver 2004s BI. As per the GA Limitations located here: https://websmp208.sap-ag.de/~sapdownload/011000358700003437292006E/FunctEnhancSchedNW2004sB.ppt, there are planned improvements in SPS11 in this area, but this blog will discuss the options before these enhancements are available.

h5. Option 1 – Using the Tray Option

The first option is you can turn on the tray option within the Navigation Pane web item. This will create a tray icon to show or hide the navigation pane to buy you screen real estate. If you need to create 3 separate trays for collapse functionality, you can do this by creating a different navigation pane for each area (row, column, free characteristics). To put these objects next to each other, you can creae these separate navigation panes, but there is no way to filter to a more granular level than “row, column, or free characteristic”. Once this is done, they can be put side by side by using the “Container Layout” web item or by using html tables.

Collapsed (Side by Side):

image

Expanded (Side by Side):

image

image

The limitation of using this is you cannot embed the div tag within a “Container Layout” or “Container” web item. You must use html tables to control layout and formatting when using div scrolling.

h5. Summary

Hopefully these workarounds will help you work with navigation panes that have lots of characteristics and key figures.

To report this post you need to login first.

11 Comments

You must be Logged on to comment or reply to a post.

  1. Emmanuel Kouvaritakis
    Dear Sir,
    very nice this blog, but I have a question; Is there any tip how torun the nagigation pane web item and every ‘segment’ to start by default as closed?
    I mean I want to use one navigation pane fro all (free, columns & key figures) but every segment to start by default as closed. I don’t find any relarive property for this.

    Best Regards
    Manos Kouvaritakis

    (0) 
    1. Prakash Darji Post author
      If you’re talking about option 1 above, then in the web item properties for the navigation pane, when you turn the “TRAY” option on, you have the option to flag off the “EXPANDED” option which collapses these by default.

      If you are talking about the default expanded view within the navigation pane for each section, you can collapse these at runtime as save this report as a KM document and use that with however you have it saved.

      (0) 
      1. Emmanuel Kouvaritakis
        Thanks Prakash,
        I’m talking about the default expanded view within the navigation pane. I was sure about this solution. I don’t know if there is any solution on this by java script??

        Best Regards
        Manos

        (0) 
        1. Prakash Darji Post author
          There is a solution via javascript, but I wouldn’t recommend it, as it works post processing and the rendered source may change with SAP support packages. Here is an example of a javascript call to collapse the columns:

          sapbi_page.sendCommandArray([[‘BI_ADVANCED’,’NAVIGATION_PANE_acQueryNavigation_navTree’,0],[‘BI_COMMAND_TYPE’,’TREE_NODE_TOGGLE’,0],[‘TARGET_ITEM_REF’,’NAVIGATION_PANE’,0],[‘TREEID’,’NAVIGATION_PANE_acQueryNavigation_navTree_act’,0],[‘NODEID’,’NAVIGATION_PANE_acQueryNavigation_navTree_unid3′,0],[‘EVENT’,event,0]],event);

          If you want this to run onload, it will collapse everytime the page loads, so you’ll have to have a cookie or global variable that says not to do this on subsequent loads of the page.

          Prakash

          (0) 
  2. Jamie Hylton
    Has there been any further developments in this navigation pane area?  I was hoping by now there would be a similar option as to the Filter Area, where you can specify the scrolling as standard.

    Thanks.

    (0) 
    1. Prakash Darji Post author
      Hey James,

      I am no longer working in the NetWeaver RIG and haven’t been keeping up to date with some of the BEx tools, so I would post this question in the SDN forums to see if anyone has any thoughts or insights into what is new.

      Cheers,
      Prakash

      (0) 
  3. Andrei Grechko
    The javascript to automatically collapse the BEx Navigation Pane tree on load that you provided does not seem to work:

    sapbi_page.sendCommandArray([[‘BI_ADVANCED’,’NAVIGATION_PANE_acQueryNavigation_navTree’,0],[‘BI_COMMAND_TYPE’,’TREE_NODE_TOGGLE’,0],[‘TARGET_ITEM_REF’,’NAVIGATION_PANE’,0],[‘TREEID’,’NAVIGATION_PANE_acQueryNavigation_navTree_act’,0],[‘NODEID’,’NAVIGATION_PANE_acQueryNavigation_navTree_unid3′,0],[‘EVENT’,event,0]],event);

    Could you please verify the code and provide more details on where to include it? I was trying to include it as part of Web Template “Action Before First Display” area.

    Thanks!

    (0) 
  4. Geafar Narcis

    Hi,

    how do you get the scroll bars enabled? In 7.3 the navigation pane seem not to have such property and setting a small height does not enable them, somehow is forced a full display og navigation pane.

    Thank you,

    #N

    (0) 
    1. Geafar Narcis

      Hi,

      got it finally. You need to do it as mentioned at the end by inserting navigation pane in the div scrolling in the XHTML (<div style=”WIDTH: 200px; HEIGHT: 300px; OVERFLOW: auto” >). See example below.

      Cheers, N

                 <table border=”1″ width=”100%” height=”300″ >

                      <tbody >

                          <tr >

                              <td >

                                  <div style=”WIDTH: 200px; HEIGHT: 300px; OVERFLOW: auto” >

                                      <bi:NAVIGATION_PANE_ITEM name=”NAVIGATION_PANE_ITEM_1″ designwidth=”100″ designheight=”300″ >

                                          <bi:HEIGHT value=”300″ />

                                          <bi:INTERACTION_ALLOWED value=”X” />

                                          <bi:DATA_PROVIDER_REF value=”DP_1″ />

                                          <bi:NAV_CHARACTERISTIC_SEL type=”CHOICE” value=”ALL” />

                                      </bi:NAVIGATION_PANE_ITEM>

                                  </div>

                              </td>

                              <td >

                                  <bi:ANALYSIS_ITEM name=”ANALYSIS_ITEM_1″ designwidth=”400″ designheight=”300″ >

                                      <bi:HEIGHT value=”300″ />

                                      <bi:DATA_PROVIDER_REF value=”DP_1″ />

                                      <bi:DATA_ROW_TO value=”25″ />

                                      <bi:BLOCK_ROWS_SIZE value=”15″ />

                                  </bi:ANALYSIS_ITEM>

                              </td>

                          </tr>

                      </tbody>

                  </table>

      (0) 

Leave a Reply