BDLS

BDLS - Logical system name conversion
This is used when the source system of BW(may be others, i donno) is changed.
Like, initially BWDEV100 is mapped to ECCDEV100, but due to some reasons like upgrade etc, BWDEV100 needs to be mapped to EC1DEC100 - then BDLS is used.


Some links
https://wiki.scn.sap.com/wiki/display/BI/BDLS+-+Logical+system+name+conversion

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/805eefcd-5428-2d10-c0ab-dc27a95b2c81?overridelayout=true

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/70a7b233-8be5-2c10-4190-aed723af5373?QuickLink=index&overridelayout=true&46316927648529

Excel to BW

Prerequisite excel settings

• Excel should be Macro enabled. ( Save excel with extension .xlsm)
• Make sure ‘Developer’ option is enabled.
• If not, Options -> Popular à ‘show developer tab in the Ribbon’.
• Create a table (Excel -> Insert -> Table ) in excel and then enter data inside the table ( might work directly inserting data in the sheet, I am not sure)
• Alt+F11 would open the VB screen.
• VBA Settings
• Clicking on ‘Developer’ tab in excel. It has VBA editor icon.
• Open VBA and check following in Tools à References
• ‘Microsoft XML.v6.0’ checked.
• ‘Micorsoft DAO 3.6 Object Library’ is checked.

Points to remember

Webservices

Extracting data from microsoft excel to BW using webservices.
  - MS Excel to BW

RSREQREDUCE

This is the main t-code which can be used to monitor the growth of the requests in the system.This gives the growth of all types of infoproviders - DSO/W.DSO/Infocubes/Master data objects

Green   : Good, No reduction needed

yellow  : Can be useful to reduce/delete the request list

Red      : Request list should be reduced/deleted.

Maintain a single datatarget

This gives overview of the single datasource selected.

Filter for Mass Actions

This gives us the ability to filter the report display using various options like only yellow data targets, data targets with more than 1000 records etc.

Mass Reduction of Requests

This option can be used to reduce the requests from InfoCubes and Std. DSOs.

Underlying FM : RSSM_REDUCE_REQUESTLIST

Mass Deletion of Requests

This is for Write Optimized DSOs and Master Data InfoObjects.

Underlying FMs:

WDSO  Deletion of requests : RSM1_DELETE_WO_DSO_REQUESTS

Master Data and Texts : RSS2_AUTODEL_REQU_MASTER_TEXT

RSSM_REDUCE_REQUESTLIST

Points to note

- This is the used for maintaining DSOs and InfoCubes.

- Change log should be deleted before running this program.

- The standard program needs 1000 requests  and min. of 1 month to delete the requests.

- As of 7.4 upgrade, enqueue and dequeue locks are added to the program, which ensures safe    running. before that version, program dumps/acts wierd when run when loading process is going on.

RSM1_DELETE_WO_DSO_REQUESTS

This is for deleting requests from Write Optimized DSOs.

In order to use this program, the requests in the W.DSO need to archived, else we cannot run the deletion. 

( ?? I ran the program the first time and it ran fine with out archiving. Next time, I ran it started giving me message, " Data target ZWDSOSALES is already reduced; no further deletion allowed. First undo the reduction" . Not sure why it reduced it the first time )

Points to Note

-          Min of 1 day is necessary to delete the entries

-          Min no. or requests = 1

RSSM_AUTODEL_REQU_MASTER_TEXT

This is used to delete requests from Master Data and Texts.

Only administration information and status manager information will be deleted.

-          Min no of days : 1

-          Min no. of records to remain : 1

-          The same program deletes Master data Attributes and Master data text.

o   When deleting attributes, give ‘0MATERIAL’ on the selection screen

o   For texts ‘0Material$T’.

Control tables

rsmonreqdelredu  - Creates an entry with the deletion job name and other details

RSICCONT - Has list of all requests in the infoprovider

Related Notes
Housekeeping for BW requests  : Notes
2248065 - P14; DTP; REDUCE: Dump CL_RSSM_STATMAN/CHECK_REQUESTS_EXIST

IDT

Creating Universe in IDT : Click

Common Terms in IDT : Click

Errors in IDT  : Click

Other Terms

Bursting:  Process for sending the reports to different users depending on their filters. Like, the same sales report can be sent to different users, depending on the plants they are looking for.



Adding filters on data
When adding filters to data on a table, use Derived table and then add filter in the SQL where condition rather than using the original table and inserting filter.

Other Online Notes

https://blogs.sap.com/2013/04/22/information-design-tool-tips-and-tricks/