✍ Kashif M
Trends

Saturday, 21 June 2014


Create Data Model In OBIEE Publisher


By on June 21, 2014



· 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.

Kashif
mkashu: Create Data Model In OBIEE Publisher
Review : Kashif | Kashif
Update: June 21, 2014 | Rating: 4.5

Comment for "Create Data Model In OBIEE Publisher"

0 comments

Post a Comment

Blog Archive