Data Modelling

DSO :

1) SAP NetWeaver BI: DataStore Objects for Direct Update
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/17604

2) SAP NetWeaver 7.0 BI: new DataStore " Write-Optimized DSO"
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/7168

3) The Tech details of Standard ODS / DSO in SAP DWH
 http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/5049


4) Features of Change Log & Active Queue of Standard Data Store Object (DSO) in BI 7.0
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/17490

5)Add a column to DSO with 100+ million records
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/18397

6)Export complex Bex query data into DSO
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/18755%20

Data Modelling:


1) Why Attribute Change Run in SAP BI 7.0 is required?
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/17435

2) How to create a new Factory Calendar in BI system
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/17587

3) Creating Open Hub Destination using a Logical file to extract the data
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/17370



4) Notes on Currency Conversion in SAP BI 7.0
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/17436


5) Planning technologies – OLAP or OLTP?
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/15074


6) E Table Index deletion and generation – Solving compression issues
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/14526

7) SAP BW Indexing Scheme (ORACLE)
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/14359

8) Performance Improvement Roadmap for a Typical SAP BI System
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/14295

9) Useful Tips on Aggregates
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/13288

10) Make the most out of Open Hub Services: Integrate SSIS with SAP BI
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/13806

11) Attribute Change Run (ACR)
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/13726


12) Unit Conversion in BI-7.0.
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/11901


13) Demo on Table Partitioning, re-partitioning.
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/11989


14) Dynamic Update Rule for yearly cubes
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/11773

15) Use PSA for Testdata - Fill R/3 delta queue from PSA
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/11581


16) Master Data Reporting
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/10961

17) Properties of Analytic Applications : Interesting ways to store and read data : Part 5 - Database compression
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/10942

18)(Re)activation programs in BW-WHM
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/10693

19) New HowTo paper on Archiving of PSA data available
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/10122

20) Yes, you should floss your indices regularly
 http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/8750

21) Referential Integrity Check
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/8321

22) How to enhance business content infocubes with data from CRM transactions (SAP BW 3.xx, SAP CRM 4.0).
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/8411

23) ABAP to copy aggregates from one cube to another
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/8352

24) Transporting ISV Namespaces
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/8356



25) Spot on: Line Item Dimensions
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/7989


26) SAP NetWeaver BI 7.0: How to create a WebService with deep input structure
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/7300

27) SAP NetWeaver 7.0 BI: How to create a simple WebService to read data from a InfoProvider
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/7203


28) SAP NetWeaver 7.0 BI: How to create a simple Master Data update WebService
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/7106

29) SAP NetWeaver 7.0 BI: How to send XML data to BI - enhancement
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/7105

30) Easy-to-use, visually cool, and useful - Part IV --- How to combine different data sources and use this in a new application!!!!!!!
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/7063

31) Easy-to-use, visually cool, and useful - Part III --- How to improve this xApp!!!!!!!
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/6910


32) Defining Source System (with Basis Release < 640) in BI 7.0
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/6542


33) Integrate your Data in SAP NetWeaver BI using Consolidated InfoObjects
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/5888

34) Remodeling in NW BI 2004s
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/5772


35) Connecting To R/3 From Portal
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/5523


36) How to create a transport request 'Save for system copy'
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/5228

37) How to stress test BW the easy way
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/5178



38) Binary File in BW: what I can do with control file
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/4803


39) Work with XMLA Web Service for BI Data in External Applications!
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/4332

40) Installing DB Connect with MSSQL Server Database
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/4305

41) Invalid characters in SAP BW 3.x: Myths and Reality. Part 2.
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/4059


42) Invalid characters in SAP BW 3.x: Myths and Reality. Part 1.
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/3955

43) Fixed InfoObject with new data access method
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/3931

44) How to create ASCII text file for upload to SAP BW
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/3934


45) Long texts in SAP BW: Modeling – Follow Up
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/3761

46) Load lots of data “Faster” with Buffering Number Range
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/3456



47) Loopback Process - Follow up
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/3103


48)Interfacing data into BW using Perl, Ruby, or Python
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/2682

49) Generic Extraction via Function Module
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/2415

50) SAP BW and Business Content Datasources: in pursuit of the origins
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/2282

51) How to Load a Flat File into BW-BPS ... with different Client numbers through out your BW landscape
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/2113

52) ABAP code using BAPI's to load data into Cube from SpreadSheets
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/2075

53) Text infoobjects (Part 1)
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/1985

54) Custom fields and BW extractors : Making a mixed marriage work! (Part 1-1)
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/1414

55) Creating an OLAP Cube for MaxDB Database Table using Microsoft Excel
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/1329

56)End Routine - Tips and Tricks
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/18814%20

57)SAP BW: Plausibility Check in Transformations and Conversion Routines
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/19121%20

58)BI Master Data Partitioning
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/t/11%20

59)Learning SAP BW, The Twitter way - BW-Tweet #15
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/19457%20

60)Create DataSource for DB Connect step by step
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/19197%20

61)Avoid precision loss in your SAP BI implementation
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/19408%20

62)Customizing Cockpit: Managing delta queues when structure changes
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/18676

63) Step By Step Process for Virtual Key Figures and Characteristics through BAdi

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/60e34f63-f44c-2c10-488e-c89b04e0ca7c?QuickLink=index&overridelayout=true

64) Changing Source System ID?

65) SourceSystem Object Creation - RSAR501

66)Update Behavior of End Routine in Transformations

67) Programs for Activating BW Objects in a Productive System