没有合适的资源?快使用搜索试试~ 我知道了~
首页SAP BPC EvDRE
资源详情
资源评论
资源推荐
The WebExcel
function EvDRE
Reference
documentation
Product Version: 5.0 SP2 and 4.2 SP5(?)
Document Version: 2.0
Last update: March 14, 2007
Written by: Piero Ferreri
OutlookSoft internal use only
1
Reference documentation 错误!未定义样式。
About this version
This document has been updated to include all the changes and enhancements added to the EVDRE
function after its last incarnation in OutlookSoft 4.2 SP3 and 5.0 SP1.
For a detailed listing of all such changes and enhancements see appendix II at the end of this document.
Introduction
EvDRE (“Data Range Expansion”) is a powerful and flexible WebExcel function that can be used to
generate different kinds of OutlookSoft-based reports and schedules in Excel, all with one easy to use
interface.
EvDRE combines and extends the functionality of several other “EV” functions like EvGet, EvSnd, EvExp,
EvNex, etc. While these older functions are still supported for backwards-compatibility of workbooks that
some users may not want to re-design, we expect EvDRE to replace them in the greatest majority of
situations.
The main benefits of EvDRE are:
- It is a do-it-all function, i.e. it can be used in many different situations, allowing the user to only
learn one function to build all his reports and data entry schedules. In fact:
- It can be used for both data retrieve as well as data send operations
- It permits to build static workbooks (without expansions) as well as dynamic workbooks
(with expansions), or mixed-type workbooks, where some dimensions are defined statically
(using hard coded members) and some others are dynamically expanded
- The expansions can be assigned to rows, columns, or both rows and columns simultaneously
and it can also handle expansions across sheets
- It supports any number of nesting in the expansion of both rows and columns
- It permits to build light workbooks that are faster to download and upload, because it does not
require embedding a function in each sent or retrieved cell. It achieves this result by making an
extensive use of cell ranges.
- A custom-built query optimization engine automatically decides the most efficient way to access the
database to retrieve the requested data. In most cases this greatly improves the performance and
scalability of reports and schedules, because, whenever possible, EvDRE reads base-level data
directly from the SQL database, reducing the workload on the OLAP engine, and, when the use of
SQL queries is not possible, it interrogates the OLAP cube using very efficient, dynamically-
optimized MDX queries.
- It automatically builds in the worksheet a “control panel” that allows to easily identify all the
parameters used by the function and their meaning
OutlookSoft internal use only
2
Reference documentation 错误!未定义样式。
- It returns easy-to-understand error messages that allow the user to immediately isolate the source of
a problem
Quick start
You do not need to have a deep knowledge of the features of EVDRE, to start using it. All you have to do,
to build your first EVDRE report, is the following:
In a clean WebExcel worksheet enter this instruction in the top leftmost cell:
=EVDRE( )
Then hit the REFRESH button.
You will be prompted a dialog box that asks you what dimensions you want in columns, what
dimensions you want in rows and a few more details about your report. You may just take what is
proposed by default (or make some simple adjustment), then hit Ok.
Your first report will be automatically built in front of you, nicely formatted and populated with
real data.
(Now let’s get serious…)
The syntax
Here’s the syntax of the EVDRE function:
= EVDRE ( “ApplicationName”, KeysRange [, ExpansionsRange])
The function uses two required and one optional parameter, as here below described:
ApplicationName
This is the name of the application from which to retrieve or where to send data.
KeysRange
This parameter points to a range of cells that in turn must contain the definitions of the “key
ranges” of the report. The key ranges are other ranges that ultimately control the content of the
individual cells of data. The keys range must have two columns and at least 6 rows, as later
described.
ExpansionsRange (optional)
This is an optional range containing the definitions of the expansions (as many as desired) that
must be performed by the function. This range, if existing, must have 7 rows and two (or more)
columns, as later described.
In the following example the ranges corresponding to the three EvDRE parameters are highlighted in
yellow.
OutlookSoft internal use only
3
Reference documentation 错误!未定义样式。
The EvDRE function and its associated parameter ranges do not need to be in the same sheet; they could all
be scattered across different sheets of the current workbook, if desired. This may allow sharing the same
page key range with multiple instances of EvDRE within the same workbook, or simply hide in some other
sheet the most “technical” parts of the function.
The keys range
The KeysRange is a range of 2 columns and 6 (or more) rows as shown in the following example (the
header row shown here below in magenta is not part of the range itself. It is only added for clarity):
RANGE VALUE
PageKeyRange Sheet1!$B$24:$B$31
ColKeyRange Sheet1!$G$3
RowKeyRange Sheet1!$E$5
CellKeyRange
GetOnlyRange
FormatRange
The first column (the RANGE column) contains the name of the ranges. The names are reserved keywords
and must be spelled as shown here. Using a reserved name for each range allows EvDRE to make the
content of this grid non-position-sensitive, and the ranges can be ordered in any sequence. The second
column (the VALUE column) contains the definition of the range, i.e. it is a string defining a range of cells.
Currently all 6 ranges must be included in the KeysRange. However, not all of them must have a value:
only the ColKeyRange and the RowKeyRange are mandatory. All the others may be left blank, when not
needed.
All the ranges specified in the KeysRange, combined with some other WebExcel settings, contribute to
define the content of each data cell, as later described.
OutlookSoft internal use only
4
Reference documentation 错误!未定义样式。
The keys range can also contain two additional, optional rows: one is an Options (or OptionsRange) field,
where some options can be set, and another one is a SortRange field, defining a range of sorting
parameters, as later described.
How the key of a cell is built
The full key (“current view”) of a cell is ultimately controlled by EvDRE “overlaying” onto each cell the
definitions of a current view as defined by any combination of the following settings:
1) The system current view, as defined in the Current View bar
2) The workbook current view, as “parked” in the workbook options, if set.
3) The page current view, as defined in the PageKeyRange, if existing.
4) The column current view, as defined in the ColumnKeyRange
5) The row current view, as defined in the RowKeyRange
6) The cell current view, as defined in the CellKeyRange
These definitions, if in conflict, take precedence from the lowest to the highest in the above list (The cell
key, if existing, wins on the row key, that wins on the column key, that wins on the page key, etc.).
The following example may help understand the mechanism. Here the EvDRE function placed in cell A1
populates the data range F7:G9 (in yellow) using these definitions:
- The ENTITY, the CATEGORY and the VIEW (MEASURES) dimensions are controlled by the
system current view.
- The RPTCURRENCY, the INTCO and the DATASRC are controlled by the PageKeyRange B4:B6
(in green)
- The TIME is set by column by the ColKeyRange F5:G5 (in magenta)
- The ACCOUNT is set by row by the RowKeyRange D7:D9 (in blue)
Following is a more detailed explanation of each key range as used by the function.
OutlookSoft internal use only
5
剩余63页未读,继续阅读
xjtuxjtulin
- 粉丝: 1
- 资源: 1
上传资源 快速赚钱
- 我的内容管理 收起
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
会员权益专享
最新资源
- RTL8188FU-Linux-v5.7.4.2-36687.20200602.tar(20765).gz
- c++校园超市商品信息管理系统课程设计说明书(含源代码) (2).pdf
- 建筑供配电系统相关课件.pptx
- 企业管理规章制度及管理模式.doc
- vb打开摄像头.doc
- 云计算-可信计算中认证协议改进方案.pdf
- [详细完整版]单片机编程4.ppt
- c语言常用算法.pdf
- c++经典程序代码大全.pdf
- 单片机数字时钟资料.doc
- 11项目管理前沿1.0.pptx
- 基于ssm的“魅力”繁峙宣传网站的设计与实现论文.doc
- 智慧交通综合解决方案.pptx
- 建筑防潮设计-PowerPointPresentati.pptx
- SPC统计过程控制程序.pptx
- SPC统计方法基础知识.pptx
资源上传下载、课程学习等过程中有任何疑问或建议,欢迎提出宝贵意见哦~我们会及时处理!
点击此处反馈
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功
评论0