Skip to content
NextLytics
Megamenü_2023_Über-uns

Shaping Business Intelligence

Whether clever add-on products for SAP BI, development of meaningful dashboards or implementation of AI-based applications - we shape the future of Business Intelligence together with you. 

Megamenü_2023_Über-uns_1

About us

As a partner with deep process know-how, knowledge of the latest SAP technologies as well as high social competence and many years of project experience, we shape the future of Business Intelligence in your company too.

Megamenü_2023_Methodik

Our Methodology

The mixture of classic waterfall model and agile methodology guarantees our projects a high level of efficiency and satisfaction on both sides. Learn more about our project approach.

Products
Megamenü_2023_NextTables

NextTables

Edit data in SAP BW out of the box: NextTables makes editing tables easier, faster and more intuitive, whether you use SAP BW on HANA, SAP S/4HANA or SAP BW 4/HANA.

Megamenü_2023_Connector

NextLytics Connectors

The increasing automation of processes requires the connectivity of IT systems. NextLytics Connectors allow you to connect your SAP ecosystem with various open-source technologies.

IT-Services
Megamenü_2023_Data-Science

Data Science & Engineering

Ready for the future? As a strong partner, we will support you in the design, implementation and optimization of your AI application.

Megamenü_2023_Planning

SAP Planning

We design new planning applications using SAP BPC Embedded, IP or SAC Planning which create added value for your company.

Megamenü_2023_Dashboarding

Dashboarding

We help you with our expertise to create meaningful dashboards based on Tableau, Power BI, SAP Analytics Cloud or SAP Lumira. 

Megamenü_2023_Data-Warehouse-1

SAP Data Warehouse

Are you planning a migration to SAP HANA? We show you the challenges and which advantages a migration provides.

Business Analytics
Megamenü_2023_Procurement

Procurement Analytics

Transparent and valid figures are important, especially in companies with a decentralized structure. SAP Procurement Analytics allows you to evaluate SAP ERP data in SAP BI.

Megamenü_2023_Reporting

SAP HR Reporting & Analytics

With our standard model for reporting from SAP HCM with SAP BW, you accelerate business activities and make data from various systems available centrally and validly.

Megamenü_2023_Dataquality

Data Quality Management

In times of Big Data and IoT, maintaining high data quality is of the utmost importance. With our Data Quality Management (DQM) solution, you always keep the overview.

Career
Megamenü_2023_Karriere-2b

Working at NextLytics

If you would like to work with pleasure and don't want to miss out on your professional and personal development, we are the right choice for you!

Megamenü_2023_Karriere-1

Senior

Time for a change? Take your next professional step and work with us to shape innovation and growth in an exciting business environment!

Megamenü_2023_Karriere-5

Junior

Enough of grey theory - time to get to know the colourful reality! Start your working life with us and enjoy your work with interesting projects.

Megamenü_2023_Karriere-4-1

Students

You don't just want to study theory, but also want to experience it in practice? Check out theory and practice with us and experience where the differences are made.

Megamenü_2023_Karriere-3

Jobs

You can find all open vacancies here. Look around and submit your application - we look forward to it! If there is no matching position, please send us your unsolicited application.

Blog
NextLytics Newsletter Teaser
Sign up now for our monthly newsletter!
Sign up for newsletter
 

The new file upload in SAP Analytics Cloud and its possibilities

In our previous article ‘SAP Analytics Cloud File Upload Custom Widget - A tool with potential’, we already introduced data upload using a widget. With the Q3/2024 release, SAP has now integrated file upload as a standard functionality. This allows the planner to quickly upload the plan values saved in local Excel or CSV files into SAP Analytics Cloud Stories.

A dedicated data import job is created in the model management using a template. The user can then use this in the story via an upload starter. In this article, we will demonstrate how it works in detail and where we see potential for improvement.

Detailed procedure

To use the upload in a story, a few settings must first be configured in the backend. To do this, a new upload job is created in the model's data management. The structure of the selected file is used as a template for future uploads. The assignments and transformations defined in this step cannot be changed by the user. This is to ensure that users operate via a uniform and verified interface.

001-create-upload-job_file upload

Clicking Set up upload takes you to data preparation. Here you can create transformations, assign columns to existing dimensions and also check the upload. In the first step, the data can be converted into a uniform format. In our example, we transform the date and amount into the SAP Analytics Cloud format.

002-transformation_file upload

The applied transformations can be viewed and edited in the transform log.

003-transform-log_file upload

In the next step, the columns from the file are assigned to the dimensions of the model. You can also set default values ​​for dimensions. In our example, we set the version to Plan by default. As soon as all source data has been assigned to the corresponding target data, you can check the import.

004-map-to-facts_file upload

If no errors are found, you can then adjust the import settings. You can specify whether the uploaded data should overwrite the existing values ​​or be appended to them. In addition, provided your model uses an account dimension, signs for INC (income) and LEQ (liabilities and equity) account types can be reversed.

005-import-settings_file upload

Once the upload job has been set up in the model, it can be used in the story. A dedicated data upload starter is required for this purpose.

006-data-upload-starter_file upload


SAP Planning Tools Compared -
Download the Whitepaper here! 

Neuer Call-to-Action


It is inserted into the story and linked to the previously defined upload job.

007-data-upload-starter_file upload

Finally, the story can be used by the planner. They can select the file and the CSV delimiter. All other settings are taken from the template.

008-select-file_file upload

After the upload, a status message is displayed. The upload can either be successful, successful with warnings or failed. If certain data records were rejected, a CSV file with the reason for rejection can be downloaded.

009-status-success_file upload

010-status-warning_file upload

In addition, a log of all uploads can be viewed in the model's data management.

011-data-timeline_file upload

The new file upload in SAC- Our Summary

Compared to the previous solution ‘Upload via the widget’, we have noticed a significant improvement in performance. The integration of data preparation also opens up new possibilities. However, we have also identified a few points that need improvement.

For example, the import dialogue is not yet available in German. Important settings for users that we are familiar with from NextTables are also missing. For example, the option to adjust thousands and decimal signs on the fly. We also miss a status display that shows the progress of the upload in NextTables. Unfortunately, the incorrect records are only available as a CSV download, there is no integrated report. Also, the incorrect records cannot be corrected immediately, as we are used to in NextTables.

Overall, however, this is a helpful function that meets the essential requirements. We look forward to further improvements in this area and will continue to keep you updated.

Do you have questions on this or another topic? Simply get in touch with us - we look forward to exchanging ideas with you!  

Learn all about Planning with SAP Analytics Cloud

 

,

avatar

Chris

Chris Fidanidis has been working in the SAP BW environment since 2007. During these years he has implemented several planning projects and used various SAP tools such as SAP BSP, SAP BW-IP, SAP BPC, SAP BW Embedded BPC. He has gained experience primarily as a developer, architect, project manager and team leader. He enjoys playing basketball and barbecue whenever possible.

Got a question about this blog?
Ask Chris

The new file upload in SAP Analytics Cloud and its possibilities
3:45

Blog - NextLytics AG 

Welcome to our blog. In this section we regularly report on news and background information on topics such as SAP Business Intelligence (BI), SAP Dashboarding with Lumira Designer or SAP Analytics Cloud, Machine Learning with SAP BW, Data Science and Planning with SAP Business Planning and Consolidation (BPC), SAP Integrated Planning (IP) and SAC Planning and much more.

Subscribe to our newsletter

Related Posts

Recent Posts