Заметки про ADSO

Удаление перекрывающихся запросов(Delete Overlap Requests) и активация ADSO:
https://wiki.scn.sap.com/wiki/display/BI/ADSO+InfoCube
https://answers.sap.com/questions/81570/why-we-need-to-activate-the-data-in-advance-dso-fo.html

SID в ADSO:
https://archive.sap.com/discussions/thread/3859170
https://archive.sap.com/discussions/thread/3851043

Таблицы для ADSO в ABAP-словаре

https://sapboard.ru/forum/viewtopic.php?f=12&t=96638

Идентификация (присвоение) нав. атрибутов для композитного провайдера

Right click partprovider on the left side, then you get the option "Show Unassigned Navigation Attributes":

https://answers.sap.com/questions/415644/bw-on-hana-compositeproviderhcpr-navigation-attrib.html
https://wiki.scn.sap.com/wiki/display/BI/Consistent+Navigation+Attribute+Mapping+in+a+HCPR

0LOGSYS и 0SOURSYSTEM при миграции потоков с 3.x до 7.x

При миграции потоков с 3.x до 7.x возник вопрос с 0LOGSYS и 0SOURSYSTEM.

Решение:
0LOGSYS заполняем в трансформации так:
p_r_request->get_logsys( ).
0SOURSYSTEM заполнится сам.

Note 1052648 - Migration of transfer rules and update rules for BW7.x

Note 2957498 - SAP BW/4HANA Conversion and aspects for infoboject 0LOGSYS and/or 0SOURSYSTEM included aDSO and DSO

Aspects for Infoobject 0LOGSYS and/or 0SOURSYSTEM

Goodbye BEX..

SAP Note 2609031 - Sunset of BW Business Explorer (BEx)
:'-(

BW/4HANA виртуальный провайдер на BAdi

Начиная с SP04 (DW4CORE) в BW/4HANA можно делать виртуальные провайдеры используя BAdI  RSO_BADI_PROVIDER (аналог виртуальных кубов на ФМ в BW on NW).
https://help.sap.com/viewer/107a6e8a38b74ede94c833ca3b7b6f51/1.0.6/en-US/9d157e8996714771bb11c1fab34a6412.html

Upgrade to SAP BW/4HANA

SAP BW/4HANA help:
https://help.sap.com/viewer/p/SAP_BW4HANA

2189708 - SAP BW/4HANA Add-On Handling and Usage
https://launchpad.support.sap.com/#/notes/2189708

2347382 - SAP BW/4HANA – General Information (Installation, SAP HANA, …)
https://launchpad.support.sap.com/#/notes/2347382

2421930 - Simplification List for SAP BW/4HANA
https://launchpad.support.sap.com/#/notes/2421930

Simplification Item Catalog
https://launchpad.support.sap.com/#/sic/

2383530 - Conversion from SAP BW to SAP BW/4HANA
https://launchpad.support.sap.com/#/notes/2383530

2462639 - BW4SL - Interfaces and Customer-Specific ABAP Development
https://launchpad.support.sap.com/#/notes/2462639

2458521 - Conversion of obsolete customer exits (CMOD) to enhancement spots in SAP BW
https://launchpad.support.sap.com/#/notes/2458521

Conversion from SAP BW to SAP BW/4HANA Webcast Summary
https://discuss.asug.com/groups/bi/blog/2017/10/03/update-conversion-from-sap-bw-to-sap-bw4hana

2575059 – SAP Readiness check for BW/4HANA
At Last – A Readable BW/4HANA Readiness Check Report!

ФМ для получения значений Customer-exit переменной

RRS_VAR_VALUES_EXIT_FILL

Загрузка дельты по FI-AA

1) Активировать BADI FIAA_BW_DELTA_UPDATE(пакет BWFIAA) в транзакции SE19
2) запустить инициализацию дельты с переносом данных 0ASSET_ATTR_TEXT
3) запустить инициализацию дельты с переносом данных 0ASSET_AFAB_ATTR
4) Запустить полную загрузку данных 0ASSET_AFAB_TEXT
5) запустить инициализацию экстракторов транзакционных данных 0FI_AA*


Загрузку дельты производить в таком же порядке: сначала ОД, потом транзакционные данные.

How to setup preview tools for BW Modeling Tools

2531736 - BWMT:How to setup preview tools for BW Modeling Tools
https://launchpad.support.sap.com/#/notes/2531736

HANA заметки

HANA based BW Transformation – SAP Notes
https://blogs.sap.com/2016/06/09/hana-based-bw-transformation-sap-notes/

Performance tuning for calculation views:
•Filter the data at the base models and try to reduce the data set to what is really needed.
•Avoid the isnull check before filtering the data
•Avoid aggregation nodes unless really needed.
•push the custom calculation to the top most nodes as possible
•Apply optimize join and cardinality in each join
•If you have joins on MANDT/CLIENT/RCLNT …. Fields - remove those joins everywhere and instead put directly filter on value ‘001’ for MANDT/CLIENT/RCLNT…. Fields where you call tables.
•Use the planViz to analyze the view

... to be continued