SAC - BW live connection - Date difference

[ray-ping_duh]

Hello,

We want to calculate the difference between two Dates, they are both Dimensions.

They are sent via BW live connection to SAC dashboard.

We found there is no “calculation” can be done in Dimensions in Story,

and in Model we cannot convert these Date as measure,

there is also no possibility to create new measure because of BW live connection.

Does anyone have related experience? We prefer to solve it in SAC dashboard, not intend to change data source.

Best regards

Ray and Shiwei

[N1kh1l · Accepted solution]

ray-ping.duh

According to the note below, date based calculation are still not supported in BW Live Connection. I think you should calculate the date difference in source itself and consume in SAC.

2788384 - Unsupported Features with SAP BW, SAP S/4HANA and SAP BPC Embedded Model Live Connections ...

Excerpt from the note:

Calculation Editor

• Calculated dimensions
• Date-based calculations (date difference, difference from)
• Cross calculations

Please Note: I see it as supported feature in 2023. QRC 1 release. Refer to the blog below.

https://blogs.sap.com/2023/01/18/sneak-peek-into-sap-analytics-cloud-release-for-q1-2023/

Hope this helps !!

Nikhil

[ray-ping_duh]

Thank you Nikhil and Aleksey!

After trys in the last days, we decided to request our backend to support a new measure.

Thank you for the information!

Best regards

Ray and Shiwei

[avsalynin]

ray-ping.duh

yes, I confirm. On the tenant with version 2023.2.1 with BW live, there is already a similar calculation option available.