Cell Styles in AFO vs Styling in SAC

[vinothvasudevan]

Hello All,

I have a AFO report built on top of a CDS view. The decimals placement of values have been set as 0.0 for all the measures at the CDS itself.

In our report, we have two dimensions as Earnings Per Share and Dil Shrs Out and on these two dimensions alone I want the decimals to be visible as 2 decimals and No Decimals respectively in SAC Story.

I am able to achieve this in AFO via cell styling but I believe in SAC, the decimals cannot be modified for an individual measure/dimensions. I had tried style in SAC story but no luck.

I would like to confirm my understanding from you all and also see if any options available to handle this scenario in SAC story.

Any insights and guidance would be helpful.

Regards,

Vinoth V

[Jay_Gandhi]

Hi Vinoth,

I'm not sure if you're reporting in SAC off of the same CDS view or local (acquired) method.

Depending on the above you do have a couple of options:

1. You can set at the model level within SAC the number of decimal places for that particular measure(s) (0 for one of them and 2 for the other), please see here: https://help.sap.com/docs/SAP_ANALYTICS_CLOUD/00f68c2e08b941f081002fd3691d86a7/bc9f0eb2da1848dd9d392...

2. At the Story-level you can use Styling options by selecting the particular measure and changing the decimal places, please see here: https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/2019.21/en-US/4b3d8bfd42964efba319ed6580fa...

[vinothvasudevan]

Hello Jay,

Thank You for the response.

I am building the SAC report on top of the same CDS view (Live) that acts as a source to AFO as well.

I tried option 2 via Styling to create a new style and tried applying the decimals for a particular cell against dimension "Earnings Per share" for example but the decimal value is impacting the whole measure instead of impacting only on that cell or row.

However, will check again on option 2 and revert.

Regards,

Vinoth V

[vinothvasudevan]

Hello Jay,

I had tried the option 2 again but as I mentioned the styling impacts the whole column of the measure instead of impacting that particular cell.

Regards,

Vinoth V