📄 2.3.html
字号:
<HTML>
<HEAD>
<META name="GENERATOR" content="Microsoft FrontPage 4.0">
<META http-equiv="Content-Style-Type" content="text/css">
<LINK rel="stylesheet" href="/resources/help_bb.css" type="text/css">
<TITLE>
查询统计
</TITLE>
</HEAD>
<BODY bgcolor="#FFFFFF">
<h3><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">查询统计</span><span lang="EN-US"> <o:p>
</o:p>
</span></h3>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">在主页面左侧的菜单面中，通过鼠标左键点击“查询统计”项，可以看到该项目下各种综合查询的标题，通常包括以下内容：</span><span lang="EN-US"> <o:p>
</o:p>
</span></p>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">机构投入产出查询</span></p>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">产品投入产出查询</span></p>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">客户经理投入产出查询</span></p>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">柜员投入产出查询</span></p>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">经营部门业务指标查询</span></p>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">客户经理业务指标查询</span></p>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">柜员业务指标查询</span></p>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">如下图：</span></p>
<p class="MsoNormal"><span lang="EN-US"><!--[if gte vml 1]><v:shapetype id="_x0000_t75"
coordsize="21600,21600" o:spt="75" o:preferrelative="t" path="m@4@5l@4@11@9@11@9@5xe"
filled="f" stroked="f">
<v:stroke joinstyle="miter"/>
<v:formulas>
<v:f eqn="if lineDrawn pixelLineWidth 0"/>
<v:f eqn="sum @0 1 0"/>
<v:f eqn="sum 0 0 @1"/>
<v:f eqn="prod @2 1 2"/>
<v:f eqn="prod @3 21600 pixelWidth"/>
<v:f eqn="prod @3 21600 pixelHeight"/>
<v:f eqn="sum @0 0 1"/>
<v:f eqn="prod @6 1 2"/>
<v:f eqn="prod @7 21600 pixelWidth"/>
<v:f eqn="sum @8 21600 0"/>
<v:f eqn="prod @7 21600 pixelHeight"/>
<v:f eqn="sum @10 21600 0"/>
</v:formulas>
<v:path o:extrusionok="f" gradientshapeok="t" o:connecttype="rect"/>
<o:lock v:ext="edit" aspectratio="t"/>
</v:shapetype><v:shape id="_x0000_i1034" type="#_x0000_t75" style='width:345.75pt;
height:259.5pt'>
<v:imagedata src="../../../../DOCUME~1/ADMINI~1.ACC/LOCALS~1/Temp/msoclip1/01/clip_image001.jpg"
o:title="mm-5"/>
</v:shape><![endif]-->
<img src="/resources/images/help/2.3.files/wpe1.jpg" v:shapes="_x0000_i1034" width="461" height="346"></span></p>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">注意：不同权限的用户所能看到的综合查询内容可能不同，这是由用户权限决定的。</span></p>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">在查看某个具体综合查询的内容时，只需鼠标左键点击相应查询名称既可。</span><span lang="EN-US"> <o:p>
</o:p>
</span></p>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">点击某个综合查询后，屏幕将会弹出一个新页面，对所选定类别的数据进行多维查询和分析就在这个页面中完成。</span></p>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">如下图：</span></p>
<p class="MsoNormal"><span lang="EN-US"><!--[if gte vml 1]><v:shape id="_x0000_i1035"
type="#_x0000_t75" style='width:323.25pt;height:242.25pt'>
<v:imagedata src="../../../../DOCUME~1/ADMINI~1.ACC/LOCALS~1/Temp/msoclip1/01/clip_image003.jpg"
o:title="mm-6"/>
</v:shape><![endif]-->
<img src="/resources/images/help/2.3.files/wpe2.jpg" v:shapes="_x0000_i1035" width="431" height="323"></span></p>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">页面中通常包含有维度、指标等要素，它们都是一些蓝色下拉菜单，比如“机构”、“日期”等，另外页面底部还有若干按钮，下面将分别加以说明。</span><span lang="EN-US"> <o:p>
</o:p>
</span></p>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">在页面顶端的几个下拉菜单（通过都并列为一行）通常统称为“维度”，而单个下拉菜单，如“机构”则称为机构维度，日期则称为日期维度。维度通常是用来确定选择数据的范围。一个多维查询中所包含的维度个数要视具体情况而定，因为屏幕是一个平面，所以通常在简单的情况下，屏幕上只能同时显示两个维度，比如行向为机构维度，纵向为时间维度，这样就可以确定某个机构、某个时间的数据。一般显示在行向上的维度称为行向维度，显示在列向上的维度称为列维度。</span><span lang="EN-US"> <o:p>
</o:p>
</span></p>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">如果一个多维查询中包含多个维度，除行向和列向上能显示两个维度外，其它的维度被选择后并不被显示出来，但所选定的值确实会发生作用。比如行向维度为机构，列向维度为部门，当选择日期维度中的</span><span lang="EN-US">2000</span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">年时，所显示出的数据就是</span><span lang="EN-US">2000</span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"">年一年年累计值。而选择了日期维度中的</span><span lang="EN-US">2000</span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"">年</span><span lang="EN-US">10</span><span style="font-family:
宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:"Times New Roman"">月</span><span lang="EN-US">1</span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">日时，所显示出的数据就是</span><span lang="EN-US">2000</span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"">年</span><span lang="EN-US">10</span><span style="font-family:
宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:"Times New Roman"">月</span><span lang="EN-US">1</span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">日的数据。</span><span lang="EN-US"> <o:p>
</o:p>
</span></p>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">当然，“多余”的维度还是可以通过“嵌套”的方式显示出来的，“嵌套”的使用将在下面讲到。</span><span lang="EN-US"> <o:p>
</o:p>
</span></p>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">维度从包含的内容角度看，通常又分为若干个层次。比如日期维度，分为年、季、月、旬、日等五个层次，年就是第一层，季是第二层，然后以此类推，日就是第五层；又比如机构维度，通常分为省行、二级行、基层行等，省行为第一层，二级行为第二层，基层行为第三层。</span></p>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">如下图：</span></p>
<p class="MsoNormal"><span lang="EN-US"><!--[if gte vml 1]><v:shape id="_x0000_i1036"
type="#_x0000_t75" style='width:336.75pt;height:225.75pt'>
<v:imagedata src="../../../../DOCUME~1/ADMINI~1.ACC/LOCALS~1/Temp/msoclip1/01/clip_image005.jpg"
o:title="mm-7"/>
</v:shape><![endif]-->
<img src="/resources/images/help/2.3.files/wpe3.jpg" v:shapes="_x0000_i1036" width="449" height="301"></span></p>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">如果点击日期维度，首先显示的是该维度的第一层，也就是包含哪些“年”的数据，将鼠标移到某一年选项时，又会列出这一年所包含的第二层的选择项（即包含哪些季度，一般情况下存在数据的日期才会被显示出来，比如</span><span lang="EN-US">2000</span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">年的第二季度没有数据，在选择了</span><span lang="EN-US">2000</span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">年这一选项时，所列出的第二层的选择项为“第一季度”、“第三度”、第四季度”，而不会有“第二季度”这个选项）。</span><span lang="EN-US"> <o:p>
</o:p>
</span></p>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">同样道理，当选择了某个季度时，又会列出该季度包含了哪些有数据的月份，即第三层的选择，以此类推，选择可以一直精确到最后一个层次的值。拿“日期维度”来讲，就可以一直精确到“日”。</span></p>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">如下图：</span></p>
<p class="MsoNormal"><span lang="EN-US"><!--[if gte vml 1]><v:shape id="_x0000_i1037"
type="#_x0000_t75" style='width:325.5pt;height:234.75pt'>
<v:imagedata src="../../../../DOCUME~1/ADMINI~1.ACC/LOCALS~1/Temp/msoclip1/01/clip_image007.jpg"
o:title="mm-8"/>
</v:shape><![endif]-->
<img src="/resources/images/help/2.3.files/wpe4.jpg" v:shapes="_x0000_i1037" width="434" height="313"></span></p>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">在维度下拉菜单中，通常最后一个选项是“操作”，将光标移到“操作”上时，会弹出它包含的两个子选项：“嵌套”和“替换”。而“嵌套”中通常又分为“行”和“列”。其含意是在行上或是在列上将该维度嵌套进去。比如：表格选项为机构的时候，选中“日期维度”</span><span lang="EN-US">--</span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">“操作”</span><span lang="EN-US">--</span><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:
"Times New Roman"">“嵌套”</span><span lang="EN-US">--</span><span style="font-family:
宋体;mso-ascii-font-family:"Times New Roman";mso-hansi-font-family:"Times New Roman"">“行”时，会在每个机构中增加一个子维度，即显示每个机构（由机构维度当前层次的值决定）的每个日期（由日期维度当前层次的值决定）的数据。</span><span lang="EN-US"> <o:p>
</o:p>
</span></p>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -