OBIEE - Multi level hierarchy into single column

[Deleted User]

I still don't see how that is NOT just a hierarchical column and a measure next to it...

User_1ZD2F

I agree, it is hierarchical column but user doesn't want to open each level. When report runs default all level should populate as shown above.

[Deleted User]

How does that have any bearing on anything? If you open all the levels of a hierarchical column when BUILDING the analysis in Answers, then that STATE will be saved in the analysis definition and always rendered like that!

The tool is around since some time so it actually know a thing or two and isn't the dumb "list reporting" tool most people use it as...

It's all in the XML definition. Insisting on "different" approaches rather than using things as they are designed just wastes time and resources and pointlessly creates error sources and things you need to maintain and administer without any added value.

<saw:report xmlns:saw="com.siebel.analytics.web/report/v1.1" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlVersion="201201160" xmlns:sawx="com.siebel.analytics.web/expression/v1.1">

   <saw:criteria xsi:type="saw:simpleCriteria" subjectArea="&quot;PC2&quot;">

      <saw:columns>

         <saw:column xsi:type="saw:hierarchicalColumn" hierarchyID="Segments" tableName="&quot;Customers&quot;" dimensionID="Customers" columnID="c7ccf64c77fb2dbe7">

            <saw:hierarchyLevels>

               <saw:hierarchyLevel levelID="Total"/>

               <saw:hierarchyLevel levelID="Cust Segment"/>

               <saw:hierarchyLevel levelID="Detail"/></saw:hierarchyLevels></saw:column></saw:columns></saw:criteria>

   <saw:views currentView="0">

      <saw:view xsi:type="saw:compoundView" name="compoundView!1">

         <saw:cvTable>

            <saw:cvRow>

               <saw:cvCell viewName="titleView!1"/></saw:cvRow>

            <saw:cvRow>

               <saw:cvCell viewName="pivotTableView!1"/></saw:cvRow></saw:cvTable></saw:view>

      <saw:view xsi:type="saw:titleView" name="titleView!1"/>

      <saw:view xsi:type="saw:pivotTableView" name="pivotTableView!1" scrollingEnabled="false" rowsPerPage="50000">

         <saw:edges>

            <saw:edge axis="page" showColumnHeader="true"/>

            <saw:edge axis="section"/>

            <saw:edge axis="row" showColumnHeader="true">

               <saw:edgeLayers>

                  <saw:edgeLayer type="column" columnID="c7ccf64c77fb2dbe7">

                     <saw:drillState>

                        <saw:drillStep drillType="down">

                           <saw:QDR>

                              <saw:staticMemberGroup>

                                 <saw:groupType>

                                    <sawx:columnRefExpr columnID="c7ccf64c77fb2dbe7"/></saw:groupType>

                                 <saw:hierarchyMembers>

                                    <saw:hierarchyLevelMembers>

                                       <saw:hierarchyLevel levelID="Total"/>

                                       <saw:members xsi:type="saw:integerMembers">

                                          <saw:value>1</saw:value></saw:members></saw:hierarchyLevelMembers></saw:hierarchyMembers></saw:staticMemberGroup>

                              <saw:target>

                                 <sawx:columnRefExpr columnID="c7ccf64c77fb2dbe7"/></saw:target></saw:QDR>

                           <saw:selectionGroups>

                              <saw:selectionGroup columnID="c7ccf64c77fb2dbe7" groupID="0"/></saw:selectionGroups></saw:drillStep></saw:drillState></saw:edgeLayer></saw:edgeLayers></saw:edge>

            <saw:edge axis="column" showColumnHeader="rollover"/></saw:edges>

         <saw:displayFormat>

            <saw:formatSpec/></saw:displayFormat></saw:view></saw:views></saw:report>

Edit: not sure how that picture ended up inside the code