The following SQL view can be used to extract dimension information using SQL
1. DefaultDimensionView: for default dimension each dimension value is listed as a separate row. Hence, we might need multiple joins for one each dimension to get values in a columnar format.
2. DimensionAttributeValueCombination: For Ledger dimension. Each dimension would exist as a column in this view.
No comments:
Post a Comment