How to delete the leading zero in SAC Dimension from SAP Business Bydesign Datasource?

[Janarthanan]

Hi Everyone,

Hello Everyone,

I'm working on integrating sales orders from an SAP Business ByDesign data source. When refreshing the dimension, data is coming in with leading zeros, even though I set the dimension to an integer in the modeler. Unfortunately, this isn’t trimming the leading zeros as expected. I also tried a script in stories to remove them, but I’m encountering errors. Does anyone know of another way to display the values without leading zeros?

If anyone has faced a similar issue, your advice would be appreciated!

Regards

Janarthanan

+919884594169

meetjana@hotmail.com

SAP Analytics Cloud 

[N1kh1l]

@Janarthanan 

What kind of connection is being used? If its an import  connection, you could truncate the leading 0's in data wrangling while loading the data in the model. If its a live connection, may be you could try a calculated dimension and try to truncate 0's in that.

Nikhil

[Janarthanan]

Hi @N1kh1l, I'm using an import connection (SAP Business ByDesign). I successfully transformed the dimension, but encountered a schedule refresh error related to field mapping. The issue is that the source data type is a string, while the dimension expects a key figure. This is why I attempted to write a script in the stories to resolve it, but haven’t had success.

I can see only two function, On select (or) Result changed 

Regards

Janarthanan