Output forecasted Data as Table (SAP Analytics Cloud)

[Former Member]

Hi all,

I'd like to output the data that SAP Analytics Cloud forecasted in the built-in 'predivtive forecast' as a table or something similar, not just as a chart.

Is that possible?

Thanks in advance.

Chris

[Henry_Banks]

Hi,

you should be able to do this to some extent, using the following approach:

You'll need to a planning enabled mode. Then you can work with the grid component, and create a forecast version (private copy at first).

then in the table you can click forecast (icon has moved to the toolbar recently) - see screenshots.

Kind regards,

H

[Former Member]

Hi you could create a model on top of your predictive model (first apply the predictive model) - and the create a story with a table build on your model

the table includes all the information you want exported, then export to csv

or use analysis for office to connect to your model (that is build on top of your applied model table)

is this something you where looking for?

Br

René

[Henry_Banks]

Hi Rene, that's a good hint - but not everyone will have this option

Depending on whether they are deployed to the 3rd party data centres (i.e. Cloud Foundry on AWS deployment option), they will get the more advanced Smart Predict scenarios with the dataset concept.

However, that subscription type only came about since about September, and only in some regions.

Regards, H

[achab]

Just adding my two cents on what Rene & Henry both rightfully mentioned. The reference SAP note related to Smart Predict availability can be found here https://launchpad.support.sap.com/#/notes/2661746.

Cheers,

Antoine (Smart Predict Product Manager)

[Former Member]

Hi maybe you could take a look here

https://apps.support.sap.com/sap/support/knowledge/public/en/2540886

https://help.sap.com/doc/00f68c2e08b941f081002fd3691d86a7/release/en-US/5a1ee6dab7ff428d9d94eb7d71c1...

br

René

[TammyPowlas]

Chris - the only current way I see is to export the output to a CSV and upload that to SAP Analytics Cloud

I tried searching for an existing idea here: https://influence.sap.com/sap/ino/#/campaign/884 - something you may want to check

[Former Member]

Hi Tammy, thanks for the quick response. Somehow, I can only download a CSV with the data I already uploaded which is excluding the forecasted data. Do you know how to do that?

[TammyPowlas]

You are right, Chris. I just noticed it doesn't export the forecast. I recommend entering it as a suggestion here: https://influence.sap.com/sap/ino/#/campaign/884 -