Create Data Model In OBIEE Publisher

· Select new from home page and select data model.

· From left hand side select data sets.

· From diagram tab, click on new data set select aql query.

· Provide name sales_data and select gcbc_sales as data source.

· Click on query builder.

· From left hand side you can select products, sales, times, stores_ragged.

· Now select following columns from corresponding tables. Products.Prod_Name, products.Prod_type_desc, Products.perishable_YN, Products.prod_cat_desc. times.month_desc, stores_ragged.store_name. stores_ragged.region_name.

sales.fcast_sal_amy, sales.fcast_rev_amt

sales.fcast_cost_amt.

· Join the columns as following: products.prod_id=sales.prod_id

products.prod_id=sales.store_id

stores_ragged.store_pk=sales.store_id

sales.month_yyyymm=times.month_yyyymm

· Select the conditions option and enter the following condition for STORENAME is not null.

· Tick the group by tick box for following columns:

Products.Prod_Name, products.Prod_type_desc, Products.perishable_YN, Products.prod_cat_desc. times.month_desc, stores_ragged.store_name. stores_ragged.region_name.

sales.fcast_sal_amt,

sales.fcast_rev_amt

sales.fcast_cost_amt

· Press on save.

· Click on OK

· In structure tab you can rename the columns from Business view.

· Go back to diagram from view actions --> Add element by express.

 

· Click on OK.

· Save it into my folders/BIPub as products data model.