Optimize
Transform
Visualize
Interdobs
Interdobs de toonaangevende SAP dienstverlener op het gebied van Business Intelligence. Wij bieden advies, beheer en projectondersteuning op de SAP on-premise en de Cloud producten voor data modellering, data analyse, rapportages, dashboards, predictive analytics en HANA.
Optimize
Interdobs is als geen ander op de hoogte van de laatste stand van de mogelijkheden van de SAP Analytics software en Analytics roadmaps. In onze demo omgevingen experimenteren wij met de nieuwste versies en daardoor kunnen wij uit eerste hand vertellen waar integratie en content aanwezig is en waar nog verder doorontwikkeling benodigd is. Na het samen definiëren van de gewenste stip op de horizon stellen we een pragmatische roadmap op, waardoor de route voorwaarts en eventuele keuzemogelijkheden tussen optimaliseren of vervangen zich zullen openbaren. Interdobs staat voor u klaar!
Transform
Interdobs heeft zich als doel gesteld om u te helpen bij het maken van de juiste beslissing voor uw hele organisatie. Van BI Architectuur tot Analytics, van ruwe data uit uw systemen naar getransformeerde, geharmoniseerde en gevalideerde informatie in het Data Warehouse. SAP Data Warehousing is overigens allang niet meer het klassieke SAP BW van vroeger. Met alle nieuwe mogelijkheden om een agile data warehouse op te zetten, met ruimte voor continue (DevOps) ontwikkelingen, en een keuze voor techniek (BW/4HANA of het HANA SQL Data Warehouse), zijn de mogelijkheden voor uw transformatie eindeloos. Wij bepalen graag samen met u de juiste route!
Visualize
Interdobs realiseert op een methodische wijze de data visualisaties die het juiste verhaal vertellen om de vervolgacties in gang te kunnen zetten. We kijken naar ‘de vraag die achter de vraag’ en maken bij de realisatie gebruik van markt standaarden als HICHERT®SUCCESS en Stephen Few.
OPTIMIZE
TRANSFORM
VISUALIZE

Starting Tuesday the 11th of November the TechEd && d-code kicked off with a flashy and demo rich keynote speech. During this session a movie was shown with the title “SAP Run Simple”. Check it out below. The message “Things should be more easy” finally has sunk in at SAP. This was also noticeable in the sessions I have attended regarding the BI reporting tools.

In this blog I would like to provide an overview of the changes that are heading our way with regard to these tools.

Simpler Landscape

The picture below was shown multiple times before and during the TechEd. It shows the future direction of the BI clients. On the left the full suite is given that is currently available. Next to that the surviving tool is given. This will be the tool which SAP will still invest in and where enhancements will be made available for. This is in my opinion where you should focus on as a business. If you are at cross roads and in need to select a new BI frontend tool, pick one from the “simplification BI tools”.

Planned Simplification of BI Client Portfolio

Besides ‘reporting’ there is for each level one tool available in the future. Especially Lumira will, in the end, replace quite a set of tools. This includes the replacement of Analysis OLAP, which is quite a new tool. But, SAP stated that Analysis OLAP is already at its final stage of development and will not be invested in anymore.

Just a couple weeks before the TechEd in Berlin SAP announced that it will extent the maintenance for SAP Netweaver BW and the front-end tools attached. This means that for customers the investment they have made in BEx Query Designer and other BEx tools is safe for another 11 years. This should give customers enough time to have a look at the BI Client Portfolio and migrate to one of the tools coming out of the simplification step.

Web Intelligence – Reporting

After attending a product roadmap session by SAP’s Romaric Sokhan, I can indicate that SAP is willing to invest in Web Intelligence (Webi). As also shown in the client portfolio Webi still has a place there. But, there were no major sessions on Webi, just to give you some idea about the positioning. Nevertheless there are two items I have seen in a roadmap Q&A session are worth mentioning.

First is the addition of a Universe view that is now provided directly within the design view of Webi. This means that you could do more with OLAP functionality in Webi. How this will work in practice was not made clear. Also in the case of a BEx query as a source for a report, it is not clear yet if and how this would work.

Another new addition will be a developers mobile view. On the top right next to the reading, design and data views a new view will be added, which shows the developer how the report will look on a mobile device. This will bring down the development time since refreshing the report on your iPad after each change is not needed anymore.

Also some smaller changes will be added in the next couple releases, like a new search box for values in the prompt screen that allows you to search for both key and text for SAP BW sources. Also performance improvements are realized and will come available soon.

Design Studio – Dashboards and Applications

Design studio will obviously take a prominent place in the BI reporting suite. It can be used for dashboarding, but with the 1.4 release it also can be used more easily for OLAP functionality. During the TechEd SAP’s Jie Deng gave a demo on this new release. She revealed a new template that allows a user to use OLAP functionality within a Design Studio template. All the end-user has to do is attach a datasource to the template. A limitation is there that you can only do a search for a query. There is no option yet available to browse through the SAP BW InfoAreas or menu roles. The template has all the features built in that you would expect, like a context menu, drag and drop of the dimensions and measures, filtering, export to Excel, etc.

SAP Design Studio Ad-hoc Analysis

If we look a bit further than the next release, SAP has also revealed some more details about what is to come. There will be a tighter integration with Lumira. The tools will not converge into one, but there will be more and more interchangeable objects between the two. Just recently SAP has released the new Design Studio SDK. With this SDK extensions can be built for Lumira, which also can be used in Design Studio. This will continue so that in the future parts of a Design Studio template can be exported to Lumira and vice versa.

Also pre-calculation and broadcasting are options that will be added in the future, together with an export to PDF, PowerPoint and Word feature.

SAP Design Studio RoadmapThere are many, many more new features like the integration of Report-to-Report functionality, datasource SDK, bookmark snippets, etc. My colleague Jeroen van der A already published a blog on SCN where he goes into more detail about his experience on the TechEd and the upcoming changes for Design Studio. Please check this for more information.

Lumira – Discovery and Analysis

What I took away from the sessions on Lumira that I have attended is that the support for SAP BW will improve: There will be support for non-HANA datasources such as a BEx query. Next to that there are a lot of developments done in the area of data transformation for date and time formatting and more formulas and functions will become available.

Also in the area of visualization changes are happening. The visualizations are based on the visualization library of D3. There will be more integration with ESRI maps and more interactivity with the user. There is so much to mention. The blog of Tammy Powlas on SCN shows some slides about the future direction of Lumira and more details of what is to come.

Analysis Office – Office Integration

For Analysis for Office the 2.0 release is planned for General Availability (GA) this year still. This release contains two new features that I would like to mention, which were also highlighted by Jie Deng in a demo at the TechEd.

First is the new properties pane on the right side of your screen. This now also includes a properties pane like in the BEx Query Designer. If you want to change any properties of a dimension or measure you now can use the pane on the right instead of buttons in the ribbon. To me this would make life easier for end-users.

Second you can now add empty rows or cells in your result set. This means that you can customize your report layout. You can add content to this ‘empty’ row, for example a summation. Then you can give this a predefined style and the layout is done.

Also with this release it is possible to connect to native HANA data next to the already existing connection options like BEx query and Analysis view.

The new 2.0 release is not a big change compared to version 1.4 with the latest support pack, but it contains good improvements and adittions to in my opinion an already mature product.

Analysis for Office

In next releases these features will be further enhanced to also include Excel functionality. What also will be added in a future release is a tighter integration with Lumira. Next to Design Studio, Analysis for Office will integrate in a way that you can move data across.  Also the EPM Excel add-in will be merged together with Analysis Office, to simplify the portfolio.

SAP Analysis for Office Roadmap[:nl]Starting Tuesday the 11th of November the TechEd && d-code kicked off with a flashy and demo rich keynote speech. During this session a movie was shown with the title “SAP Run Simple”. Check it out below. The message “Things should be more easy” finally has sunk in at SAP. This was also noticeable in the sessions I have attended regarding the BI reporting tools. 

In this blog I would like to provide an overview of the changes that are heading our way with regard to these tools.

Simpler Landscape

The picture below was shown multiple times before and during the TechEd. It shows the future direction of the BI clients. On the left the full suite is given that is currently available. Next to that the surviving tool is given. This will be the tool which SAP will still invest in and where enhancements will be made available for. This is in my opinion where you should focus on as a business. If you are at cross roads and in need to select a new BI frontend tool, pick one from the “simplification BI tools”.

Planned Simplification of BI Client Portfolio

Besides ‘reporting’ there is for each level one tool available in the future. Especially Lumira will, in the end, replace quite a set of tools. This includes the replacement of Analysis OLAP, which is quite a new tool. But, SAP stated that Analysis OLAP is already at its final stage of development and will not be invested in anymore.

Just a couple weeks before the TechEd in Berlin SAP announced that it will extent the maintenance for SAP Netweaver BW and the front-end tools attached. This means that for customers the investment they have made in BEx Query Designer and other BEx tools is safe for another 11 years. This should give customers enough time to have a look at the BI Client Portfolio and migrate to one of the tools coming out of the simplification step.

Web Intelligence – Reporting

After attending a product roadmap session by SAP’s Romaric Sokhan, I can indicate that SAP is willing to invest in Web Intelligence (Webi). As also shown in the client portfolio Webi still has a place there. But, there were no major sessions on Webi, just to give you some idea about the positioning. Nevertheless there are two items I have seen in a roadmap Q&A session are worth mentioning.

First is the addition of a Universe view that is now provided directly within the design view of Webi. This means that you could do more with OLAP functionality in Webi. How this will work in practice was not made clear. Also in the case of a BEx query as a source for a report, it is not clear yet if and how this would work.

Another new addition will be a developers mobile view. On the top right next to the reading, design and data views a new view will be added, which shows the developer how the report will look on a mobile device. This will bring down the development time since refreshing the report on your iPad after each change is not needed anymore.

Also some smaller changes will be added in the next couple releases, like a new search box for values in the prompt screen that allows you to search for both key and text for SAP BW sources. Also performance improvements are realized and will come available soon.

Design Studio – Dashboards and Applications

Design studio will obviously take a prominent place in the BI reporting suite. It can be used for dashboarding, but with the 1.4 release it also can be used more easily for OLAP functionality. During the TechEd SAP’s Jie Deng gave a demo on this new release. She revealed a new template that allows a user to use OLAP functionality within a Design Studio template. All the end-user has to do is attach a datasource to the template. A limitation is there that you can only do a search for a query. There is no option yet available to browse through the SAP BW InfoAreas or menu roles. The template has all the features built in that you would expect, like a context menu, drag and drop of the dimensions and measures, filtering, export to Excel, etc.

SAP Design Studio Ad-hoc Analysis

If we look a bit further than the next release, SAP has also revealed some more details about what is to come. There will be a tighter integration with Lumira. The tools will not converge into one, but there will be more and more interchangeable objects between the two. Just recently SAP has released the new Design Studio SDK. With this SDK extensions can be built for Lumira, which also can be used in Design Studio. This will continue so that in the future parts of a Design Studio template can be exported to Lumira and vice versa.

Also pre-calculation and broadcasting are options that will be added in the future, together with an export to PDF, PowerPoint and Word feature.

SAP Design Studio RoadmapThere are many, many more new features like the integration of Report-to-Report functionality, datasource SDK, bookmark snippets, etc. My colleague Jeroen van der A already published a blog on SCN where he goes into more detail about his experience on the TechEd and the upcoming changes for Design Studio. Please check this for more information.

Lumira – Discovery and Analysis

What I took away from the sessions on Lumira that I have attended is that the support for SAP BW will improve: There will be support for non-HANA datasources such as a BEx query. Next to that there are a lot of developments done in the area of data transformation for date and time formatting and more formulas and functions will become available.

Also in the area of visualization changes are happening. The visualizations are based on the visualization library of D3. There will be more integration with ESRI maps and more interactivity with the user. There is so much to mention. The blog of Tammy Powlas on SCN shows some slides about the future direction of Lumira and more details of what is to come.

Analysis Office – Office Integration

For Analysis for Office the 2.0 release is planned for General Availability (GA) this year still. This release contains two new features that I would like to mention, which were also highlighted by Jie Deng in a demo at the TechEd.

First is the new properties pane on the right side of your screen. This now also includes a properties pane like in the BEx Query Designer. If you want to change any properties of a dimension or measure you now can use the pane on the right instead of buttons in the ribbon. To me this would make life easier for end-users.

Second you can now add empty rows or cells in your result set. This means that you can customize your report layout. You can add content to this ‘empty’ row, for example a summation. Then you can give this a predefined style and the layout is done.

Also with this release it is possible to connect to native HANA data next to the already existing connection options like BEx query and Analysis view.

The new 2.0 release is not a big change compared to version 1.4 with the latest support pack, but it contains good improvements and adittions to in my opinion an already mature product.

Analysis for Office

In next releases these features will be further enhanced to also include Excel functionality. What also will be added in a future release is a tighter integration with Lumira. Next to Design Studio, Analysis for Office will integrate in a way that you can move data across.  Also the EPM Excel add-in will be merged together with Analysis Office, to simplify the portfolio.

SAP Analysis for Office Roadmap