Convert a Characteristic into a Key Figure (BEx)
This is a very simple document to demonstrate how to use characteristics in a BEx Query as a part of a calculation.
Example: There are two date: Start Date & End Date (characteristics) in the query and we want to use the difference [End Date - Start Date] in a calculation.
So how to we use a data or any other characteristic in a Formula?
I will explain the same step by step with screenshots.
Here I take an example as a Date.
Step 1: Create a new formula.
Step 2: Create a new Formula Variable.
Step 3: Change the Processing Type to "Replacement Path" and select the characteristic to the characteristic which we need as a key figure.
Note: Make sure the characteristic or the part of the characteristic which you want to use as a key figure is numeric.
Step 4: Go to the "Replacement Path" tab and Select the "Replace with" value as "Key".
Here in the "Offset Setting", you can specify the offset (position of the character) and the "Offset Length" from where you want to use the value as a key figure.
Example: Date is "20120415" (YYYYMMDD) and let's say you want to use the "Day" part of the date as a key figure. I.e. 15. So you set the Offset start as 7 and Offset Length as 2. If you to use the whole date as keyfigure, You can use "Offset Start" as 0 and Offset length as 8.
OR
Step 5: In the formula created in Step 1, insert the formula variable which we created and we have the characteristic ready to be used as a key figure or for calculations.
We can use the same procedure show above to use any characteristic as a key figure.
相關文章
- figure
- expdp, impdp characteristic 特性--索引索引
- Bex Query variable Type 說明
- BCSphere入門教程02:操作 Characteristic
- 執行Bex 出現 61704 錯誤
- Hero Video Convert v2.0 KeyGen(MASM32) (7千字)IDEASM
- SAP RETAIL 特性樹(Characteristic Tree)的定義AI
- BI 7.0 之後的Bex Web ApplicationWebAPP
- SAP RETAIL 特徵引數檔案(Characteristic Profile) IAI特徵
- SAP RETAIL 特徵引數檔案(Characteristic Profile) IIAI特徵
- SAP RETAIL 特徵引數檔案(Characteristic Profile) IIIAI特徵
- [譯] 你認為“figure”怎麼用?
- plt.figure()引數使用詳解
- Figure AI把「終結者」造出來了AI
- Convert object/bean to mapObjectBean
- sql server convert用法SQLServer
- CONVERT DATABASE命令(三)Database
- CONVERT DATABASE命令(二)Database
- CONVERT DATABASE命令(一)Database
- MATLAB將figure視窗儲存為圖片Matlab
- db_file_name_convert和log_file_name_convert詳解
- Convert.ToInt32( null or "")Null
- json convert to stringJSON
- How to Convert Subversion Repo to GitGit
- Convert Array of Objects to Data TableObject
- RMAN CONVERT DATABASE 的限制Database
- SQL Server CONVERT() 函式SQLServer函式
- DocTo convert doc(x) to pdf
- Convert型別轉換型別
- MGETkey[key…]
- BeX5企業快速開發平臺-前端快速開發框架前端框架
- PHP 每日一函式 — 字串函式 convert_uuencode () & convert_uudecode ()PHP函式字串
- koa-convert原始碼分析原始碼
- java convert timestamp to date and timeJava
- 函式: CONVERT_TO_LOCAL_CURRENCY函式
- SQL CONVERT的使用方法SQL
- [Linux] convert .img to .iso fileLinux
- js keyup、keypress和keydown事件JS事件