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: WorkingwiththeStarStarTab.html
Close
ο»Ώ<html> <head> <title>Working with the Star Star Tab</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("WorkingwiththeStarStarTab"); } </script> </head> <body> <div id="topic_header"> <div id="topic_header_content"> <h1>Working with the Star Star Tab</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="HowtoDeleteaIncrementalTable.html"><img src="img/arrow_left.png" alt="Previous"/></a> <a href="HowtoCreateaStarStarTable.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">Working with the Star Star Tab</span></p> <p class="rvps3"><span class="rvts7">In computing, the Star Schema (also called Star-Join Schema, Data Cube, or Multi-Dimensional Schema) is the simplest style of data warehouse schema. The Star schema consists of one or more fact tables referencing any number of dimension tables. The Star schema is an important and special case of the Snowflake schema. The Star schema is more effective to handle simple queries.</span></p> <p class="rvps3"><span class="rvts7">Star Star Tables are used to reduce the execution time for a query and to obtain the optimal results of a query. When you execute a query, the time taken could be long, as the entire transaction table has to be processed to display the results. To overcome this, you can create a Star Star table for a query that you want to execute. You can then redirect the query to a different table where the corresponding entries of a transaction table are available.</span></p> <p class="rvps3"><span class="rvts7">For example, when you want to view any specific values need such as, Sales for a given year like 2005 or for a given countryβIndia, you can create Star Star tables for these values with year=2005 and country=India respectively. When a user wants to execute a query related for the year 2005 or for the country India, CUBOT searches for the entries in the redirect table for this value alone. Thereby the search time and execute time is reduced.</span></p> <p class="rvps28"><span class="rvts18">To reach the Star Star Tables screen, do the following:</span></p> <p class="rvps69"><span class="rvts18">1. In the CUBOT menu, click the </span><span class="rvts17">SCHEMA </span><span class="rvts18">tab. The Schema screen is displayed.</span></p> <p class="rvps69"><span class="rvts18">2. Move to the left of the Schema screen and click on the folder that you want to work with. The list of tables </span></p> <p class="rvps69"><span class="rvts18"> in the folder is displayed.</span></p> <p class="rvps69"><span class="rvts18">3. Select the table that you want to work with.</span></p> <p class="rvps69"><span class="rvts18">4. In the Schema menu, click </span><span class="rvts17">Star Star</span><span class="rvts18">. The Star Star Tables screen is displayed.</span></p> <p class="rvps6"><img alt="" style="padding : 1px;" src="lib/Star Star Tables Screen.png"/></p> <p class="rvps16"><span class="rvts19">Star Star Tables Screen</span></p> <p class="rvps28"><span class="rvts18">The following table describes the items in the Star Star Tables screen.</span></p> <div class="rvps20"><table width="600" 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: 152px;"><p class="rvps20"><span class="rvts33">Element</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; background-color: #eaf1dd; width: 428px;"><p class="rvps20"><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: 152px;"><p class="rvps20"><span class="rvts7">Table Name</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 428px;"><p class="rvps20"><span class="rvts24">Displays the name of the selected table.</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 152px;"><p class="rvps20"><span class="rvts7">Table Type</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 428px;"><p class="rvps20"><span class="rvts24">Displays the type of table.</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 152px;"><p class="rvps20"><span class="rvts7">Transaction Table </span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 428px;"><p class="rvps20"><span class="rvts7">Displays the name of the Fact table from which the measure is created, and for which a Star Star table is created. For example, trn_sales.</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 152px;"><p class="rvps20"><span class="rvts7">Master Table</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 428px;"><p class="rvps20"><span class="rvts7">Displays the name of the Dimension table that contains the dimension that appears on CUBOT end-user screens. For example, mst_agent.</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 152px;"><p class="rvps20"><span class="rvts7">Master Column</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 428px;"><p class="rvps20"><span class="rvts7">Displays the column name that indicates a column of the selected Dimension table that appears in a report. For example, ag_code.</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 152px;"><p class="rvps20"><span class="rvts7">Master Value</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 428px;"><p class="rvps20"><span class="rvts7">Displays the value that indicates the data of the master column(dimension value). For example, AL001.</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 152px;"><p class="rvps20"><span class="rvts7">Redirect Table</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 428px;"><p class="rvps20"><span class="rvts7">Displays the name of the of the redirect table, where the transactional data of the master value (dimension value) is stored. For example, sales_AL001.</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 152px;"><p class="rvps20"><span class="rvts9">Create Table</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 428px;"><p class="rvps20"><span class="rvts7">Select the check box to create the the Redirect table (if not created).</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 152px;"><p class="rvps20"><span class="rvts9">Populate Data</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 428px;"><p class="rvps20"><span class="rvts7">Select the check box to transfer the transactional data into the Redirect table for a selected master value (dimension value).</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 152px;"><p class="rvps20"><span class="rvts9">Add</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 428px;"><p class="rvps20"><span class="rvts7">Click to add </span><span class="rvts24">an incremental</span><span class="rvts7"> table.</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 152px;"><p class="rvps20"><span class="rvts9">Cancel</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 428px;"><p class="rvps20"><span class="rvts7">Click to undo the changes.</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 152px;"><p class="rvps20"><img width="26" height="20" alt="" style="padding : 1px;" src="lib/Edit this field icon.png"/></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 428px;"><p class="rvps20"><span class="rvts24">Click to modify the details of an incremental table.</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 152px;"><p class="rvps20"><img alt="" style="padding : 1px;" src="lib/Delete icon.png"/></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 428px;"><p class="rvps20"><span class="rvts7">Click to delete </span><span class="rvts24">an incremental</span><span class="rvts7"> table.</span></p> </td> </tr> </table> </div> <p class="rvps28"><span class="rvts18"><br/></span></p> </div> <div id="topic_footer"> <div id="topic_footer_content"> Copyright © 2012 Robust Designs India Private Ltd. All Rights Reserved.</div> </div> </body> </html>