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
 

SAP Analytics Cloud File Upload Custom Widget - A tool with potential

In our SAP Analytics Cloud planning projects, we always strive to create an optimal planning environment for the user instead of an input layout. However, many users still want to upload the values they have planned in Excel to the application. Instead of fighting against this, it is worth giving way a little in order to move the planning process towards a consolidated data platform.

Gradually, the user can then be convinced of the benefits of the SAP Analytics Cloud (SAC) environment. Useful SAC functions such as versioning, inverse formulas or version control are not available in Excel. Until now, however, there was no upload function for end users in SAC. SAP has responded with a custom widget that is intended to close the gap in the short term. At the same time, SAP is working on an integrated flat file upload data action. Until then, we'll deal with the custom widget.

Installing and using the custom widget: An easy way to get started

The custom widget can be downloaded from SAP's Github and installed by an administrator. The installation takes place in the Stories section under the Custom widgets tab.

install-widget_SAC_File_Upload_Custom_Widget

 

The widget can then be used in stories with the optimized story experience. You can specify whether the data should be uploaded to a public or private version.  You can also customize the mapping of the columns. You can set default values for entries that are not included in the file.

 

insert-widgetSAC_File_Upload_Custom_Widget

 

In the Job Settings section, you can also define whether the sign should be reversed in the account dimension according to the Income (INC) or Expense (EXP) account category. You can also define whether the correct data should be updated, even if there are incorrect data records. If this setting is not active, the data is only imported if all data records pass the validation check. You can also define that the columns contained in the file, which are not relevant for the import process, are ignored.

job-settingsSAC_File_Upload_Custom_Widget

 

Finally, you can use user-defined date formatting. If this setting is inactive, the date format in the file must match the format in the SAC model. If you select a custom format, this will be used to convert the data into the SAC-compliant format.


SAP Planning Tools Compared -
Download the Whitepaper here! 

Neuer Call-to-Action


Once the configuration has been completed, users can easily start the data import by clicking on the button. All they have to do is select the source file and start the import process.

upload-dataSAC_File_Upload_Custom_Widget

 

The import can also be carried out in the background. Once the data has been successfully validated, the data is immediately visible in the table and a success message is displayed in the widget.

import-completedSAC_File_Upload_Custom_Widget

 

If the import fails, a corresponding message is displayed. By clicking on the info icon, you can download a log file containing the incorrect data records with an explanation.

import-failedSAC_File_Upload_Custom_Widget

failed-recordsSAC_File_Upload_Custom_Widget

 

Conclusion and future developments: A look ahead

SAP Analytics Cloud File Upload Custom Widget covers the basic functions. However, we miss some functions that you know from NextTables. For example, the option for users to adjust decimal separators and thousands separators on the fly is missing. There is also no status display to show the progress. We have noticed that importing small files takes a relatively long time. We suspect that the lion's share of this is due to validation.

Users who come from the BPC world and are looking for an equivalent to uploading files with Analysis for Office (0RSPL_FILE_UPLOAD_AO) will find the right function in the SAC in this widget.

Overall, however, the widget is very helpful and gives developers a breather. We are already looking forward to the Q3 release, which will make the integrated upload function available to users.

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

Alexander

Alex is working at Nextlytics since 2021 as a BW consultant. He mainly works on SAC Planning, BPC and BW/4HANA topics. In his free time, he likes to go jogging, play soccer and tries to travel as often as possible.

Got a question about this blog?
Ask Alexander

SAP Analytics Cloud File Upload Custom Widget - A tool with potential
3:54

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