- 1) What is Rainbow?
- 2) Business benefits
- 3) Functionality
- 4) Governance
- 5) Data
- 6) Implementation
- 7) Pricing
Rainbow offers a large set of column types:
- Text – Automatic retrieval of value text (description) for referenced columns (Vendor name, Unit of measure description, Employee name, etc.)
- Formula – Easy-to-use interface for entering logical statement and mathematical formulas in Excel-like format
- DB Lookup – Easy selection from DB table/view
- Comment – Built-in functionality for cell/row commenting by end-users
- Input – Out of the box editable typed-column for user input (including search help and data validation) – Change documents history is available
- Input Info – Metadata for Input column: Date/time/user of last update
- Long Text – Easy to use mechanism for displaying long text maintained for standard objects
- Table Lookup – Vlookup to a column in another report (implemented using Snapshot)
- Aggregation – Aggregated values of a column (Sum, Count, Max, etc,) grouped by set of other columns
RainbowSAP Suite is a platform that allows business analysts, consultants and business end-users to create, enhance and publish ALV Assets, Without Development, within SAP.
RainbowSAP allows one to (i) create and improve Operational Reports (Spreadsheet capabilities within SAP, ‘Joining’, and much more), (ii) introduce interfaces such as CSV, XML, FTP (both outgoing and incoming from & to SAP), (iii) deploy RPA within SAP for long-tail processes which typically are not worthwhile to develop, and (iv) help business end-users to consume SAP data and reports much easier via emails, UI5 (Fiori), SMS, mobile & ‘beautified’ SAP-Gui in both scheduled pull and push modes – all without development.
RainbowSAP is installed as a Change Request on top of the SAP installation, untouching the transformational data while inheriting SAP’s authorization protocol since RainbowSAP is completely embedded within SAP.
Rainbow is an SAP-certified product, natively coded in SAP using ABAP.
RainbowSAP Suite consists of 4 main modules:
(i) Rainbow: ALV-Based Operational Report Creator & Enhancer. Rainbow also enables the immediate conversion of any ALV asset into SAP UI5 (Fiori), without development.
(ii) Publisher: Quick dispatching tool of operational reports that enables data split according to the recipient’s context, in various formats and media (in both pull & push modes). Publisher enables also the creation of quick interfaces with other systems, turning excel tables into ALV and freezing transactional data through snapshots.
(iii) Changer: a simplified SAP-Log Tracker, monitors log activity changes & inconsistencies
(iv) IDoc Monitor: a simplified IDoc search and monitor tool that dramatically facilitates troubleshooting of SAP-related issues.
Rainbow is widely used in different SAP products (ERP, S/4HANA, CRM, SRM, etc.), in all available SAP modules (MM, SD, FI, CO, HR, PM, etc.), and in all available Industry Solutions (Automotive, Oil & Gas, Banking, Insurance, Pharmaceutical, HiTech, Utilities, etc.) .
Rainbow Makers are the user type that can create, enhance, publish and modify operational reports, business solutions, Interfaces and Easier Access solutions for end-users. D’Pros offers a 4 days RainbowSAP Makers course for those who wish to become certified RainbowSAP Makers. Of course, the course is not compulsory to create reports. Any user, with some SAP know-how, and with the right authorization could start creating reports with a very short enablement session and/or by reviewing the user guide and other user enablement collateral available on www.rainbowsap.com website.
Additionally, end-users can add inputs, comments, conditional formatting, formulas, input columns, and other basic simplification and visualization elements, subject to the right authorizations.
The two key functional RainbowSAP user roles are ‘RainbowSAP Maker’ and ‘Business End-User’. There are three other roles, more technical in their nature: Product Administrator, Group Administrator, and Authorization Administrator.
Maybe a strong SAP user or an SAP Business Consultant. Essentially, this person can enhance ALV assets: Operational reports, interfaces, Business Process Automation within SAP, SAP UI5, and Publisher jobs.
The RainbowSAP Maker will have the authorization to build and create new variants that would ensure that the Business End-User’s dependency on IT to making changes and inputs are at minimum (if at all). These may include:
– Joining, Advanced formulas…
– Interfaces (outgoing, incoming)
– Complex personalization
– Define Publishing jobs
– Create Web / Mobile Access
– Automate processes within SAP
The Business End User is not supposed to create any new variants, but will be using the output and creations of the RainbowSAP Makers to an extent that would reduce his /her dependency on the IT team and/or SAP experts to minimum, if at all. Subject to the Authorization granted, the End User is may benefit through the following activities as self-service (but not limited to), ‘On Production’:
- ‘Excel Spreadsheet’ type of modifications, which may include (but not limited to): Painting cells, Conditional Formatting, Entering of Comments, Graphs, Quick Sending by Outlook, Access to Selection Screen to modify dates or other parameters…
- Pull Operational Reports on demand (‘SMART’ functionality)
- Direct access to enhanced operational reports via SAP GUI, SAP UI5, Mobile or pre-scheduled automated email
- Use Functional Buttons (if applicable and if authorization granted)
Further information about all 5 RainbowSAP roles may be found at the following LINK.
RainbowSAP is about improving your organization’s productivity, allowing your internal customers (the users) to be more self-sufficient and having them reaching out to IT and the SAP team only on very important matters. RainbowSAP represents a marginal investment which will unlock in low time and within minimal effort substantially higher values and benefits from the multi-million investments made already in SAP.
There are quite a few. The two principal pain points are related to the need to answer business questions in the most fastest and credible way. Today, SAP teams have two ways to address such emerging business questions: (i) Trigger a development process that would last many days, if not weeks – eventually ending with a semi-tailored Z-report which is not supported by SAP (and later one would be needed to be redeveloped when migrating to a new SAP version), (ii) Export data to a spreadsheet, thus risk with data inaccuracies, lack of control where the confidential information ends up and the creation of organizational silos since users add inputs and comments on spreadsheets, rather than within SAP. Consequently, also the BI solutions lose their reliability.
RainbowSAP fully answers these two pain points and eliminates all these risks allowing the SAP teams and end users to personalize reports and interfaces without development, within SAP, within hours.
Please contact firstname.lastname@example.org and we will offer you two options: (i) Demonstration using D’Pros demo environment, (ii) installation at your environment with complimentary licenses for 2 weeks, permitting you to see the immediate value of RainbowSAP with you data.
RainbowSAP is not an external 3rd party system, or rather a complicated system that requires intensive ramp up or change management. Users continue using their own working environments, simply with enriched capabilities. Actually, within a less than a week, business users would have their business problems resolved on Production, thus free up your time to focus on Go-Live…
The definition of “Variant” could be found HERE
During the first year of usage, we understand that one may experiment, test and play with RainbowSAP. Hence, we provide a minimum package of 25 variants included within the monthly fee. By the end of each renewal period, we determine together what would be the anticipated variant usage, and according to that estimate – we determine the annual payment for the next renewal period.
You may invite as many as users to enjoy RainbowSAP, and you could process or publish each variant as many times as needed and to as many as people as needed with no extra costs.
We do not conduct audits of historic usage. At the end of the given renewal period, we believe that you would like to include the newly created variants in the variant usage estimation for the next renewal period.
No, you will not. All you have to do is delete these variants from your RainbowSAP / Publisher monitor/s when we discuss the number of Variants you wish to order for the next renewal year.
Given the low monthly cost of the system, we charge annually when signing up and when it is time to renew.
No. As part of the base price, we provide you with 2-3 hours of Webex-based training. All maintenance & support services (activated remotely via a ticketing system) are included in the fee, as well as any support needed for the Change Request installation.
First, please remember that RainbowSAP is not a 3rd party tool, but is embedded within your standard SAP environment. Hence, the basic training is easy, rapid and quite self-explicit.
When subscribing to the service, we offer you with a 2-3 hours of Webex-based training. Then, you will gain access to our user-guide, knowledge base and educational material accessible online. You may always send a support ticket that will be rapidly responded (in line with the SLA we commit to).
You have an exit point from RainbowSAP at the end of each renewal period, once informing us in writing by email with a 15-day notice.
RainbowSAP is using SAP look & feel, thus SAP users will find it familiar.
Just like working with Excel, the basics is rather easy.
Nonetheless, to achieve more, makers can check the Knowledge base area in our website.
Less than a minute.
Adding a new column, conditional formatting, graph or grouping will take roughly one minute each.
All the above could be done directly in production and w/o a line of code.
Rainbow users are assigned to one of the following Roles:
- Product Admin – Controls the product configuration
- Group Admin – Controls the Group configuration
- Rainbow Maker – Able to create a Rainbow report
- Rainbow end-users (no special role) – May use a Rainbow report in assigned the authorization to do so.
Watch this tutorial video link to learn how to create a new variant.
Watch this tutorial video link to learn how to create a new Publisher Job.
Watch this tutorial video link to learn how to add a new Input Field.
You can add new columns to existing reports using Rainbow.
One of the Column Types is Formula which enables one to write expressions in a similar way to spreadsheets.
A list of predefined Formula Functions (such as Date, Text, Math, etc.) is out-of-the-box offered – and new custom Formula Functions could be added by power users.
The ROI is a factor of two main components: (i) Savings of human resources & time as a result of annulation of any development needed (developers, Basis, Testers, less time spent of business analyst & business owners), (ii) Impact as a result of amazingly short Time-to-Market & Time-to-Value of a solution that addresses a business need and answers business questions in no-time, (iii) business impact thanks to the insights and value one may unlock from the ability to view and leverage operational reports, interfaces and RPA inside SAP, in ways unimaginable before without coding or development.
In addition to a fixed low monthly base cost, the variable payment component is based on the number of Variants which are being used w/o any limit on the number of users or executions.
NW 7.00 and above.
ERP: Any ECC6 / S/4HANA.
For SAPUI5 app: FES (Fiori Frontend Server) with minimal NW 7.4 SP09 is required (could be a separate machine)
Navigation to standard Business Objects (such as material, customer, vendor, purchase order, etc.) is embedded.
Navigation could be defined either at the system level or Rainbow variant level.
The installation in SAP will take a few minutes and does not require any other local/external installations.
Please contact us for further details.
Using Rainbow, every custom report could be displayed in SAPUI5 (Fiori-like) in 5 minutes and w/o any line of code.
Publisher uses a special distribution method named Snapshot, which stores ALV results in the DB – The snapshot could be scheduled periodically as a background job.
This Snapshot could be later consumed and displayed to end-users as a Rainbow report instead of the original report – Returning results in sub-second.
Maker may add her own logic by using the build-in column-types (formula, DB lookup, and input to list a few) – all without a line of code.
Nonetheless, a guide enhancement framework is available by which locally-developed functionality could be added.
Rainbow offers two types of coloring:
- Manual coloring – End users can select a cell/row (or group of cells) and color them at will
- Conditional formatting – Using painting rules, cells adhere these business rules will be painted accordingly
Yes, in minutes, directly in production, and without a line of code.
Rainbow allows to easily add new columns of various kinds.
Our customers are our friends. Most of the things RainbowSAP offers originated from real customers’ pain.
Do check the Testimonial section at our website
It depends on how good would you would like to be.
To gain most of the benefits, basic knowledge in SAP together with spreadsheet operation skills will do.
Nonetheless, Rainbow offers developers tools to extend Rainbow even more.
To create a basic Rainbow, one needs a few minutes and common sense.
With some more time-investment, one may produce complicated Rainbows shortly.
Yet, Rainbow allows its users to enhance the framework itself in the sense of adding new functionality (new Formula function and new Toolbar function to list a few). This way, locally developed business rules could be incorporated into Rainbow. To do this ABAP skill-set is needed.
Rainbow distinctly differentiates between Makes and end-users. While the first build new Rainbows, the latter use them.
Makers are often IT personnel with extra business understanding or Business users with some technological background.
However, while Makers take an active role in preparing Rainbows, end-users will not know the difference between a Rainbow report and any other Report created by SAP or locally coded in ABAP.
Rainbow uses Groups to split the reports into separate areas (by department, modules, responsibility, etc.).
This way, users allowed to see only reports from Groups they are allowed to view.
One may add additional authorization checks both at record and column level.
Rainbow is an SAP add-on and thus whoever has the authorization to view both the original report and the Rainbow report could view it.
Less than 5 minutes.
Just create a Rainbow report of your existing ALV report.
Any Rainbow report could be, out-of-the-box, published as SAPUI5 (Fiori-Like) app.
Without any additional effort.
Any Rainbow report could be, out-of-the-box, published as SAPUI5 (Fiori-Like) app.
Grouping, conditional formatting, additional columns, and graphs to list a few.
Grouping, conditional formatting, additional columns, and graphs to list a few.
Yes, all ALV- based reports are supported:
- The ‘ReUse’ function (REUSE_ALV_GRID_DISPLAY)
- Class CL_GUI_ALV_GRID
- Class CL_SALV_TABLE
The only prerequisite is that the report could be executed in the background.
Most of the things are handled within Rainbow w/o writing a line of code.
Spreadsheet skills will perfectly do.
You do not have to.
Rainbow, by design, works directly on Production and adheres SAP authorization frameworks.
Nonetheless, if from any reason one would like to work on any other than production system landscape, the Export/Import functionality could be used.
Rainbow supports aggregation mode, which bears a similar notation.
Using aggregation mode, the original report’s data records are clustered together according to a set of attributes of said data records. This way, all data records corresponding to the same data attributes are merged into one record. Each field of the merged data record could point at an aggregation (sum, average, max, etc,) of all other merged fields.
Just like in pivot table, marking merged record(s) and pressing the ‘expand aggregated data’, will unfold the original records that formed the selected records.
Rainbow does not differentiate between SAP-standard report, custom (Z) report, or SAP Queries (SAP-standard and locally developed alike).
Actually, Rainbow enhances any ALV (ABAP List Viewer) based tabular data regardless its origin. Hence, as soon as an object could be presented as ALV report, it could be enhanced by Rainbow. For example, a simple program that displays DB tables as an ALV report will make all SAP DB table transparent to Rainbow. By the same token, a program that uploads an Excel file and presents it as an ALV report could be enhanced by Rainbow as well.
Rainbow does not differentiate between SAP standard SAP reports, custom (Z) reports, or SAP Queries (SAP-standard and locally developed alike).
Actually, Rainbow enhances any ALV (ABAP List Viewer) based tabular data regardless of its origin. Hence, as soon as an object could be presented as an ALV report, it could be enhanced by Rainbow.
One can add to any ALV (ABAP List Viewer) based report any of the available Column Types.
Rainbow is an integral part of SAP environment (add-on) and thus needs nothing to be locally installed.
RainbowSAP supports any SAP product based on NW 7.00 and above.
For ERP, this means ECC 6 onward, including S/4HANA.
RainbowSAP and BI are not synonyms.
BI tools (such as QlikView, SAP Analytics Cloud, Power BI to name a few) are widely used in Organizations.
However, while BI has its advantages yet and by all means, writing complex reports is not one of them.
Rainbow, being able to enhance SAP-standard reports and share the result with other software, is perfectly equipped to feed BI tools with application-level information.
One needs Rainbow to streamline application-level information between SAP and your BI software. This way, your BI projects will get more accurate and will take fewer resources (time & money).
Having said that, one must note that the ability to enhance and enrich functional reports within ERP and S/4HANA, is a quality by itself. Business end-users need the system to answer business questions and needs. Rainbow allows just that in hours, directly in the live-system and without a line of code.
Developers may use Rainbow, yet Rainbow was not created for developers.
On the contrary, Rainbow contains all the knowledge we gained from years and years of ABAP development.
Rainbow does amazing things without coding, in hours, and directly in production. That is why people without development skills may benefit Rainbow immensely.
No, rainbow is not a business intelligence (BI) system.
Business intelligence (BI) is used for the data analysis of business information. BI technologies provide historical, current, and predictive views of business operations. To do so, BI includes the functions of: reporting, online analytical processing, and predictive analytics.
RainbowSAP, on the other hand, is installed on SAP ERP or S/4HANA as an add-on and makes them better. SAP ERP or S/4HANA are business management software that captures, stores, and processes data from transactions in real time.
ERP and BI are complementary terms. BI uses complex queries to analyze aggregated historical data from ERP systems.
RainbowSAP is installed on SAP NW / ABAP Platform ERP or S/4HANA as an add-on and makes them better.
Apart from the parts related to Fiori, Rainbow as a whole is coded in ABAP, the computer language SAP has invented. Rainbow is installed using Change Requests (CRs).
Unlike external products like Excel and other software installed outside SAP, Rainbow knows SAP very intently. This is why Rainbow, for example, really ‘knows’ that in one place the number 34543 represents a Vendor while in other that very same number, 34543, points at an Employee.
Rainbow does not replicate SAP data to help its users. On the contrary, Rainbow reuses existing artifacts made by SAP and the customer and elevates the result.
One may create a Rainbow report in less than two minutes.
Yet, since everything is done in Production, in minutes and without a line of code, Rainbow Makers keep improving their Rainbow reports.
New requests from end-users, a newly introduced Rainbow version, or even a good idea will all lead to progress. Yielding, an ever-evolving Rainbow reports – just like life itself.
The product (introduced in early 2011) is stable and very easy to install (10 minutes per SAP system).
On top of the above, Rainbow utilizes the easy ignition concept by which the tool is ready for work upon installation.
With time, when requests for Rainbow reports keep pouring in, the power of Rainbow customization could be unleashed.
The technical installation is finished in less than an hour!
It is possible because the Rainbow was designed, bottom-up, just for that.
No customization, what so ever, is needed for startup.
Yet, with time, when requests for Rainbow reports keep pouring in, the power of Rainbow customization could be unleashed.
After a short training, most of the basic enhancements could allow an individual to make various simplification and enhancement changes in less than 30 minutes…
Rainbow is installed using Change Requests.
Licenses, according to agreed-upon scope, are then emailed to the customer and installed thereafter.
The customer can now work with Rainbow.
Moving forward to QA and to Prod afterward, require nothing but CRs import and licenses installation.
This is a tricky question.
As explained, Rainbow by nature does not change the objects it reads.
The ALV (ABAP List Viewer) data and metadata are read from the invoked original report/query/DB (Rainbow baseline).
Rainbow does not affect the baseline no what so ever.
Input fields and comments, help users to save their own information besides SAP, which is the closest Rainbow gets.
However, using Toolbar Functions (AKA, buttons), one may add functionality (e.g., updating PO delivery date, Sales Order order amounts, etc.).
Needless to say, the code behind this locally developed Toolbar Function, is first coded and tested in Dev system before transported (using CR) to Production.
Rainbow was built with Authorization in mind.
Thus, it goes without saying that Rainbow forces the authorization checks of the baseline: the original transaction (report/query/db-table) the Rainbow variant is based on.
i.e. Rainbow end-user won’t be able to display anything he couldn’t display in the original transaction.
However, Rainbow allows makers to add a whole new layer of Authorization checks per the baseline fields and the new data-columns added.
Row-based Authorization object checks – just like SAP, Rainbow allows Makers to screen out records to which the end-user has no authorizations.
Column-based Authorization checks – For the first time, end-users may or may not see a data-column based on their authorization level.
Rainbow uses SAP authorization concept.
Furthermore, one may add additional authorization checks both at record and column level.
Rainbow supports the following as Data Sources:
- SAP standard ALV reports
- Locally developed ALV reports
- ABAP queries (SQ01 and SQVI)
- DB table (SE16N)
- Remote DB tables (using the DBCO standard functionality)
- … and more
By selecting the requested data range (records/columns) one may easily send them as emails via either Outlook or SAP Mail.
In day to day, Rainbow needs zero attention from the organization’s IT team – It’s just like asking how much effort is needed to support Excel.
Twice a year, a new RainbowSAP release is shipped to customers.
An effort is then needed to:
- Move the new version to the live system.
- Find out the new functionality offered by the version and how it could be used to enhance old and new Rainbows in the organization.
Some advanced business requirements, like new Formula function or new Toolbar function, require limited ABAP code.
In that case, an effort is then needed to:
- It is done only once and shared across Rainbow.
- Only the missing functionality is coded, Rainbow’s infrastructure takes care of all the rest.
Please check the Logistics Blogs section in our website for some real live examples shared by our customers.
Nonetheless, the possibilities are endless – Starting from Order Threshold limitation Alert, moving to Open PO for Vendor Confirmation, and ending with PO Collaboration Approved task.
In addition, RaibnowSAP-platform allows managers to address all the long-tail processes every manager yearns to automate within the SAP environment but could not afford it (both, time and money wise).
Rainbow is as real-time as any other SAP functionality. Every time a Rainbow is invoked, the original transaction is being internally executed in real-time.
This type of question is coming from the direction of Excel-based software (and other applications) that lives outside SAP. Trying to convince users that the data in their app is the very same data appear within SAP, they often use the term real-time (or near real-time). As said, in relation to Rainbow this term as no meaning since Raibnow IS SAP.
Any Rainbow report manifest itself as a mobile application.
Our mobile app was developed in standard SAPUI5 framework and it’s compatible with any device that is supported by SAP-standard platform (aka Fiori).
Our product relies on standard SAP users and standard authorization mechanism.
All standard authorization checks, which are checked in standard (for original reports), are enforced by our product and cannot be bypassed.
In addition, every aspect/object in our product has a corresponding authorization object, which allows the customer to manage the authorizations in complete flexibility (Different authorizations for different roles/users).
Not any significant limitations we are aware of.
There are few SAP-standard reports (less than ten out of thousands of reports) which couldn’t be executed due special SAP implementation (They weren’t implemented according to SAP standards). For some of them, we were able to supply a solution on demand in newer releases.
New improvements for missing features (requested by customers) are added on regular basis in new releases.
Check our Pricing Model for further information regarding our software licensing.
The product contains tens of new DB tables (under /DCM/, /DPS/ namespaces).
All of them should have reasonable data growth according to the actual usage (Number of variants) w/o any effect on the system.
The only DB tables which may require closer monitoring are DB tables which store input contents (Input columns, comments, manual colors, etc.), whose data growth is less predicted manner since it depends on actual contents by users. We may deliver a complete list of these DB tables on request.
We have an official new release twice a year which is delivered to all our existing customers. Every release consists of both improvements and bug-fixes.
Standalone hot-fixes are released, if required, only in case of critical errors.
Detailed info about the authorizations can be also be found in the knowledge base section on our website.
There aren’t any special system requirements for the installation.
No additional memory is needed. The product uses common system resources, like any other standard report.
There aren’t any known technical issues. Installation is done via standard import of Change Requests.