Forums Ultimate UI for WPF
Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
Close
Shane
50
Display multiple dimensions in row and column headers (Olap Presentation)
posted

I have a cube that I am quering for CellSets and I would like to display the data in the Grid. I will limit the number of Axes returned by the CellSet to 2 so the grid can display it in tabular format, but I would like to know if it is possible to show the hierarchical structure of the of the selected dimension members in the row and header column as follows:

Gross Sales/Cover Count Weekly Summary By Organization 

 

 Number of Covers Gross Sales
Week to Date Week to Date
Division 1 Store 1

50

5657

Store 2

45

2342345

Store 3

66

656

Division 2 Store 1

74

23454

Division 3 Store 1

226

23234

Division 4 Store 1

76

2342

Division 5 Store 1

45

123245

Division 6 Store 1

78

15664

 Each Division/Store combination represents a unique value in the row for each unique Number of Covers/Week to date and Gross Sales/Week to date combination.  Its seems like you can do something similar to what I'm looking for using the record headers of the xamGrid, but it assumes that each piece of the header has a corresponding field value.  In my case, I need to combine multiple headers to represent one field.  I'd like to do this in the format that I show above if possible.  Can this be done?
Parents
  • 6867
    posted

    You can put multiple field headers in one column.  The xamFeatureBrowser application, which is installed when you install NetAdvantage for WPF, has a demo of this.  Under XamDataGrid > Layout and Behavior > Record Layout Customization

    The grid in that demo is declared as:

    <igDP:XamDataGrid Grid.Row="1" x:Name="XamDataGrid1" DataSource="{Binding Source={StaticResource QuarterbackData}, XPath=season}">
          <igDP:XamDataGrid.FieldLayoutSettings>
            <igDP:FieldLayoutSettings AutoArrangeCells="Never" AutoGenerateFields="False"/>
          </igDP:XamDataGrid.FieldLayoutSettings>
          <igDP:XamDataGrid.FieldLayouts>
            <igDP:FieldLayout>
              <igDP:FieldLayout.Fields>
                <igDP:Field  Name="team" Label="Team" Row="0" Column="0" ColumnSpan="5" />
                <igDP:Field  Name="games" Label="Games Played" Row="1" Column="0"/>
                <igDP:Field  Name="qbrate" Label="Rating" Row="1" Column="1"/>
                <igDP:Field  Name="comp" Label="Completions" Row="1" Column="2"/>
                <igDP:Field  Name="att" Label="Attempts" Row="1" Column="3"/>
                <igDP:Field  Name="pct" Label="Passing %"  Row="1" Column="4"/>
                <igDP:Field  Name="passingyards" Label="Total Passing Yards" Row="2" Column="0" />
                <igDP:Field  Name="passingyardsperattempt" Label="Passing Yards/Attempt" Row="2" Column="1" />
                <igDP:Field  Name="passingyardspergame" Label="Passing Yards/Game" Row="2" Column="2" />
                <igDP:Field  Name="passingtd" Label="Passing Touchdowns" Row="2" Column="3" />
                <igDP:Field  Name="int" Label="Interceptions" Row="2" Column="4" />
                <igDP:Field  Name="rushs" Label="Rushes" Row="3" Column="0" />
                <igDP:Field  Name="rushyrds" Label="Rushing Yards" Row="3" Column="1" />
                <igDP:Field  Name="rushyardspergame" Label="Rushing Yard/Game" Row="3" Column="2" />
                <igDP:Field  Name="rushavg" Label="Rushing Average" Row="3" Column="3" />
                <igDP:Field  Name="rushtd" Label="Rushing Touchdowns" Row="3" Column="4" />
                <igDP:Field  Name="sack" Label="Sacks" Row="4" Column="0" />
                <igDP:Field  Name="yardslost" Label="Yards Lost" Row="4" Column="1" />
                <igDP:Field  Name="fum" Label="Fumbles" Row="4" Column="2" />
                <igDP:Field  Name="fuml" Label="Fumbles Lost"  Row="4" Column="3" />
              </igDP:FieldLayout.Fields>
            </igDP:FieldLayout>
          </igDP:XamDataGrid.FieldLayouts>
        </igDP:XamDataGrid>

    Josh

Reply Children