Skip to Content
Author's profile photo Former Member

PA – How it should work (Time series analysis)

Dear readers,

Four weeks ago, I documented my first steps in PA here:–time-series-analysis
My questions ( ) were all answered, unfortunately I did not have much time since then to continue a more detailed analysis.

One more fact contributed in neglecting that topic: The tool is just not handily enough for my purpose!

I don’t want to spend hours in finding out how to use those KxShell script language, so I got quite annoyed after repeating all the required single steps to predict the share values per single company.

At least, I decided to create second – and for the time being –  last blog about “PA – how it should work”:

Most important thing is: I want to analyze more sets of data (e.g. different companies) at once, uploaded from ONE single csv file!

That means, I would like to see an additional characteristic e.g. between Target and Weight, like “Category” which differentiates the individual data sets.

In my case it would be the WKN (ISIN) which organizes the split of companies to be analyzed:


The idea is that I want to be able to execute the steps like loading the Source data, loading the Description file (which is identical for all sets) and selecting my variables (also the same for all sets) only once.

I guess there are reasons I don’t understand yet, but in my personal opinion, the PA engine should be able to use the different data sets to recognize the overall trend, too. Not necessarily always, but e.g. on demand by another checkbox, for independent or inter-dependent analysis.

Finally of course, the Forecasts should be enhanced by the category, which enables a Filter to select one set after the other and analyze the outcome. E.g.:


In that way it would be possible to check the results for e.g. 10 companies within seconds. As of now repeating all steps over and over again to create the forecast graphs takes ~5 minutes for one. And this each time!

In addition I found two more “bugs”, for which I don’t have an explanation or don’t know the root cause?!

I saved a data model 4 weeks ago, and now wanted to create the chart again, but it looks like this:


Whereas 4 weeks ago it looked like this (the red line above is the green one below):


It seems PA recognizes the current date (Operating system date?) and finds 4 missing weeks from the source data to today and therefore does not work properly anymore. Could that be?

I just loaded the model and displayed the chart. The current version with outliers in every week never ever appeared before.

Then, two more things were strange…

I tried to use the PA test version two days before expiration date… SAP, tell me please what is this?

Expiration message_klein.png

An information message which exceeds the monitor screen’s height, where you cannot see the bottom or any “OK”-button?

Second strange thing was that I could not load my files anymore.

Every time I tried to browse the Folder or the Data Set the whole program closed without any message. Neither warning nor error message.

I’m just not able to create a new time series analysis again. Only loading my old model still works.

Final summary: Even if – or maybe especially because – I’m from IT department and know how an “ergonomic” software should work, I’m quite disappointed about the features (I used version 2.2).

The quality of my predicted data result seems to vary tremendously. Either there are up to +/- 40% min/max values or sometimes also none.

The MAPE value however seems always good (~ 0,0xx) if I skip those variables which PA identifies as suspicious.

Of course I must admit that my evaluation is solely based on time series analysis, but in the current state I cannot see any added value which justifies the license costs.

Maybe I need to collect daily data for better results. But the effort here is huge, especially when prediction can only be done for one set after another. And I don’t want a day-based forecast but I want results and a trend (always!) for the next 12 to 24 weeks.

Thanks for reading,


PS: Feel free to share a document/blog post if you know one, about “Creating a KxShell script for dummies” that describes what I would like to have had with my “category” above.

Assigned Tags

      You must be Logged on to comment or reply to a post.
      Author's profile photo Andreas Forster
      Andreas Forster

      Hi Martin, I can comment on your question in the PS.

      The following tutorial explains how to use the script to forecast multiple time series.


      Author's profile photo Antoine CHABERT
      Antoine CHABERT

      Hi Martin, first of all thanks for the detailed blog.

      As I already mentioned before, can you please do a short description of your idea about "category" here: Predictive Analytics: Home

      I take this idea as "I want to perform this from the user interface and not use scripting whatsoever", please confirm.

      You can link to this blog.

      Thanks & regards

      Author's profile photo Antoine CHABERT
      Antoine CHABERT

      Also can you please create separate posts in case you face problems with the software?

      Thanks & regards


      Author's profile photo Former Member
      Former Member
      Blog Post Author

      Hello Antoine,

      thanks for your feedback... no, I will not create a new idea because I won't support this strategy of SAP anymore.

      Coming from the "BO Analysis for MS Office" ideaplace in mind, where a tool was promoted as "premium alternative" to a predecessor tool, but eventually did not contain many basic features, which were available for years.

      Instead they also told us to create ideas for it ... some of them are 2-4 years old without any progress, at all. Why should I create "ideas" for things that are well-known?

      If you have ever used Excel Pivot you know exactly what my "idea" is about 🙁

      And no again, I will not post my problems separately as I don't want any answers.

      A blog is there to share experiences... those were mine. I'm not satisfied, that's it.

      Best regards,


      Author's profile photo Antoine CHABERT
      Antoine CHABERT

      Hello Martin,

      From my (product manager) perspective, the idea place remains an important channel for hearing more about the "voice of the customer", this is the reason why I am promoting it. 

      It's great to have blogs like yours sharing experiences (whether positive or negative), and we learn from that - but when it comes to aggregated user wishes, idea place is really the suited tool. Just over the previous week-end, there was a similar ask as yours made by another SCN user.

      Because SCN content is posted frequently, the visibility of older blog posts tend to vanish at some point.

      My 2 cents here,

      Best regards,