Multi-level tabular dimensioning


  • I am dealing with a SQL table tabular datasource for a scorecard.  I understand how to define the datasource, it's dimensions and facts.  But it appears the dimesnions can only be 1 level.  I have 2 columns in my source SQL table called MetricCatergory with values like Operational, Financial, Workforce...  and another column called Metric with values like Response, Margin, $/Employee....    Each metric falls under a single catergory and I would like to create a multi-level dimension from the 2 columns.  I can see no way of doing this short of building a cube from the SQL table and using that as the source for the scorecard. 

    Thursday, January 31, 2008 7:15 PM