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
 

How to maintain transformation rules for SAP BW in NextTables

Do you need a manageable set of rules that can be maintained by business users and easily consumed in SAP BW  ETL processes? Let me paint a picture for you. Lets say you want  to have a Rule to determine a missing “Sales Manager” by checking the “Product” and “Country” value. So if the “Product” equals “NextCola” and the “Country” equals “Germany” the assigned “Sales Manager” should be “Sebastian Uhlig.”
And now you want to do that scaled up with many variations and fallbacks defined by multiple  business departments in multiple data models.

We have great news!
You can use the Master/Detail feature included from Version 11+ to maintain Rules for data transformations with our NextRules Code Addon. NextRules is a simpler and more user-friendly rule engine than the usual suspects of the Business Rule Framework Plus (brfplus) or the HANA Rules Framework.

The business can set values for input and output for data derivations. This allows you to dynamically implement data transformations and let the business department maintain the rule values, removing any maintenance efforts from the IT.

NextRules comes with a few new aDSOs and BAdIs which you can further customize to your requirements. It also comes with Pre-configured NextTables Apps for both setting up Rules as well as Rule Maintenance for business departments.
The Addon is implemented really dynamically and generically. IT can set up Rule Areas and individual Rules with definitions on which InfoObjects should be available for Input and Output and what Priority any given Rule should have.
The business departments then can add values to the rules, with automatically restricted Inputs and Outputs, allowing only valid values for the selected Rules.
The values stored in our aDSO can then be used to derive data in SAP BW transformations or any ETL process dynamically.

To see when a rule or its value was last modified and by whom, we’re using our Changelog-Feature which is generally available for all tables. 


Too technical for you?
Let us show you how NextRules works in a live demo!

Get your free live demo or trial version!     * Developed and tested for SAP BW on HANA, SAP S/4HANA, SAP BW/4HANA   * free live demo by one of our Senior Consultants   * free trial license for 30 days   * Installation guidelines and transports for installation will be provided  after processing and clarification of any queries   Apply now for a live demo  or trial license    


 

Initializing NextRules

NextRules allows IT to set up Rule Areas and Input/Output options before giving the business access to NextRules application.
Rule Areas can be used to give context for individual rules but are also great for use in authorizations, so that different departments can only see one or multiple specific rule areas. Input/Output options need to be defined, to ensure the right InfoObjects are used. Those are then needed for our masterdata value help, but also for the later processing of the rules. 

Setting up Rules

After initializing you can start actually creating the rules according to your business needs. Each rule can be assigned a priority and gets an automatically incremented ID. Per rule, you can now define a valid Input/Output combination generating a SubRule ID.
Sticking with our example, two inputs “Product” and “Country” can be defined with “Sales Manager” as an output, meaning the “Sales Manager” will be derived from the two inputs. Then you can create a second rule with a lower priority that just derives the output “Sales Manager” by the input “Country”, so that every case that is not covered by the first rule is caught by the lower priority rule as a fallback.

Setting-up-Rules

 

Maintaining Rules Values

Business departments can then start to populate the rules with semantic derivations. They have the full masterdata value help for every InfoObject that they have come to expect from NextTables, with the possibility of disallowing them to add non-existing values to the list.

If we continue with our previously used example, business can now define that the “Product” of “NextCola” in combination with the “Country” of “Germany”, should have the “Sales Manager” output of “Sebastian Uhlig”.

Maintaining-Rule-Values

Processing the Rule Values

When the business departments are regularly maintaining the rule values, processing those in BW transformations or other ETL processes is the next step.
To do that, the NextRules central storage aDSO can be accessed, where every single rule is saved. The aDSO has been transposed in our BAdIs automatically, so it is easy to read in any further code accessing the table.
So for every rule with its respective sub rules, you get a row in the storage table in the usual OPTION, SIGN, LOW, HIGH format. Out-of-the-box, only OPTION = ‘EQ’ and SIGN = ‘I’ are supported, but of course NextRules can be extended to support intervals as well.

Processing-the-Rule-Values

 

Summary

With our NextRules Addon for NextTables, you already have a strong foundation for a Data Rule Maintenance system, erasing the need for a third-party-tool that is hard to integrate into SAP BW. We deliver a lot of features out-of-the-box, that require very little setup both on the IT end as well as the business side.
By utilizing standard aDSOs and BAdIs for the implementation of NextRules, you can easily extend the tool according to your requirements.

Interested? Do you want to try it out yourself? Get your free trial and let us know you want to test NextRules. Feel free to contact us and we will answer any questions and give you a live demo of NextRules.

Learn all about smart data maintenance with NextTables

 

,

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

How to maintain transformation rules for SAP BW in NextTables
5:13

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