📄 2.3.html
字号:
<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">(</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>
<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_i1038"
type="#_x0000_t75" style='width:327.75pt;height:246pt'>
<v:imagedata src="../../../../DOCUME~1/ADMINI~1.ACC/LOCALS~1/Temp/msoclip1/01/clip_image009.jpg"
o:title="mm-9"/>
</v:shape><![endif]-->
<img src="/resources/images/help/2.3.files/wpe5.jpg" v:shapes="_x0000_i1038" width="437" height="328"></span></p>
<p class="MsoNormal"><span style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">在“机构投入产出”多维查询中，选择“指标”选择菜单中的“收入合计”，则表格中显示的数据就是在当前维度下（就是某个机构，某个时间下）的收入合计的值。而选择“指标”选择菜单中的“利息支出”，则表格中显示的数据就是在当前维度下利息支出的值。</span><b><span lang="EN-US"><o:p>
</span></b><b><span lang="EN-US"> <o:p>
</o:p>
</span></b></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 style="font-family:宋体;mso-ascii-font-family:"Times New Roman";
mso-hansi-font-family:"Times New Roman"">作为行总计的</span><span lang="EN-US">
%</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></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></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></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></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_i1039"
type="#_x0000_t75" style='width:323.25pt;height:242.25pt'>
<v:imagedata src="../../../../DOCUME~1/ADMINI~1.ACC/LOCALS~1/Temp/msoclip1/01/clip_image011.jpg"
o:title="mm-10"/>
</v:shape><![endif]-->
<img src="/resources/images/help/2.3.files/wpe6.jpg" v:shapes="_x0000_i1039" 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></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"> <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><span lang="EN-US">%</span><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">%</span><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">%</span><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">%</span><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"> <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><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 lang="EN-US">MEASURES</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 lang="EN-US"><!--[if gte vml 1]><v:shape id="_x0000_i1040"
type="#_x0000_t75" style='width:332.25pt;height:249pt'>
<v:imagedata src="../../../../DOCUME~1/ADMINI~1.ACC/LOCALS~1/Temp/msoclip1/01/clip_image013.jpg"
o:title="mm-11"/>
</v:shape><![endif]-->
<img src="/resources/images/help/2.3.files/wpe7.jpg" v:shapes="_x0000_i1040" width="443" height="332"></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><span lang="EN-US"> <o:p>
</o:p>
</span></p>
<p class="MsoNormal"><span style="mso-tab-count:1" 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>
<p class="MsoNormal"><span style="mso-tab-count:1" lang="EN-US">
</span><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><span lang="EN-US">MEASURES</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>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -