Improve support to mondrian schema : view as sql code

[GoogleCodeExporter]

What steps will reproduce the problem?
Power-architect will be a very good mondrian schema designer when we can 
create, and manage view 

as that

<Dimension name="ProductFood" primaryKey="product_id" primaryKeyTable="product">

                      <Hierarchy hasAll="true" allMemberName="All Products" primaryKey="product_id">

                        <View alias="Product">

                          <SQL dialect="generic">

                            select 

                                  pc.product_family as product_family,

                                  p.product_id as product_id,

                                  p.product_name as product_name,

                                  p.brand_name as brand_name,

                                  pc.product_subcategory as product_subcategory,

                                  pc.product_category as product_category,

                                  pc.product_department as product_department

                            from 

                                  product as p, product_class as pc

                            where 

                                  p.product_class_id = pc.product_class_id

                                  and pc.product_family = 'food'
                          </SQL>

                        </View>

                        <Level name="Product Family" column="product_family" uniqueMembers="false"/>

                        <Level name="Product Department" column="product_department" uniqueMembers="false"/>

                        <Level name="Product Category" column="product_category" uniqueMembers="false"/>

                        <Level name="Product Subcategory" column="product_subcategory" uniqueMembers="false"/>

                        <Level name="Brand Name" column="brand_name" uniqueMembers="false"/>

                        <Level name="Product Name" column="product_name" uniqueMembers="true"/>

                      </Hierarchy>

                    </Dimension>

Original issue reported on code.google.com by [email protected] on 22 Aug 2010 at 9:36