Showing Partial Dimension Members in SAC Chart Using Scripting

[RajuRam]

In SAC charts, is it possible to show partial dimension members using scripting? Specifically, I want to display characters from the 5th to the 12th character.

[Venkat99 · Accepted solution]

Hi,

Try creating this partial dimension members from backend (SAP BW system) and bring it in a separate dimension to display in your widget in SAC.

Thanks!

Venkat

[N1kh1l]

@RajuRam 

Create a calculated dimension and use that in your chart. no need for any scripting.

You can use SUBSTRING operator to get your display characters.

Nikhil

[RajuRam]

Hello Nikhil,

[RajuRam]

Hello Nikhil, I am using BW 7.5 Live connection in which Calculated dimension is not available. We are going to migrate to HANA shortly. I am not sure whether Calculated dimension will work there

[Venkat99]

Hi,

This partial dimension members can be derived using transformations at Model level or Calculated dimension at Widget level. That makes your requirement easier than using scripting.

Thanks,

Venkat