Skip to Content
0
Former Member
Dec 04, 2008 at 10:28 AM

how to expand a hierarchy using command wizard in web application designer?

41 Views

Hi @all,

I try to expand a hierarchy in web application designer (NW2004s) by using the command wizard.

The webtemplate contains one query (DP_1), which should show a table with various key figures in columns and a hierarchical dimension called "Local Product Group" down on the left side (in column 1). The hierarchy has the name "GRR" and should be expanded to level 3 as initial state. This happens as expected. But if the report is executed in the Internet Explorer, I can't collapse or expand the hierarchy nodes. If I click a node, nothing happens. Also if I try to use the context menu to expand a node to a certain level, nothing happens.

Does anybody has an idea and can help me? Thanks a lot for your suggestions.

Here comes the xhtml code:

            <bi:QUERY_VIEW_DATA_PROVIDER name="DP_1" >
                <bi:INITIAL_STATE type="CHOICE" value="QUERY" >
                    <bi:QUERY value="DE_CODEM001_0003" text="DE_CODEM001_0003" />
                </bi:INITIAL_STATE>
            </bi:QUERY_VIEW_DATA_PROVIDER>
            <p >
                <bi:TEMPLATE_PARAMETERS name="TEMPLATE_PARAMETERS" >
                    <bi:WARNINGS_VISIBLE value="" />
                    <bi:INFORMATION_VISIBLE value="" />
                    <bi:SYSTEM_MESSAGES_VISIBLE type="CHOICE" value="" />
                    <bi:VARIABLE_SCREEN value="" />
                    <bi:USE_SPECIFIC_VARIANT_CATALOG value="" />
                    <bi:HAS_MAIN_TEMPLATE_OBJECT type="CHOICE" value="" text="" />
                    <bi:WEB_TEMPLATE_ACTIONS type="COMPOSITE" >
                        <bi:ACTION_BEFORE_RENDERING type="COMPOSITE" >
                            <bi:INSTRUCTION >
                                <bi:REMOVE_DRILL_DOWN >
                                    <bi:TARGET_DATA_PROVIDER_REF_LIST type="ORDEREDLIST" >
                                        <bi:TARGET_DATA_PROVIDER_REF index="1" value="DP_1" />
                                    </bi:TARGET_DATA_PROVIDER_REF_LIST>
                                    <bi:CHARACTERISTIC value="4C0YUCEZ5Q3XPB8YH3TJJUI0H" text="Key Figures" />
                                </bi:REMOVE_DRILL_DOWN>
                                <bi:SET_SELECTION_STATE_SIMPLE >
                                    <bi:TARGET_DATA_PROVIDER_REF_LIST type="ORDEREDLIST" >
                                        <bi:TARGET_DATA_PROVIDER_REF index="1" value="DP_1" />
                                    </bi:TARGET_DATA_PROVIDER_REF_LIST>
                                    <bi:CHARACTERISTIC value="4C0YUCEZ5Q3XPB8YH3TJJUI0H" text="Key Figures" />
                                    <bi:RANGE_SELECTION_OPERATOR type="CHOICE" value="EQUAL_SELECTION" >
                                        <bi:EQUAL_SELECTION type="CHOICE" value="MEMBER_NAME" >
                                            <bi:MEMBER_NAME value="4C0YUG1K42CZHYFL8AXCARW6P" text="Formula 3" />
                                        </bi:EQUAL_SELECTION>
                                    </bi:RANGE_SELECTION_OPERATOR>
                                </bi:SET_SELECTION_STATE_SIMPLE>
                                <bi:SET_DATA_CELL_PROPERITES >
                                    <bi:TARGET_DATA_PROVIDER_REF_LIST type="ORDEREDLIST" >
                                        <bi:TARGET_DATA_PROVIDER_REF index="1" value="DP_1" />
                                    </bi:TARGET_DATA_PROVIDER_REF_LIST>
                                    <bi:DATA_CELL type="UNORDEREDLIST" >
                                        <bi:CHARACTERISTIC_MEMBER type="COMPOSITE" index="1" />
                                    </bi:DATA_CELL>
                                    <bi:DECIMAL_PLACES value="0" />
                                </bi:SET_DATA_CELL_PROPERITES>
                                <bi:SET_AXIS_HIERARCHY >
                                    <bi:TARGET_DATA_PROVIDER_REF_LIST type="ORDEREDLIST" >
                                        <bi:TARGET_DATA_PROVIDER_REF index="1" value="DP_1" />
                                    </bi:TARGET_DATA_PROVIDER_REF_LIST>
                                    <bi:DRILL_AXIS value="ROWS" />
                                    <bi:ACTIVE value="X" />
                                    <bi:DESCRIPTION value="" />
                                    <bi:INITIAL_DRILL_LEVEL value="3" />
                                </bi:SET_AXIS_HIERARCHY>
                                <bi:SET_HIERARCHY >
                                    <bi:TARGET_DATA_PROVIDER_REF_LIST type="ORDEREDLIST" >
                                        <bi:TARGET_DATA_PROVIDER_REF index="1" value="DP_1" />
                                    </bi:TARGET_DATA_PROVIDER_REF_LIST>
                                    <bi:CHARACTERISTIC value="XXCH00011" text="Local Product Group" />
                                    <bi:ACTIVE value="X" />
                                    <bi:HIERARCHY_ID type="COMPOSITE" >
                                        <bi:HIERARCHY_NAME value="GRR" text="GRR" />
                                        <bi:VERSION value="" />
                                        <bi:DUEDATE value="" />
                                    </bi:HIERARCHY_ID>
                                    <bi:INITIAL_DRILL_LEVEL value="3" />
                                </bi:SET_HIERARCHY>
                                <bi:DRILL_DOWN >
                                    <bi:TARGET_DATA_PROVIDER_REF_LIST type="ORDEREDLIST" >
                                        <bi:TARGET_DATA_PROVIDER_REF index="1" value="DP_1" />
                                    </bi:TARGET_DATA_PROVIDER_REF_LIST>
                                    <bi:CHARACTERISTIC value="XXCH00011" text="Local Product Group" />
                                    <bi:AXIS_POSITION type="CHOICE" value="CHARACTERISTIC" >
                                        <bi:CHARACTERISTIC value="XXCH00011" text="Local Product Group" />
                                    </bi:AXIS_POSITION>
                                </bi:DRILL_DOWN>
                            </bi:INSTRUCTION>
                        </bi:ACTION_BEFORE_RENDERING>
                        <bi:ACTION_BEFORE_FIRST_RENDERING type="COMPOSITE" />
                    </bi:WEB_TEMPLATE_ACTIONS>
                </bi:TEMPLATE_PARAMETERS>