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.
Microsoft is conducting an online survey to understand your opinion of the Technet Web site. If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.