stopsap r3
SQLPLUS
alter database backup controlfile to trace;
shutdown
exit

/oracle/…/saptrace/usertrace contains a new file ora_.trc
(the latest file).
Rename this file to create.sql (mv ora_.trc create.sql)
edit the file create.sql:
delete all lines up to STARTUP NOMOUNT
change MAXDATAFILES 1022
Then delete all lines after datafile creation.
edit $ORACLE_HOME/dbs/init[sid].ora
change db_files=1022
rename all control files.
See control files in $ORACLE_HOME/dbs/init[sid].ora
sqlplus
startup nomount
@create.sql
alter database open;
startsap r3

BW performance, Basis & DB, SAP BW, SAP General | No Comments »

To find out the SQL statements that used most CPU:

column SQLTEXT word_wrap format A63
column GETS wrapped format A16
column CPUPEREXEC wrapped format A16
column ELATIME wrapped format A16
column CPUTIME wrapped format A16

SELECT * FROM
(SELECT
TO_CHAR(CPU_TIME) CPUTIME,
TO_CHAR(DECODE(EXECUTIONS, 0, 0,
TRUNC(CPU_TIME / EXECUTIONS))) “CPUPEREXEC”,
[...]

BW performance, SAP BW | No Comments »

I got 14M records in RSDDSTATAGGRDEF a week after “Go-live”. It is one of the stats table. Delete them using Workbench => Tools => BW Statistics for InfoProviders.
Tables, which are filled by OLAP:
RSDDSTAT
RSDDSTATAGGR
RSDDSTATAGGRDEF
Tables, which are filled by WHM:
RSDDSTATWHM
RSDDSTATCOND
RSDDSTATDELE
https://www.sdn.sap.com/irj/sdn/thread?threadID=23046

BW performance, SAP BW | No Comments »

For a company with fast growing data warehouse usage, these BW team members should be in place.
Data warehouse architect + Project Manager: who oversees the entire project with focus on architecture design, tools/patches/technology evaluation, system integration. Set overall team priorities on regular base.
BW functional analysts + Data modeler: who collect / translate business requirements, create [...]

SAP BW | No Comments »

https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/3518
1. Workload Monitor (ST03/ST03N)
2. Tune Buffers Monitor (ST02)
3. Statistical Records (STAD)
4. SQL Trace Analysis (ST05)
5. Workprocess Overview (SM50)
6. Operating System Monitor (ST06)
7. Table Call Statistics (ST10)
8. Database Activity (ST04)
9. Profile Maintenance (RZ10)
10. CCMS Monitoring (RZ20)

SAP General | No Comments »

This page contains links related to BW certification.
Currently, no more BW3.5 certification test available. (Apr 2008)
Also, SAP is in process of changing the Certification pattern.
There is going to be three levels of certification:

Associate consultant
Consultant
Senior/Advanced/Professional

As for now, SAP is offering Associate level in BI
BI7,0 test info
2004s test info
BI whitepaper
Integrated planning
Business explorer
BI/Data warehouse
Sample questions
Discussion on SDN
Advise from sdn [...]

BW Certificate | No Comments »

- Today is yesterday
Define the dependent attribute of your multi-dimensional model as navigational attribute of the characteristic.
Material group as navigational attribute in the material master table
Define the dependent attribute of your multi-dimensional model as a node attribute of an external hierarchy of your characteristic.
Material group as node attribute of an external material hierarchy

If you want [...]

BW Certificate, BW Modeling, SAP BW | No Comments »

help.sap.com page on partitioning
BW performance article in PDF 
 https://www.sdn.sap.com/irj/sdn/thread?threadID=69096
physical partitioning is done at database level and logical partitioning done at data target level.
For physical partitioning: 
The performance gain is only gained for the partitioned InfoCube if the time dimension of the InfoCube is consistent.

In the InfoCube maintenance choose Extras ® Partitioning, and specify the value range. Where necessary, limit [...]

BW Certificate, BW Modeling, SAP BW, SAP General | No Comments »

In balanced hierarchies (balanced/standard), the branches of the hierarchy all descend to the same level, with each member’s parent being at the level immediately above the member. An common example of a balanced hierarchy is one that represents time, where the depth of each level (year, quarter, and month) is consistent.
Unbalanced hierarchies includes levels that [...]

BW Certificate, BW Modeling, SAP BW | No Comments »

Line item: the dimension contains precisely one characteristic.
High cardinality: the values in dimension table are not repeated in fact table. E.g. sales document number.
degenerate dimension: size of a dimension starts to increase and approaches the size of fact table, the dimension only contain one characteristic. item. The solution is to mark the dimension as line [...]

BW Certificate, BW Modeling, BW performance, SAP BW | No Comments »