Convert a Characteristic into a Key Figure (BEx)

本文详细介绍了如何在BEx查询中利用特性进行计算与公式操作,包括创建新公式、变量,以及如何正确配置特性作为关键指标。通过实例演示了如何将日期特性用于计算差异,并说明了在不同场景下使用特性的具体步骤。

摘要生成于 C知道 ,由 DeepSeek-R1 满血版支持, 前往体验 >

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.

 

### GATT Characteristic 2A1A Definition and Usage In Bluetooth Low Energy (BLE), characteristics are used within services to define specific properties of data being exchanged between devices. Each characteristic is identified by a unique UUID, which may be either a standard 16-bit or full 128-bit value. The characteristic with the identifier `2A1A` corresponds to the Temperature Measurement characteristic[^4]. This particular characteristic belongs to the Environmental Sensing service and serves as an essential component for applications requiring temperature monitoring capabilities over BLE connections. #### Data Structure and Format Temperature Measurement (`2A1A`) contains information about measured temperatures from sensors connected to the BLE device. According to specifications outlined in official documentation: - **Format:** The format includes flags indicating various aspects such as unit type (Celsius vs Fahrenheit) along with actual measurement values. - **Unit Types Supported:** - Celsius degrees represented using signed integers scaled appropriately based on resolution requirements. For instance, when working with this characteristic programmatically in Android environments, developers would handle updates through callback methods like so: ```java @Override public void onCharacteristicChanged( BluetoothGatt gatt, BluetoothGattCharacteristic characteristic ) { if ("00002a1a-0000-1000-8000-00805f9b34fb".equals(characteristic.getUuid())) { byte[] data = characteristic.getValue(); // Process received temperature data... } } ``` This code snippet demonstrates how one might implement logic inside an overridden method defined within a custom implementation extending `BluetoothGattCallback`. When changes occur at remote endpoints regarding environmental sensing attributes including but not limited to those pertaining specifically towards thermal conditions monitored via sensor readings encoded under said universally recognized identifiers; these events trigger corresponding actions locally upon receipt thereof ensuring real-time synchronization across paired entities participating within wireless communication sessions facilitated through standardized protocols established around Generic Attribute Profiles [^2].
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值