Oracle Demantra Basics

 How I learnt Oracle Demantra Basics

What it Does?

• Real Time sales & Operation Planning 
• Causal analysis, Seasonal & cyclic events, trend analysis

Demantra tables

 Staging Tables

select * from t_src_item_tmpl;

select * from t_src_sales_tmpl;

select  * from t_src_loc_tmpl;

Base tables

select * from sales_data;--sales order historical data

select * from mdp_matrix;--combination data

select * from inputs;--time buckets

select * from queries;--worksheets

select * from items;--items

Select * from t_ep_item;

select * from location;--locations

Integration interface

select * from transfer_query;

Patch

select * from version_details_history;

Workflow

select * from wf_schemas;

select * from wf_process_log;

Select * from group_tables;