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: HowtoAddaNewMeasure.html
Close
<html> <head> <title>How to Add a New Measure</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("HowtoAddaNewMeasure"); } </script> </head> <body> <div id="topic_header"> <div id="topic_header_content"> <h1>How to Add a New Measure</h1> <div id="topic_breadcrumb"> <a href="WorkingwiththeItemsTab.html">Working with the Items Tab</a> ›› <a href="WorkingwithMeasures.html">Working with Measures</a> ›› </div> </div> <div id="topic_header_nav"> <a href="WorkingwithMeasures.html"><img src="img/arrow_up.png" alt="Parent"/></a> <a href="HowtoDeleteaMeasureGroup.html"><img src="img/arrow_left.png" alt="Previous"/></a> <a href="HowtoEditaMeasure.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">How to Add a New Measure</span></p> <p class="rvps28"><span class="rvts18">To add a new measure, do the following:</span></p> <p class="rvps13"><span class="rvts7">1. In the CUBOT menu, click the </span><span class="rvts9">ITEMS</span><span class="rvts7"> tab. The Items screen is displayed.</span></p> <p class="rvps39"><img alt="" style="padding : 1px;" src="lib/click to add measure.png"/></p> <p class="rvps39"><span class="rvts17">Items Screen</span></p> <p class="rvps13"><span class="rvts7">2. Move to the left of the Items screen and move to the dimensions under</span><span class="rvts18"> </span><span class="rvts17">10000 Measures</span><span class="rvts18">. </span></p> <p class="rvps13"><span class="rvts18"> Click the </span><img alt="" style="padding : 1px;" src="lib/add dimension group icon.png"/><span class="rvts18"> icon beside the measure group to which you want to add a measure. </span></p> <p class="rvps13"><span class="rvts18"> The Add Measure screen is displayed.</span></p> <p class="rvps21"><img alt="" style="padding : 1px;" src="lib/Note icon.png"/><span class="rvts26"> </span><span class="rvts18">Each new item that is added has its own ID automatically generated by CUBOT. The IDs of measure groups increment in hundreds. When the last two digits of the IDs of items within a measure group reach 90, CUBOT prompts you to enter the ID. You cannot enter an ID number higher than that of the next measure group ID.</span></p> <p class="rvps6"><img alt="" style="padding : 1px;" src="lib/Add a Measure Screen.png"/></p> <p class="rvps16"><span class="rvts17">Add a Measure Screen</span></p> <p class="rvps28"><span class="rvts18">The following table describes the steps to add details in the Add Measure .</span></p> <p class="rvps44"><span class="rvts9">Steps to add details in the Add Measure Screen</span></p> <div class="rvps3"><table width="611" 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: 104px;"><p class="rvps30"><span class="rvts33">Element</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; background-color: #eaf1dd; width: 135px;"><p class="rvps30"><span class="rvts33">UI Component Type</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; background-color: #eaf1dd; width: 340px;"><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: 104px;"><p class="rvps20"><span class="rvts27">Table</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 135px;"><p class="rvps20"><span class="rvts24">Drop-down list</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 340px;"><p class="rvps20"><span class="rvts24">Displays the name of the database table where the details of the measure are stored. 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: 104px;"><p class="rvps20"><span class="rvts27">ID</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 135px;"><p class="rvps20"><span class="rvts24">Text box</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 340px;"><p class="rvps20"><span class="rvts24">Type the measure identifier for the new measure. For example, 10191.</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 104px;"><p class="rvps20"><span class="rvts27">Parent Id</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 135px;"><p class="rvps20"><span class="rvts24">Drop-down list</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 340px;"><p class="rvps20"><span class="rvts24">Displays the id of the measure group to which the measure belongs. For example, Sales[10100].</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 104px;"><p class="rvps20"><span class="rvts27">Description</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 135px;"><p class="rvps20"><span class="rvts24">Text box</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 340px;"><p class="rvps20"><span class="rvts24">Type the description for the selected measure. This description will appear as a tool tip in the </span><span class="rvts27">ANALYZE</span><span class="rvts24"> tab. For example, Duties paid.</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 104px;"><p class="rvps20"><span class="rvts27">Name</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 135px;"><p class="rvps20"><span class="rvts24">Text box</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 340px;"><p class="rvps20"><span class="rvts24">Type the name of the measure as it should appear in the right side of the </span><span class="rvts27">ANALYZE</span><span class="rvts24"> tab. For example, Excise USA.</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 104px;"><p class="rvps20"><span class="rvts27">Role</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 135px;"><p class="rvps20"><span class="rvts24">Drop-down list</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 340px;"><p class="rvps20"><span class="rvts24">Select the name of the role that should be allowed to access the measure. The selected role is displayed i the </span><span class="rvts27">Role</span><span class="rvts24"> text box. For example, common.</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 104px;"><p class="rvps20"><span class="rvts55">Regen Group</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 135px;"><p class="rvps20"><span class="rvts41">Drop-down list</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 340px;"><p class="rvps20"><span class="rvts41">Select to create a group of measures, that are belong to the same database table. Usually, these measures are used together in reports.</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 104px;"><p class="rvps20"><span class="rvts27">Aggregate Function</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 135px;"><p class="rvps20"><span class="rvts24">Drop-down list</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 340px;"><p class="rvps20"><span class="rvts24">Select the name of the aggregate function that needs to be carried out for the measure. The selected aggregate function is displayed in the </span><span class="rvts27">Aggregate Function</span><span class="rvts24"> text box.For example, Sum.</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 104px;"><p class="rvps20"><span class="rvts27">Time Column</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 135px;"><p class="rvps20"><span class="rvts24">Drop-down list</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 340px;"><p class="rvps20"><span class="rvts24">Select date/date-time column. The selected table name is displayed in the </span><span class="rvts27">Time Column</span><span class="rvts24"> text box. For example, sa_date.</span></p> <p class="rvps20"><span class="rvts24">This is used to determine all time dimension values in a report. For example, When you generate report with this measure and year dimension then the year value is calculated based on this date.</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 104px;"><p class="rvps20"><span class="rvts27">Column</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 135px;"><p class="rvps20"><span class="rvts24">Drop-down list</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 340px;"><p class="rvps20"><span class="rvts24">Select the column in the selected database table where the measure details are stored. You can use any SQL expression supported by the database for the column.For example, sa_exchange.</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 104px;"><p class="rvps20"><span class="rvts27">Having</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 135px;"><p class="rvps20"><span class="rvts24">Text box</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 340px;"><p class="rvps20"><span class="rvts24">Specify the constraints to display data within a particular range. For example, value>50000.</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 104px;"><p class="rvps20"><span class="rvts55">Attribute</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 135px;"><p class="rvps20"><span class="rvts41">Drop-down list</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 340px;"><p class="rvps20"><span class="rvts41">Select the attribute for the measure. The different options available are.</span></p> <ul style="text-indent: 0px; margin-left: 53px; list-style-position: outside;"> <li class="rvps30" style="margin-left: 0"><span class="rvts7">0: </span><span class="rvts41">No Attribute</span><span class="rvts7">.</span></li> <li class="rvps30" style="margin-left: 0"><span class="rvts41">1: Cumulative Measure. Used to perform cumulative operation when calculating this measure.</span></li> <li class="rvps30" style="margin-left: 0"><span class="rvts41">2: Date type of Dimension. Used for a dimension and not for measure. This attribute is used to switch time column of a measure.</span></li> <li class="rvps30" style="margin-left: 0"><span class="rvts41">4: Date dependent Measure. Used with Measure for which date filter parameter is mandatory.</span></li> <li class="rvps30" style="margin-left: 0"><span class="rvts41">8: Weighted Average Measure</span></li> <li class="rvps30" style="margin-left: 0"><span class="rvts41">10: Measures with place holder variables. This measure can use other properties of its definition like Time column in where clause.</span></li> </ul> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 104px;"><p class="rvps20"><span class="rvts27">Where</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 135px;"><p class="rvps20"><span class="rvts24">Text box</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 340px;"><p class="rvps20"><span class="rvts24">Specify any filtering details for the measure. For example, year==2004.</span></p> </td> </tr> <tr valign="top"> <td colspan="3" valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; background-color: #eaf1dd; width: 579px;"><p class="rvps20"><span class="rvts27">Display Format section</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 104px;"><p class="rvps20"><span class="rvts27">Number Format</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 135px;"><p class="rvps20"><span class="rvts24">Radio button</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 340px;"><p class="rvps20"><span class="rvts24">Select the appropriate number format. This includes Million, Lakhs, European, Time, and Storage.</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 104px;"><p class="rvps20"><span class="rvts27">Precision</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 135px;"><p class="rvps20"><span class="rvts24">Text box</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 340px;"><p class="rvps20"><span class="rvts24">Type the value that indicates the number of digits after the decimal.</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 104px;"><p class="rvps20"><span class="rvts27">Zero Character</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 135px;"><p class="rvps20"><span class="rvts24">Text box</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 340px;"><p class="rvps20"><span class="rvts24">Type the character that you want to represent zero when the measure is computed.You can specify a dash, pound sign, or space to be displayed instead of 0.</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 104px;"><p class="rvps20"><span class="rvts27">Prefix Character</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 135px;"><p class="rvps20"><span class="rvts24">Text box</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 340px;"><p class="rvps20"><span class="rvts24">Type the character that you want to add as a prefix when the measure value is displayed.</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 104px;"><p class="rvps20"><span class="rvts27">Suffix Character</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 135px;"><p class="rvps20"><span class="rvts24">Text box</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 340px;"><p class="rvps20"><span class="rvts24">Type the character that you want to add as a suffix when the measure value is displayed.</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 104px;"><p class="rvps20"><span class="rvts55">Show Top Rows</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 135px;"><p class="rvps20"><span class="rvts41">Text box</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 340px;"><p class="rvps20"><span class="rvts41">Type the maximum number of records to be fetched when generating for this measure. Default value is -1, which means any number of records can be fetched. This is useful where a large number of data needs to be returned by a report.</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 104px;"><p class="rvps20"><span class="rvts27">Suppress Totals</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 135px;"><p class="rvps20"><span class="rvts24">Check box</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 340px;"><p class="rvps20"><span class="rvts24">Select to suppress totals for the selected measure. The totals will not be displayed on the screen or in the reports.</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 104px;"><p class="rvps20"><span class="rvts27">Suppress Grand Totals</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 135px;"><p class="rvps20"><span class="rvts24">Check box</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 340px;"><p class="rvps20"><span class="rvts24">Select to suppress grand totals for the selected measure. The grand totals will not be displayed on the screen or in the reports.</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 104px;"><p class="rvps20"><span class="rvts27">Suppress Min/Max</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 135px;"><p class="rvps20"><span class="rvts24">Check box</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 340px;"><p class="rvps20"><span class="rvts24">Select to suppress the minimum or maximum value.</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 104px;"><p class="rvps20"><span class="rvts27">Suppress Average</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 135px;"><p class="rvps20"><span class="rvts24">Check box</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 340px;"><p class="rvps20"><span class="rvts24">Select to suppress the average value.</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 104px;"><p class="rvps20"><span class="rvts27">Cumulative</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 135px;"><p class="rvps20"><span class="rvts24">Check box </span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 340px;"><p class="rvps20"><span class="rvts24">Select to enable a cumulative function for the selected measure.</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 104px;"><p class="rvps20"><span class="rvts27">Weighted Average</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 135px;"><p class="rvps20"><span class="rvts24">Check box</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 340px;"><p class="rvps20"><span class="rvts24">Select to enable the weighted average value.</span></p> </td> </tr> <tr valign="top"> <td colspan="3" valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; background-color: #eaf1dd; width: 579px;"><p class="rvps20"><span class="rvts27"><br/></span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 104px;"><p class="rvps20"><span class="rvts55">Current Note</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 135px;"><p class="rvps20"><span class="rvts41">Label</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 340px;"><p class="rvps20"><span class="rvts22">Displays the </span><span class="rvts23">comments (for this dimension) given by administrator. This is useful when you modify a Dimension. You can type a note about the changes that you make to the existing dimension definition. This helps in track all changes made to a Dimension.</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 104px;"><p class="rvps20"><span class="rvts55">Update Note</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 135px;"><p class="rvps20"><span class="rvts41">Text box</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 340px;"><p class="rvps20"><span class="rvts24">In the</span><span class="rvts27"> Update Note</span><span class="rvts24">: text box, type a comment or change the comment when you add or edit a dimension.</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 104px;"><p class="rvps20"><span class="rvts27">Add</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 135px;"><p class="rvps20"><span class="rvts24">Push Button</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 340px;"><p class="rvps20"><span class="rvts24">Click to add the details to CUBOT. You now see the message</span><span class="rvts27"> ! Menu Item <Number> - <Measure Name></span><span class="rvts24"> </span><span class="rvts27">added</span><span class="rvts24">. </span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 104px;"><p class="rvps20"><span class="rvts27">Cancel</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 135px;"><p class="rvps20"><span class="rvts24">Push Button</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 340px;"><p class="rvps20"><span class="rvts24">Click to discard the data you entered.</span></p> </td> </tr> <tr valign="top"> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 104px;"><p class="rvps20"><span class="rvts27">Show Table</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 135px;"><p class="rvps20"><span class="rvts24">Push Button</span></p> </td> <td valign="top" style="border-width : 1px; border-color: #000000; border-style: solid; width: 340px;"><p class="rvps20"><span class="rvts24">Click to view the table details. For more details see, </span><a class="rvts54" href="HowtoShoworHideTableDetails.html">How to Show or Hide Table Details</a><span class="rvts24">.</span></p> </td> </tr> </table> </div> <p class="rvps29"><span class="rvts17"><br/></span></p> <p class="rvps20"><span class="rvts17"><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>