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
- 7.60 CONVERT
- SAP RETAIL 特性樹(Characteristic Tree)的定義AI
- SAP RETAIL 特徵引數檔案(Characteristic Profile) IAI特徵
- SAP RETAIL 特徵引數檔案(Characteristic Profile) IIAI特徵
- SAP RETAIL 特徵引數檔案(Characteristic Profile) IIIAI特徵
- PHP 每日一函式 — 字串函式 convert_uuencode () & convert_uudecode ()PHP函式字串
- [譯] 你認為“figure”怎麼用?
- plt.figure()引數使用詳解
- Python convert string to unicode numberPythonUnicode
- [Linux] convert .img to .iso fileLinux
- DocTo convert doc(x) to pdf
- Convert型別轉換型別
- How to Convert a Class File to a Ja
- Figure AI把「終結者」造出來了AI
- PIL.Image convert to numpy array
- 淺析Convert,Parse和TryParse
- matlab convert to PGM P2Matlab
- koa-convert原始碼分析原始碼
- 19c RAC Convert to OneNde
- 19c OneNode Convert to RAC
- C# convert ImageSource to byte arrayC#
- 538-Convert BST to Greater Tree
- Convert a normal Git repository to a bare oneORMGit
- mysql中key 、primary key 、unique key 與index區別MySqlIndex
- Redis熱點key大keyRedis
- MATLAB將figure視窗儲存為圖片Matlab
- 11gR2 RAC convert ONENODE
- 11gR2 OneNode Convert RAC
- 4.3.2.2.1 The SEED FILE_NAME_CONVERT Clause
- Convert a Physical Standby Database into a Snapshot Standby DatabaseDatabase
- LeetCode之Convert BST to Greater Tree(Kotlin)LeetCodeKotlin
- WPF SelectedItemCollection convert to IList and List, such as Datagrid SelectedItems
- How to Convert Class File to Java File Online?Java
- 大Key
- 熱Key
- 108-Convert Sorted Array to Binary Search Tree
- 「Python」Convert map object to numpy array in python 3PythonObject
- java.sql.SQLException: Fail to convert to internal representationJavaSQLExceptionAI