Skip to Content

Table of Content


Introduction

Improve decision-making capabilities by bringing unprecedented performance to SAP Business Warehouse with SAP HANA for current data and SAP IQ for historical data – achieving the perfect balance of cost and performance. The adapter for SAP IQ as a near-line solution is delivered with the BW system. The Integration of SAP IQ makes it possible for you to separate data that you access frequently from data that you access rarely, thus making less demand on the resources in the BW system. The near-line data is stored in compressed form. You can thus reduce the costs incurred by data that is accessed less frequently.

With the current Release of SAP BW 7.40 Feature Pack 02 (based on 7.40 SP08) some interesting improvements and updates were released for the SAP-NLS Solution based on SAP IQ SP10. Also including the latest SAP-NLS Features for SAP BW 7.50 and 7.50 SR1 (based on 7.50 SP04)

Please Note that the SAP-NLS Solution can be used with all supported database version supported by SAP BW 7.3x and onwards. Together with NLS Partnersolutions, Nearline storage for SAP BW can also be enabled from SAP BW 7.0x releases onwards.


Overview and Roadmap

Find the SAP IQ as a Near-Line Storage Solution on the SAP online documentation:


Installation and Implementation

Find the detailed installation of the SAP IQ as a Near-Line Storage Solution in the
End-to-End Document – SAP-NLS with SAP IQ which refers to
SAP First Guidance – SAP-NLS Solution with SAP IQ

Notes for Installation and Implementation

A How to Paper, How to start with DAP in SAP BW:
How to Archive Data from SAP BW to SAP IQ as Near Line Storage
Additional Information can also be found in the Blog Section

SAP Help: Creating Data Archiving Processes


Since SAP BW on HANA 7.50 SP04 Hadoop as NLS Storage is possible as well.
Note 2363218 – Hadoop NLS: Information, Recommendations and Limitations
SAP Help: Hadoop as a Near-Line Storage Solution

 


Optimizing the SAP-NLS Performance

BLOG: Increasing the SAP-NLS Performance
BLOG: SAP BW on SAP HANA & SAP HANA Smart Data Access
BLOG: Monitoring Nearline Storage Tables and Partitions from BW


NLS Partner Solutions

Please note that the Partner Interface for Nearline Storage is only supported in SAP BW and is not available in BW/4HANA (SAP NLS IQ and SAP NLS Hadoop are supported). See also the SAP-NLS Roadmap referenced above for more information.

Currently no NLS Partner Solution is available for BW/4HANA under no further notice.

IBM

PBS Software

DataVard


Blogs (refer to other publications on the NLS community)


Roland Kramer, PM EDW (BW/HANA/IQ), SAP SE
@RolandKramer

To report this post you need to login first.

37 Comments

You must be Logged on to comment or reply to a post.

  1. Jan Tretina

    Hi,

    SAP HANA on disk when it comes to warm data is still supported? I thought that only extension nodes are now the option for warm data, i.e. DT.

    Thanks for clarification,
    Jan
     

    (0) 
  2. Roland Kramer Post author

    Both options are available. DT is also possible for native HANA scenarios and single node and EN is the preferred option for BW on HANA .
    Best Regards Roland

    (0) 
  3. Jean Pierre Alejandro Roa Ramirez

    Hello Ronald, great post.
    we are thinking on of implementing the NLS for a SAP BW 7.4 on HANA SP14, and we have a question, is it possible to archive in the NLS the advanced DSO or is it only possible with DSO classics / cubes? This for a BW 7.4.
    Thanks!

    (0) 
  4. Chuan Wang

    Thanks Roland for the informative blog!!

    We understand BW/4HANA supports SAP IQ NLS solution. If customer already implemented IQ NLS solution in the existing BW system (non-HANA DB), then customer wants to implement BW/4HANA with green-field approach, and hope to somehow reuse the existing NLS objects in IQ. Is there an option for it? Thanks again for your time!

    (0) 
    1. Roland Kramer Post author

      Hello,

      Yes, of course you can use the existing data for reading in the BW/4HANA Greenfield Implementation, but only one System can be the producer of the data.

      In your case, the non-HANA BW System has created the historical data and not the BW/4HANA Greenfield Implementation.

      Best Regards
      Roland

      (0) 
      1. Chuan Wang

        Hi Roland,

        Thanks for the reply!! One question to follow on the reading of existing IQ data.

        We have concerns on the object type change in BW/4HANA. For example, the IQ object was created based on an infocube in the existing non-HANA BW system. With the BW/4HANA implementation, we will create ADSO to replace the infocube. How to link the existing IQ object with the newly created ADSO in BW/4HANA, from technical perspective? Hope my question is clear. Thanks again!!

        (1) 
        1. Roland Kramer Post author

          Hi
          the data would be unchanged and also the structure of the data will not have mayor changes. As already said, my doubt is the initial producer of the historical data.

          Please note we are currently looking for customer to pilot the so called “remote conversion”

          Best Regards Roland, PM EDW, SAP SE

          (0) 
  5. Neha Singla

    Hi Roland,

    As mentioned Straggler Mgmt. functionality is available with BW 7.5, is it available as 7.5 feature or need to install any Add-On? In case of Add-On’s, what are the available options.

    Regards,

     

     

    (0) 
  6. Harish Allachervu

    Hi Roland,

    I’ve one concern GL, AA, AP, AR, and Inventory data can’t be archived? because when I am discussing with my colleagues his claim is since this modules data will be stored in cumulative basis so its not preferable to do data archiving.

    can you please share your thoughts on same.

    FYI we’re on BW 7.4 on HANA landscape.

    Regards,

    Harish

     

     

    (0) 
    1. Roland Kramer Post author

      Hi,
      Inventory Cubes can be archived with Nearline storage, but I´m not familiar with GL, AA, AP, AR.
      Can you be more specific?

      Best Regards Roland

      (0) 
    1. Philipp Nell

      Hi Alejandro, You might want to start with the following note:

      2363218 – Hadoop NLS: Information, Recommendations and Limitations.
      Regards, Philipp

       

      (0) 
      1. Alejandro Gómez

        Hello Philipp,

        Thank you for your answer. I have another doubt, maybe you can help me with this one too.

        I have read that the master data can´t be archive and is considered hot data by SAP. In the other hand, in some blogs they said it can be done, but don´t mention the risks implades.

        Do you know anything about this?

        Thank you in advance,

        Regards

         

        (0) 
  7. Philipp Nell

    Dear Mr. Kramer,

    Dynamic Tiering 2.0  is offering the multi-store table (https://help.sap.com/viewer/e0950e0116e8493d8d4c42762c5d2552/2.00.0.0/en-US/4c842551951e410690804e2b30a3bb16.html).

    I can imagine that they could be quite useful in relation with data tiering as the logical table object can be distributed among HANA memory and an extended storage. Is it planned for BW to use these tables one day? IMHO it would allow to bypass some of the limitations of NLS.

    Kind regards, Philipp

    (0) 
    1. Philipp Nell

      Hello, Just found this note: 2374459 – DataStore Object (advanced): Dynamic Tiering per partitoin. I will check for the technical background which is used for the functionality which receives a correction with the mentioned note. Regards, Philipp

      (0) 
  8. Philipp Nell

    …And another question: In the new roadmap for NLS (Feb. 2017), you mention for cube like ADSOs on page 7 “in staging mode”. Could you please briefly let me know, what the “staging mode” is?

     

    Again thanks, Philipp

    (0) 
    1. Roland Kramer Post author

      Hi,
      this means you can switch between aDSO for planning (locked against load) or load modus (locked against planning). The procedure is handled by process chains.

      Best Regards Roland

      (1) 
  9. Michael Spitzer

    Hi,

     

    we have recently installed sybase IQ as Near Line storage. It will be linked with Quality System of BW. While searching for license of type CP under test system in SAP marketplace I couldn’t found any. It is showing License Type as DT. Can anyone please tell me which license type we have to use for quality server and what kind of installation needs to be done. will it be of type CP or DT.

     

    Thanks

     

    (0) 
  10. Chandrakanth Angannagari

    Hello Roland, this question is a bit not exactly linked to this blog but somehow related. The customer currently has PBS addon and has been using this solution for NLS IQ for years and now recently migrated to the SAP NLS solution. Would now like to get rid of the ABAP addon PBSCBW and the namespace /PBS/ .. how do we go about such a cleanup?

    (0) 
  11. Roland Kramer Post author

    Hi,
    Actually if you have the PBS Add-On, you have more Functionality than SAP would ever deliver.
    Furthermore PBS has tools, to migrate the data to the SAP Notation, which is independent from the Software Namespace.

    In addition the PBS Add-on is upgrade compatible

    Best Regards Roland Kramer

    (0) 
  12. ISAAC GONZALEZ FLORES

    Hello everybody,

    I have some concerns regarding to SO version:

    • Linux on Power 64-bit
    • Linux on x86_64 64-bit

    So the questions is…

    Which are the special requirements that must be achieved to run NLS (Sybase IQ)? or Where could I find them?

    Thank you

    (0) 
  13. Rajnikanth Chelimill

    Hi Roland,

    In the roadmap document it states

    CompositeProvider can use AdvancedDataStore Objects with NLS in specific join scenarios. (NLS with SAP IQ Slide 5)
    Can you elaborate please, customer is on BW 7.5 SP3 (HANA). Like which join scenarios are not supported or point to a document. Could not find details in SAP Note 2215265 w.r.t ‘Joins’.
    Thank you.

     

    (0) 
  14. GTC SAP BW

    Hi Roland,

    we are facing an issue when we are adding the one field to NLS enabled ADSO.

    Is there any prerequisite to follow.

    Regards,

    Prasad V

    (0) 
  15. Arminder Singh

    Hi Roland,

     

    Once the data is archived in NLS, it is said that we can have an SDA connection to read the data, But what does SAP recommend, should we create a virtual table on NLS table and use it in calculation view and a new report on top of it or is there a way that the virtual table created using SDA can be used with existing info-provider?

     

    Thanks

    (0) 
  16. Ranjit Ethirajulu

    Hi Roland,

    Might be I am reiterating the question :).

    1. Do we have straggler on ADSO as well? Please share any supporting document.
    2. In our scenario, we have stragglers coming in almost every DSO. As customer don’t want to proceed with 3rd party tool, what is the next available option/solution?
    3. What are options on BW4HANA for straggler management.

    Kind Regards,

    Mohit

    (0) 
  17. Roland Kramer Post author

    Hello Mohit
    1. The Pilot Program for “Straggler Support on aDSO for SAP BW 7.50 on HANA” was stopped recently.

    2. At this time there is no adequate solution from SAP available.

    3. using a partner solution from PBS-Software for Straggler Support on classical objects like DSO

    Best Regards Roland

    (0) 

Leave a Reply