Skip to Content
avatar image
Former Member

BW NLS(Near Line storage) a

Dear Gurus

We are planning to go for a POC on Near Line storage. I am looking into the online documents. If any one of you guys are already using the NLS solution, I would like to know more details about.

1. About your experience with NLS

2. Pros and Cons if any?

3. What is the compression factor you all got on the data.

4. Data model changes - like activating nav attributes is easy to implement or time taking

5. Share details about your POC, how you have tested the product.

6. Any interesting facts about NLS.

Can share any personal experience related to it.

Thank you guys in advance

Regards

RS

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

8 Answers

  • Best Answer
    Nov 06, 2013 at 08:40 AM

    Hi,

    you raised your question already a long time ago. Just in case you did not start your POC yet...

    In the meantime there is a rapid-deployment solutions from SAP available. This rapid-deployment solution is delivering a really good documentation on how to implement NLS (with or without HANA) step-by-step. Additionally, the rapid-deployment solution includes a service offering (from SAP or SAP Partners) that helps you to implement the solution in only 12 weeks. These 12 weeks include end-to-end implementation of the Near-Line storage solution with SAP Sybase IQ for a 3-tier SAP BW landscape that includes training, go-live preparation and go-live support.

    As a customer or partner, you will find more information on "SAP NetWeaver BW Near-Line Storage rapid-deployment solution" on SAP Service Marketplace: http://service.sap.com/rds-nls . You need your s-user.

    You might want to check my blog on the solution as well...

    Best regards,

    Susanne

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 06, 2012 at 02:46 PM

    Hi Ram,

    Here is the basic link ::

    http://scn.sap.com/people/rainer.schlachter/blog/2011/02/17/sap-bw-730-whats-new-in-the-sap-bw-near-line-storage-solution

    1) We have already initiated NLS implementation in my project. Basic advantage is the compression value. We are able to achieve 80-90 % compression for this archived data.This is reducing Total Cost of Ownership for the Client in long term.

    2) Pros = Compression advantage ; Cons  = Still awaiting to face them. (need lot of installations)

    3) 80-90 % compression

    4)  Some points apart, no action can be taken on data which is archived using NLS from BW side. If you need to reload the same you need to again reload this archived data and then add the new data for the defined period.

    5) The NLS will be carried out on the basis of the partitioning for CalWeek/Calmonth.

    I hope this would be a bit helpfull.

    Br,

    Arpit

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Arpit

                  We also want to do the NLS.

      1. Can you please tell me how to create the NLS Connection.

      2. What to enter in Name of Class, Destination, Conn. Parameter while creating the NLS Connection.

      We have SAP BW 7.5 system and Oracle 11i DBMS.

  • avatar image
    Former Member
    Aug 13, 2012 at 09:43 AM

    Hi Ram,

    regarding your questions please also see my answer to your previous post.

    I can also confirm the compression factor of 80-90%. To my knowledge all NLS solutions offer a similar compression factor.

    If you need to speak to someone who has a NLS solution installed, feel free to contact me. I can connect you to someone.

    best regards,

    Joseph

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 04, 2012 at 12:32 PM
  • Jul 31, 2012 at 11:15 AM
  • Aug 03, 2012 at 08:23 PM
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 13, 2014 at 12:06 PM

    Hi all,

    I would like to know if there is a specific function module that enables you to extract data stored in NLS.

    I usually use the function module 'RSDRI_INFOPROV_READ' for extract data no-stored.

    Thanks in advance,

    Mario

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Mario,

      it is not possible to say what is wrong here from the description. You have to get the parameters right. Also RSADMIN parameter RSDAI_LOOKUP has to be setup correctly (normally to value = 3, but this depends on NLS solution you have). There where also some bugs in the SAP interface, so there might be also some relevant SAP notes for the problem (this depends on your release). In general I suggest you contact your implementation partner for help, they should have some templates / guidelines. We at DataVard have even automated lookup translator to automate the change of lookups, since the translation itself can be a lot of work.

      Cheers,

      Martin

  • avatar image
    Former Member
    Mar 19, 2015 at 11:38 AM

    Hi,

    Please find the link SAP NetWeaver BW Near Line Storage solution (NLS) based on Sybase IQ to know more NLS based on Sybase IQ. which helps in knowing the advantage of NLS based on sybase IQ and about use of nav attributes.

    Basic Advantage is its good compression range.

    The NLS will be carried out on the basis of the partitioning for Calweek/Calmonth.

    for more FAQ's on NLS please refer SAP BW NLS- Frequently Asked Questions

    Thanks

    Nikhil

    Add comment
    10|10000 characters needed characters exceeded