OXIESEC PANEL
- Current Dir:
/
/
home
/
cubot
/
docroot
/
help
/
help_admin
Server IP: 139.59.38.164
Upload:
Create Dir:
Name
Size
Modified
Perms
📁
..
-
08/14/2022 11:08:45 AM
rwxr-xr-x
📄
AboutSchemaTables.html
6.74 KB
08/14/2022 11:08:39 AM
rw-r--r--
📄
AdministratorResponsibilities.html
3.93 KB
08/14/2022 11:08:45 AM
rw-r--r--
📄
CUBOTMenu.html
6.99 KB
08/14/2022 11:08:36 AM
rw-r--r--
📄
CUBOTataGlance.html
3.63 KB
08/14/2022 11:08:39 AM
rw-r--r--
📄
CopyrightandTrademarkInformation.html
4.1 KB
08/14/2022 11:08:15 AM
rw-r--r--
📄
ElementsofCUBOTScreens.html
2.38 KB
08/14/2022 11:08:15 AM
rw-r--r--
📄
GettingStarted.html
13.65 KB
08/14/2022 11:08:16 AM
rw-r--r--
📄
HowtoAddUserstoaGroup.html
5.15 KB
08/14/2022 11:08:45 AM
rw-r--r--
📄
HowtoAddaDimension.html
9.85 KB
08/14/2022 11:08:40 AM
rw-r--r--
📄
HowtoAddaNewDimensionGroup.html
7.25 KB
08/14/2022 11:08:36 AM
rw-r--r--
📄
HowtoAddaNewGroup.html
7.26 KB
08/14/2022 11:08:39 AM
rw-r--r--
📄
HowtoAddaNewMeasure.html
25.99 KB
08/14/2022 11:08:39 AM
rw-r--r--
📄
HowtoAddaNewMeasureGroup.html
6.86 KB
08/14/2022 11:08:41 AM
rw-r--r--
📄
HowtoAddaNewMetadata.html
11.5 KB
08/14/2022 11:08:39 AM
rw-r--r--
📄
HowtoAddaNewMetadataGroup.html
4.91 KB
08/14/2022 11:08:43 AM
rw-r--r--
📄
HowtoAddaNewTarget.html
8.48 KB
08/14/2022 11:08:45 AM
rw-r--r--
📄
HowtoAddaNewTemplate.html
11.87 KB
08/14/2022 11:08:36 AM
rw-r--r--
📄
HowtoAddaNewUser.html
24.77 KB
08/14/2022 11:08:16 AM
rw-r--r--
📄
HowtoAddaUserwithAdminRole.html
9.31 KB
08/14/2022 11:08:15 AM
rw-r--r--
📄
HowtoChangeAdminPassword.html
4.19 KB
08/14/2022 11:08:16 AM
rw-r--r--
📄
HowtoChangeOrderoftheMetadata.html
3.68 KB
08/14/2022 11:08:16 AM
rw-r--r--
📄
HowtoChangeOrderoftheMetadataGro.html
4.13 KB
08/14/2022 11:08:44 AM
rw-r--r--
📄
HowtoCheckJoins.html
4.27 KB
08/14/2022 11:08:15 AM
rw-r--r--
📄
HowtoCompareAccessPermissions.html
7.55 KB
08/14/2022 11:08:44 AM
rw-r--r--
📄
HowtoCompareAccessPermissionsofS.html
5.99 KB
08/14/2022 11:08:45 AM
rw-r--r--
📄
HowtoCreateaNewTable.html
12.43 KB
08/14/2022 11:08:39 AM
rw-r--r--
📄
HowtoCreateaStarStarTable.html
10.95 KB
08/14/2022 11:08:16 AM
rw-r--r--
📄
HowtoCreateaSynonymTable.html
7.43 KB
08/14/2022 11:08:40 AM
rw-r--r--
📄
HowtoCreateaTableJoin.html
8.18 KB
08/14/2022 11:08:16 AM
rw-r--r--
📄
HowtoCreateanIncrementalTable.html
7.57 KB
08/14/2022 11:08:39 AM
rw-r--r--
📄
HowtoCustomizeAlertSettings.html
4.15 KB
08/14/2022 11:08:44 AM
rw-r--r--
📄
HowtoCustomizeCUBOTSettings.html
26.03 KB
08/14/2022 11:08:45 AM
rw-r--r--
📄
HowtoCustomizeEnquirySettings.html
3.95 KB
08/14/2022 11:08:45 AM
rw-r--r--
📄
HowtoCustomizeGraphSettings.html
20.2 KB
08/14/2022 11:08:42 AM
rw-r--r--
📄
HowtoCustomizeLoginSettings.html
10.69 KB
08/14/2022 11:08:39 AM
rw-r--r--
📄
HowtoCustomizeUserSettings.html
8.7 KB
08/14/2022 11:08:44 AM
rw-r--r--
📄
HowtoDeleteUsersfromaGroup.html
4.38 KB
08/14/2022 11:08:36 AM
rw-r--r--
📄
HowtoDeleteaDimension.html
3.46 KB
08/14/2022 11:08:38 AM
rw-r--r--
📄
HowtoDeleteaDimensionGroup.html
3.98 KB
08/14/2022 11:08:15 AM
rw-r--r--
📄
HowtoDeleteaFilter.html
7.01 KB
08/14/2022 11:08:38 AM
rw-r--r--
📄
HowtoDeleteaGroup.html
3.31 KB
08/14/2022 11:08:15 AM
rw-r--r--
📄
HowtoDeleteaIncrementalTable.html
4.04 KB
08/14/2022 11:08:16 AM
rw-r--r--
📄
HowtoDeleteaMeasure.html
3.47 KB
08/14/2022 11:08:15 AM
rw-r--r--
📄
HowtoDeleteaMeasureGroup.html
3.86 KB
08/14/2022 11:08:16 AM
rw-r--r--
📄
HowtoDeleteaMetadata.html
4.06 KB
08/14/2022 11:08:41 AM
rw-r--r--
📄
HowtoDeleteaMetadataGroup.html
3.82 KB
08/14/2022 11:08:40 AM
rw-r--r--
📄
HowtoDeleteaStarStarTable.html
4.01 KB
08/14/2022 11:08:40 AM
rw-r--r--
📄
HowtoDeleteaSynonymTable.html
3.97 KB
08/14/2022 11:08:16 AM
rw-r--r--
📄
HowtoDeleteaTable.html
3.71 KB
08/14/2022 11:08:16 AM
rw-r--r--
📄
HowtoDeleteaTableJoin.html
3.6 KB
08/14/2022 11:08:39 AM
rw-r--r--
📄
HowtoDeleteaTarget.html
3.41 KB
08/14/2022 11:08:36 AM
rw-r--r--
📄
HowtoDeleteaTemplate.html
3.85 KB
08/14/2022 11:08:16 AM
rw-r--r--
📄
HowtoDeleteaUser.html
4.51 KB
08/14/2022 11:08:43 AM
rw-r--r--
📄
HowtoDeletetheDetailsofaReport.html
3.17 KB
08/14/2022 11:08:16 AM
rw-r--r--
📄
HowtoEditaDimension.html
4.49 KB
08/14/2022 11:08:43 AM
rw-r--r--
📄
HowtoEditaDimensionGroup.html
4.6 KB
08/14/2022 11:08:39 AM
rw-r--r--
📄
HowtoEditaMeasure.html
4.81 KB
08/14/2022 11:08:16 AM
rw-r--r--
📄
HowtoEditaMeasureGroup.html
4.57 KB
08/14/2022 11:08:38 AM
rw-r--r--
📄
HowtoEditaStarStarTable.html
4.57 KB
08/14/2022 11:08:38 AM
rw-r--r--
📄
HowtoEditaSynonymTable.html
4.82 KB
08/14/2022 11:08:38 AM
rw-r--r--
📄
HowtoEditaTableJoin.html
5.61 KB
08/14/2022 11:08:39 AM
rw-r--r--
📄
HowtoEditaTarget.html
4.89 KB
08/14/2022 11:08:39 AM
rw-r--r--
📄
HowtoEditanIncrementalTable.html
4.9 KB
08/14/2022 11:08:16 AM
rw-r--r--
📄
HowtoEdittheDetailsofaMetadataGr.html
4.88 KB
08/14/2022 11:08:44 AM
rw-r--r--
📄
HowtoEdittheMetadataDetails.html
4.85 KB
08/14/2022 11:08:39 AM
rw-r--r--
📄
HowtoEdittheTableDetails.html
9.82 KB
08/14/2022 11:08:16 AM
rw-r--r--
📄
HowtoEdittheTemplateDetails.html
4.62 KB
08/14/2022 11:08:40 AM
rw-r--r--
📄
HowtoLogontoCUBOT.html
3.4 KB
08/14/2022 11:08:35 AM
rw-r--r--
📄
HowtoManageCategoryFoldersintheS.html
11.18 KB
08/14/2022 11:08:36 AM
rw-r--r--
📄
HowtoModifyDetailsofaGroup.html
4.37 KB
08/14/2022 11:08:40 AM
rw-r--r--
📄
HowtoModifyFilters.html
10.78 KB
08/14/2022 11:08:16 AM
rw-r--r--
📄
HowtoModifyFiltersofaGroup.html
3.25 KB
08/14/2022 11:08:41 AM
rw-r--r--
📄
HowtoPreviewtheEnquiryScreen.html
3.34 KB
08/14/2022 11:08:36 AM
rw-r--r--
📄
HowtoResetUserPassword.html
4.13 KB
08/14/2022 11:08:16 AM
rw-r--r--
📄
HowtoReviewtheUserFeedback.html
7.24 KB
08/14/2022 11:08:43 AM
rw-r--r--
📄
HowtoSearchforaUser.html
3.81 KB
08/14/2022 11:08:43 AM
rw-r--r--
📄
HowtoSearchtheDetailsofReportsGe.html
7.46 KB
08/14/2022 11:08:38 AM
rw-r--r--
📄
HowtoSetCUBOTParameters.html
7.57 KB
08/14/2022 11:08:15 AM
rw-r--r--
📄
HowtoSetMenuHierarchyofaDimensio.html
6.87 KB
08/14/2022 11:08:40 AM
rw-r--r--
📄
HowtoSetOrderofPreferenceforDime.html
4.77 KB
08/14/2022 11:08:16 AM
rw-r--r--
📄
HowtoShoworHideTableDetails.html
6.85 KB
08/14/2022 11:08:16 AM
rw-r--r--
📄
HowtoUpdateUserSettings.html
18.42 KB
08/14/2022 11:08:40 AM
rw-r--r--
📄
HowtoUpdatetheUserDetails.html
4.9 KB
08/14/2022 11:08:39 AM
rw-r--r--
📄
HowtoUploadInformation.html
4.51 KB
08/14/2022 11:08:36 AM
rw-r--r--
📄
HowtoViewAccessPermissions.html
7.42 KB
08/14/2022 11:08:45 AM
rw-r--r--
📄
HowtoViewDetailsofReportsGenerat.html
12.93 KB
08/14/2022 11:08:39 AM
rw-r--r--
📄
HowtoViewFilterDetails.html
8.45 KB
08/14/2022 11:08:38 AM
rw-r--r--
📄
HowtoViewTableJoins.html
4.34 KB
08/14/2022 11:08:43 AM
rw-r--r--
📄
HowtoViewUserDetails.html
10.01 KB
08/14/2022 11:08:16 AM
rw-r--r--
📄
HowtoWorkwithaResultScreen.html
13.21 KB
08/14/2022 11:08:36 AM
rw-r--r--
📄
HowtoWorkwithanEnquiryScreen.html
14.17 KB
08/14/2022 11:08:45 AM
rw-r--r--
📄
Main.html
1.03 KB
08/14/2022 11:08:43 AM
rw-r--r--
📄
ManagingAccessPermissionsofCUBOT.html
4.79 KB
08/14/2022 11:08:45 AM
rw-r--r--
📄
ManagingtheFilters.html
5.18 KB
08/14/2022 11:08:15 AM
rw-r--r--
📄
USERMODETab.html
3.17 KB
08/14/2022 11:08:15 AM
rw-r--r--
📄
UserInformation.html
5.66 KB
08/14/2022 11:08:40 AM
rw-r--r--
📄
WhyyoushouldSignOutofCUBOT.html
3.09 KB
08/14/2022 11:08:16 AM
rw-r--r--
📄
WorkingwithDimensions.html
3.27 KB
08/14/2022 11:08:35 AM
rw-r--r--
📄
WorkingwithMeasures.html
3.13 KB
08/14/2022 11:08:42 AM
rw-r--r--
📄
WorkingwithTargets.html
3.07 KB
08/14/2022 11:08:16 AM
rw-r--r--
📄
WorkingwithTemplates.html
5.59 KB
08/14/2022 11:08:16 AM
rw-r--r--
📄
WorkingwiththeGroupsTab.html
6.36 KB
08/14/2022 11:08:40 AM
rw-r--r--
📄
WorkingwiththeIncrementalTab.html
7.73 KB
08/14/2022 11:08:45 AM
rw-r--r--
📄
WorkingwiththeItemsTab.html
7.05 KB
08/14/2022 11:08:16 AM
rw-r--r--
📄
WorkingwiththeJoinsTab.html
6.49 KB
08/14/2022 11:08:36 AM
rw-r--r--
📄
WorkingwiththeMetadataTab.html
9.88 KB
08/14/2022 11:08:45 AM
rw-r--r--
📄
WorkingwiththePreferencesTab.html
6.19 KB
08/14/2022 11:08:38 AM
rw-r--r--
📄
WorkingwiththeSchemaTab.html
7.32 KB
08/14/2022 11:08:39 AM
rw-r--r--
📄
WorkingwiththeStarStarTab.html
11.02 KB
08/14/2022 11:08:39 AM
rw-r--r--
📄
WorkingwiththeSynonymsTab.html
7.36 KB
08/14/2022 11:08:38 AM
rw-r--r--
📄
WorkingwiththeTableDataTab.html
3.38 KB
08/14/2022 11:08:41 AM
rw-r--r--
📄
WorkingwiththeTableEditorTab.html
7.92 KB
08/14/2022 11:08:15 AM
rw-r--r--
📄
WorkingwiththeUsersTab.html
11.17 KB
08/14/2022 11:08:39 AM
rw-r--r--
📁
css
-
08/14/2022 11:08:36 AM
rwxr-xr-x
📁
img
-
08/14/2022 11:08:38 AM
rwxr-xr-x
📁
js
-
08/14/2022 11:08:43 AM
rwxr-xr-x
📁
lib
-
08/14/2022 11:08:35 AM
rwxr-xr-x
📄
toc.html
62.5 KB
08/14/2022 11:08:16 AM
rw-r--r--
Editing: AboutSchemaTables.html
Close
<html> <head> <title>About Schema Tables</title> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <meta name="generator" content="HelpNDoc Standard Edition 3.6.0.345"> <link type="text/css" rel="stylesheet" media="all" href="css/reset.css" /> <link type="text/css" rel="stylesheet" media="all" href="css/base.css" /> <link type="text/css" rel="stylesheet" media="all" href="css/hnd.css" /> <!--[if lte IE 8]> <link type="text/css" rel="stylesheet" media="all" href="css/ielte8.css" /> <![endif]--> <style type="text/css"> #topic_header { background-color: #EFEFEF; } </style> <script type="text/javascript" src="js/jquery.min.js"></script> <script type="text/javascript" src="js/hnd.js"></script> <script type="text/javascript"> if (top.frames.length == 0) { var sTopicUrl = top.location.href.substring(top.location.href.lastIndexOf("/") + 1, top.location.href.length); top.location.href = "CUBOT 9.0 ADMIN GUIDE.html?" + sTopicUrl; } else if (top && top.FrameTOC && top.FrameTOC.SelectTocItem) { top.FrameTOC.SelectTocItem("AboutSchemaTables"); } </script> </head> <body> <div id="topic_header"> <div id="topic_header_content"> <h1>About Schema Tables</h1> <div id="topic_breadcrumb"> <a href="WorkingwiththeSchemaTab.html">Working with the Schema Tab</a> ›› </div> </div> <div id="topic_header_nav"> <a href="WorkingwiththeSchemaTab.html"><img src="img/arrow_up.png" alt="Parent"/></a> <a href="WorkingwiththeSchemaTab.html"><img src="img/arrow_left.png" alt="Previous"/></a> <a href="WorkingwiththeTableEditorTab.html"><img src="img/arrow_right.png" alt="Next"/></a> </div> <div class="clear"></div> </div> <div id="topic_content"> <p class="rvps9"><span class="rvts14">About Schema Tables</span></p> <p class="rvps28"><span class="rvts18">The following table describes the different schema tables.</span></p> <p class="rvps16"><span class="rvts17">Different Schema Tables</span></p> <div class="rvps30"><table width="580" border="1" cellpadding="4" cellspacing="-1" style="border-width: 0px; border-collapse: collapse;"> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; background-color: #eaf1dd; width: 123px;"><p class="rvps30"><span class="rvts33">Table</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; background-color: #eaf1dd; width: 430px;"><p class="rvps30"><span class="rvts33">Description</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 123px;"><p class="rvps20"><span class="rvts24">Facts</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 430px;"><p class="rvps20"><span class="rvts24">Contains the transaction data of a system.</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 123px;"><p class="rvps20"><span class="rvts24">Dimension</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 430px;"><p class="rvps20"><span class="rvts24">Contains the master data of a system.</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 123px;"><p class="rvps20"><span class="rvts24">Target</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 430px;"><p class="rvps20"><span class="rvts24">Lists all the Target tables. A Target table contains the targets set by the company for various performance indicators such as sales. Target tables are used to compare the actual performance of the indicator versus the target.</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 123px;"><p class="rvps20"><span class="rvts24">ETL</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 430px;"><p class="rvps20"><span class="rvts22">Used by ETL process. ETL is the process where data is drawn out from one data store (Extract), modified (Transform), and inserted into a different data store (Load).</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 123px;"><p class="rvps20"><span class="rvts24">Star Star</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 430px;"><p class="rvps20"><span class="rvts7">Used for large volumes of data. The data is split into different transition tables to reduce the query time. You can generate the report quickly.</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 123px;"><p class="rvps20"><span class="rvts24">Synonym</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 430px;"><p class="rvps20"><span class="rvts7">Created to use the same table in different contexts in a query. A synonym table is a table with an alternative name for another table.</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 123px;"><p class="rvps20"><span class="rvts24">Incremental</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 430px;"><p class="rvps20"><span class="rvts24">Lists all Incremental tables. An Incremental table contains only incremental transactional database on incremental definition(one day, two day, and so on.). On each ETL the existing data of the incremental table is moved to the main transaction table and the new data that is extracted is pushed to the incremental table.</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 123px;"><p class="rvps20"><span class="rvts24">Other</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 430px;"><p class="rvps20"><span class="rvts24">List tables that do not belong to any of the above categories. For example, temporary tables.</span></p> </td> </tr> </table> </div> </div> <div id="topic_footer"> <div id="topic_footer_content"> Copyright © 2012 Robust Designs India Private Ltd. All Rights Reserved.</div> </div> </body> </html>