RE: Create Aggregate Dimension for DefaultDimension
It should work like any other aggregate dimension relationship. For the aggregate dimension you need a view that shows information about financial dimensions. You then create an aggregate dimension on that view and link it to your measure group by creating a relationship between the defaultdimenion column in the measure group and a matching value I the dimension view.
For the dimension try querying DefaultDimensionView to make sure it include info on the dimension you are interested in. If it does, then add a aggregate dimension using DefaultDimensionView as the value for the Table property and use DefaultDimension as the key attribute. Add attributes for any other columns that look useful for your case. measure group.
In the measure group add a new dimension and pick the dimension for Defaultdmensionview. For the relationship, pick the attribute for DefaultDimesion for the dimension attribute and match it up to the DefaultDimension column in the measure group.
If you don't have DefaultDimensionView or it does not have what you need, then define a new view. You'll need include DimensionAttributeValueSetItem, DimensionAttributeValueSet and DimensionAttributeValue tables. DefaultDimension value match to recId values from DimensionAttributeValueSet. See the table relationships for DimensionattributeValueSetItem for how to join them together.
Hope this helps.
