PACKAGE: OLAPSYS.CWM2_OLAP_TABLE_MAP

Source

1 package cwm2_olap_table_map as
2 
3 procedure       Add_AWView(p_View_owner varchar2,
4                            p_view_name varchar2,
5                            p_rowtocell_col_name varchar2 default null,
6                            p_awowner varchar2 default null,
7                            p_awname varchar2 default null);
8 
9 procedure       Remove_AWView(p_View_owner varchar2,
10                            p_view_name varchar2);
11 
12 procedure map_awview_column(p_view_owner varchar2, p_view_name varchar2,
13                             p_column varchar2,
14                             p_awobject varchar2);
15 
16 procedure       Map_FactTbl_LevelKey(p_Cube_Owner varchar2,
17                                      p_Cube_Name varchar2,
18                                      p_Facttable_Owner varchar2,
19                                      p_Facttable_Name varchar2,
20                                      p_Storetype varchar2,
21                                      p_Dimkeymap varchar2,
22                                      p_Dimktype varchar2 default null);
23 
24 procedure RemoveMap_FactTbl_LevelKey(p_Cube_Owner varchar2,
25                                      p_Cube_Name varchar2,
26                                      p_Facttable_Owner varchar2,
27                                      p_Facttable_Name varchar2);
28 
29 procedure       Map_FactTbl_Measure(p_Cube_Owner varchar2,
30                                     p_Cube_Name varchar2,
31                                     p_Measure_Name varchar2,
32                                     p_Facttable_Owner varchar2,
33                                     p_Facttable_Name varchar2,
34                                     p_Column_Name varchar2,
35                                     p_Dimkeymap varchar2);
36 
37 procedure RemoveMap_FactTbl_Measure(p_Cube_Owner varchar2,
38                                     p_Cube_Name varchar2,
39                                     p_Measure_Name varchar2,
40                                     p_Facttable_Owner varchar2,
41                                     p_Facttable_Name varchar2,
42                                     p_Column_Name varchar2,
43                                     p_Dimkeymap varchar2);
44 
45 procedure       Map_DimTbl_HierLevel(p_Dimension_Owner varchar2,
46                                      p_Dimension_Name varchar2,
47                                      p_Hierarchy_Name varchar2,
48                                      p_Level_Name varchar2,
49                                      p_Table_Owner varchar2,
50                                      p_Table_Name varchar2,
51                                      P_KeyCol varchar2,
52                                      P_ParentCol varchar2 default null);
53 
54 procedure RemoveMap_DimTbl_HierLevel(p_Dimension_Owner varchar2,
55                                      p_Dimension_Name varchar2,
56                                      p_Hierarchy_Name varchar2,
57                                      p_Level_Name varchar2);
58 
59 procedure       Map_DimTbl_HierLevelAttr(p_Dimension_Owner varchar2,
60                                          p_Dimension_Name varchar2,
61                                          p_Dimension_Attribute_Name varchar2,
62                                          p_Hierarchy_Name varchar2,
63                                          p_Level_Name varchar2,
64                                          p_Level_Attribute_Name varchar2,
65                                          p_Table_Owner varchar2,
66                                          p_Table_Name varchar2,
67                                          p_AttrCol varchar2);
68 
69 procedure RemoveMap_DimTbl_HierLevelAttr(p_Dimension_Owner varchar2,
70                                          p_Dimension_Name varchar2,
71                                          p_Dimension_Attribute_Name varchar2,
72                                          p_Hierarchy_Name varchar2,
73                                          p_Level_Name varchar2,
74                                          p_Level_Attribute_Name varchar2);
75 
76 procedure       Map_DimTbl_Level(p_Dimension_Owner varchar2,
77                                  p_Dimension_Name varchar2,
78                                  p_Level_Name varchar2,
79                                  p_Table_Owner varchar2,
80                                  p_Table_Name varchar2,
81                                  p_KeyCol varchar2);
82 
83 procedure RemoveMap_DimTbl_Level(p_Dimension_Owner varchar2,
84                                  p_Dimension_Name varchar2,
85                                  p_Level_Name varchar2);
86 
87 procedure       Map_DimTbl_LevelAttr(p_Dimension_Owner varchar2,
88                                      p_Dimension_Name varchar2,
89                                      p_Dimension_Attribute_Name varchar2,
90                                      p_Level_Name varchar2,
91                                      p_Level_Attribute_Name varchar2,
92                                      p_Table_Owner varchar2,
93                                      p_Table_Name varchar2,
94                                      p_AttrCol varchar2);
95 
96 procedure RemoveMap_DimTbl_LevelAttr(p_Dimension_Owner varchar2,
97                                      p_Dimension_Name varchar2,
98                                      p_Dimension_Attribute_Name varchar2,
99                                      p_Level_Name varchar2,
100                                      p_Level_Attribute_Name varchar2);
101 
102 procedure       Map_DimTbl_HierSortKey(p_Dimension_Owner varchar2,
103                                        p_Dimension_Name varchar2,
104                                        p_Hierarchy_Name varchar2,
105                                        p_SortCol varchar2);
106 
107 procedure RemoveMap_DimTbl_HierSortKey(p_Dimension_Owner varchar2,
108                                        p_Dimension_Name varchar2,
109                                        p_Hierarchy_Name varchar2);
110 
111 end cwm2_olap_table_map;