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.
Ray and Shiwei