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
 

Manual data collection and maintenance in SAP Datasphere

The ability to enter data directly into a table is one of the most common requirements we encounter in every project. Regardless of whether it is a BW on HANA, BW/4HANA or Datasphere project. As there have been more and more SAP Datasphere implementations recently, we are also increasingly confronted with this requirement. In this article, I will show you how manual data maintenance is possible in SAP Datasphere and also present possible alternatives.

SAP Datasphere Data Editor

The ability to enter data directly into the table reduces the effort required to obtain suitable data for analytical use cases. Data maintenance is simplified and the efficiency of business users is increased.

SAP Datasphere offers the table editor for manual data entry and maintenance. You can use this integrated tool to add, edit, duplicate or delete data records in the local table. To do this, select the table you want to maintain on the Data Builder initial page and then click on the Data Editor button in the top right-hand corner.

data-editor_data_collection

You can now add new data records or adjust existing ones. Please note that the key columns of existing data records cannot be edited. If your input does not include all of the existing columns, i.e. some columns remain empty, you can set whether empty string values are inserted as NULL (initial) or empty values. All new empty cells that contain strings will be automatically filled with the selected value.

data-editor-overview_data_collection

Existing lines can be duplicated and adjusted. This is particularly useful if multiple data records need to be entered that only differ in one characteristic. Several empty rows can also be added at once, but the rows cannot be filled by copying and pasting Excel rows. To edit several data records at once, you can also use the find and replace function.

find-and-replace_data_collection

Unwanted changes - such as accidentally changed or deleted values in columns - can be undone using the Restore button. Unfortunately, deleted rows cannot be restored.

SAP Datasphere also offers the option of hiding certain columns and adjusting the sorting via settings. Users can also use filters to restrict data maintenance to certain values.

columns_data_collection

sort_data_collection

filter_data_collection

In addition to manual data entry, a flat file upload is also possible. This option is covered in a separate article.


Sign up as Early Adopter! 

Sign up as Early Adopter! Want to receive early access to the new version?  You will get exactly that by signing up as an Early Adopter, alongside additional exclusive sneak-previews and influencing options in the following months.   Become an Early Adopter 


Limitations

SAP Datasphere Data Editor offers the basic functions required for data maintenance. However, in addition to the weaknesses already mentioned, there are other limitations. For example, I find it unfortunate that the data can be imported into the table but not exported again. This requires a detour via the database explorer. A corresponding database user must be created in the respective space. As a result, users have to find their way around another tool. While the data editor is still relatively easy to use, I am afraid that users from the business department will be overwhelmed by the database explorer.

database-users_data_collection

In addition, only a technical validation of the data takes place. For example, it is not possible to enter letters in number fields. However, the values entered are not checked semantically. It is currently not possible to ensure that users enter meaningful data. Moreover, the value help is missing, so the user does not receive any help in finding valid values. Furthermore, it is not possible to lock certain fields and thus protect them from changes.

file-type-check_data_collection

NextTables as alternative

To address these weaknesses, NextLytics brings the proven NextTables solution to Datasphere. NextTables supports the maintenance and processing of data in SAP Datasphere and provides all the functions you already know and appreciate.

This allows you to add new data or edit existing data directly in the browser. Alternatively, you can also upload Excel and CSV files using drag & drop. Data quality is ensured thanks to the integrated technical check and user-defined validation logic. The state-of-the-art and business-oriented user interface is optimized for business users and ensures that they quickly get familiar with the tool.

NextTables-Datasphere-WIP_data_collection

In addition, NextTables for SAP Datasphere offers many customization options for the IT department to take possible customization requests into account. In addition to SAP Datasphere, other databases are also supported. Sounds interesting? Then you'll be pleased to know that we offer a free early adopter program that you can sign up for now so you can be one of the first users to test the new SAP Datasphere integration with NextTables.

Registered early adopters will receive exclusive sneak previews and the opportunity to influence the product by sharing their use cases with us in the following months. Be one of the first and sign up for the new version now!

Would you like to learn more about NextTables? Here we present the current version of NextTables in detail and show you all possible applications in our feature gallery. Or do you have questions about SAP Datasphere? Are you trying to build up the necessary know-how in your department or do you need support with a specific issue? We are happy to help you. Simply contact us!

Learn more about  SAP Datasphere

,

avatar

Bernhard

Bernhard has been professionally at home in the SAP world since 2013. As a front-end developer, the focus was on SAP Analytics Cloud and SAP BW. Due to the large number of projects he has completed, he has been able to gain experience in requirements gathering, project management and architect roles in addition to development and is now Product Owner of NextTables. In his private life, Bernhard is a hobby cook and enjoys hiking or dancing.

Got a question about this blog?
Ask Bernhard

Manual data collection and maintenance in SAP Datasphere
5:16

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