· 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.
Comments
Post a Comment