Question Re: Output forecasted Data as Table (SAP Analytics Cloud) in Technology Q&A

Output forecasted Data as Table (SAP Analytics Cloud)

Former Member — Wed, 30 Jan 2019 13:28:05 GMT

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

Re: Output forecasted Data as Table (SAP Analytics Cloud)

TammyPowlas — Wed, 30 Jan 2019 14:38:40 GMT

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

Re: Output forecasted Data as Table (SAP Analytics Cloud)

Former Member — Wed, 30 Jan 2019 15:24:47 GMT

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?

Re: Output forecasted Data as Table (SAP Analytics Cloud)

TammyPowlas — Wed, 30 Jan 2019 15:30:38 GMT

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 -

Re: Output forecasted Data as Table (SAP Analytics Cloud)

Former Member — Wed, 30 Jan 2019 22:48:02 GMT

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?

René

Re: Output forecasted Data as Table (SAP Analytics Cloud)

Henry_Banks — Thu, 31 Jan 2019 10:53:29 GMT

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

Re: Output forecasted Data as Table (SAP Analytics Cloud)

Henry_Banks — Thu, 31 Jan 2019 10:56:23 GMT

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,

Re: Output forecasted Data as Table (SAP Analytics Cloud)

achab — Fri, 01 Feb 2019 10:20:32 GMT

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)

Re: Output forecasted Data as Table (SAP Analytics Cloud)

Former Member — Thu, 07 Feb 2019 07:26:31 GMT

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/5a1ee6dab7ff428d9d94eb7d71c1e50f.html

René