Categories Uncategorized SAP BW Near Line Storage solution (NLS) based on SAP IQ April 4, 2013 | 2,484 Views | Michaela Pastor more by this author BW (SAP Business Warehouse) Enterprise Data Warehousing / Business Warehouseformer jive documentnlsnls configurationsap first guidancesap nls share share tweet share Follow For NLS information please refer to blog https://blogs.sap.com/2016/10/12/sap-nls-solution-sap-bw/ Alert Moderator To report this post you need to login first. 11 Comments You must be Logged on to comment or reply to a post. Mikhail Budilov December 20, 2014 at 6:09 pm be aware about nav attr reporting with NLS works with filtering on navigational attributes on any supported release (as of BW 7.0). However the filter itself is not moved into NLS, since NLS storage does not store the master data. Example: if you filter on an attribute of a material, NLS returns all relevant material data rows and OLAP processor does the filtering. So the query result is correct however the runtime can be very long. like (0) Charlie Gil February 6, 2015 at 1:51 pm Experts, Is BW NLS with Sybase IQ working for BW system with other database (like MS SQL) than HANA DB as well? Thanks like (0) Rex Geissler February 6, 2015 at 2:41 pm Yes, BW NLS with SAP (Sybase) IQ works fine with any other database as well. However, the BW on HANA has many features that you should consider going forward. Regards, Rex like (0) Diego Curci February 11, 2015 at 8:26 pm I was wondering if there is a recommendation on where in a data model to begin archiving? Is it best to start archiving from DSO –> Infocube or Infocube –> DSO? like (0) Pavan Mulpur February 13, 2015 at 6:10 am Also when my database is SAP HANA why do I have to use SybaseIQ for archiving? Can’t I archive using SAP HANA database? Is it not adding to my cost by having an additional database in the form of SybaseIQ? like (0) Roland Kramer February 13, 2015 at 3:42 pm near line storage is not archiving. it is a reallocation of existing historial data with permanent access to it. furthermore it is a simple question of TCO. SAP IQ is THE column based database with compression for historical data as fast as the former BWA. Best Regards Roland like (0) Pavan Mulpur February 16, 2015 at 1:19 am Thank you Roland for your reply. But the beauty of SAP HANA is that it also allows us to store data in columnar fashion isnt’t. Then can’t I use SAP HANA for storing historical data along with current data. I agree SybaseIQ offers lot of benefits, but what I am unable to understand is what is that one or more killer features of SybaseIQ that clients are going for it just for storing historical data instead of using SAP HANA. Thank you. Regards, Pavan. like (0) Roland Kramer February 17, 2015 at 11:05 am Hi, simply TCO. Imagine there is no HANA, SAP/Sybase IQ is already there since 15 Years. That’s why it is even more benficial for customers still running classical DB’s as there primary databease. Best Regards Roland like (0) Swapnil Tholiya April 9, 2015 at 6:53 pm Hi Roland, I want to propose NLS to my current client. They currently have BW on HANA with no NLS. I know that HANA DB is costly as compared to Sybase IQ but in order to prove the case, can you please share some indicative figures as to how much would be the savings in cost if for ex. 100 MB of HANA is moved to Sybase IQ DB? Thanks Swapnil like (0) Andres Bermudez March 9, 2015 at 9:59 pm Hi all, I can compress after NLS was deployed? thanks like (0) Jonathan Bolton April 23, 2015 at 1:36 pm Hi The pros and cons of using a write optimized DSO or standard one, immediately after the PSA are discussed below. SAP has introduced a straggler management option for standard DSOs attached to NLS. This allows for updates to be done to data that has already been archived in NLS. The other option is to use write optimized DSOs. Please can you share any project experiences you may have with NLS, specifically the logic behind which DSO type was used. like (0) Comments are closed.