Display multiple dimensions in row and column headers (Olap Presentation)

Shane posted over 16 years ago

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?

6867

[Infragistics] Josh Smith posted over 16 years ago in reply to Shane

I don't think the grid supports what you're trying to do. You might want to consider simplifying the shape of your data source so that you have a one-to-one mapping between field headers and cell values. You could use multi-line field headers, or some other visual trick, to emulate the layout you've described.
Cancel
Reply

Cancel

Shane posted over 16 years ago in reply to [Infragistics] Josh Smith

The layout of the multiple field columns headers in the XamDataGrid > Layout and Behavior > Record Layout Customization example that you mention is what I am looking for, but the example has cell values for each field header displayed. My data on the other hand has one value that relates to to the combination of field headers. In my original post I showed the scenario where record header of "Division 1 - > Store 1" had 1 cell value per measure column, not a cell value for Division 1 and then an additional cell value for Store 1 under that division.

I can try to clarify if this still doesn't make sense. Also, can you create the same type of headers for each row as well? Here is a mock up of what I am trying do do with the record headers in black and white, and the actual cell values in a blue background

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

Thanks for any help.

Shane

6867

[Infragistics] Josh Smith posted over 16 years ago

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
Cancel
Reply

Cancel