Data Source not found in system via SAP Analytics Cloud Excel Add-in

[former_member767263]

Hi SAP community,

I have created a SAC planning model (TOPLINE) which I am trying to access via SAC Excel add-in.
I have no problem connecting to other models that are in my folder pane, however for this specific model I cannot establish the connection. I receive the error below when I try:

"Data source TOPLINE was not found in system XXX."

In the message section, here is the 2 errors that are generated:

1. Error during initialization of query view:\nDecimalFloat is not a value type! (com.sap.ip.bi.bics.poly.provider.feat.logging.MokuMessage-QUERY_VIEW_INITIALIZATION_EXCEPTION)
2. Data source TOPLINE was not found in system XXX

Would you have any idea what would be the reason behind this ?

Thank you in advance for your help!

Best

Erdem

[Jay_Gandhi]

Hi there,

Is this model an Account-based model or the 'New Model'?

If this is a 'New Model' it is not yet supported with the SAC MS Excel Add-In (but will be later this month).

Jay

[former_member767263]

HI Jay,

Thank you for your prompt response.
The model is an account-based model 😕

[Jay_Gandhi]

Thanks Erdem. You may want to open an SAP Incident with your original above details in that case then.

Jay

[borishais]

Hello Jay, I'm working with Erdem and I confirm it's a Account-based model.We also tried to duplicate the model and these duplicated models are also not reachable by AfO (SAC).

Regrads,

Boris

[borishais]

Hello,

we identified the issue. It's link to an attribute (properties) of one dimension. If a properties for a dimension is set as decimal then the model doesn't work into AfO. We will open an SAP incident.

Regards,

Boris

[borishais]

In addition we found a workaround : we changed the decimal (float) properties from the dimension to integer (factor 10000 on numbers) and now it's working in AfO.

Regards,

Boris

[former_member759836]

Hi Jay,

Is this available for new model. Could you provide me latest patch details.

Regards,

Sheeba

[Jay_Gandhi]

Hi there,

It can be found here: https://help.sap.com/viewer/ccbf41c7f6ff49caa7af5b4b8c2312e7/LATEST/en-US/6f66fdf47b124b6aa3f86d93bb...

In version 2021.20.

Jay