BW 3.x InfoSources are sets of logically-related InfoObjs that are available in the form of a communication structure.
Multiple DataSources can be assigned to an InfoSource, either from different source systems or not. Exceptions: Only one source system for hierarchies InfoSource.
In transfer rule maintenance,
you assign DataSource to InfoSource;
determine whether the communication structure is filled with fixed [...]
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 [...]
- 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 [...]
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 [...]
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 [...]
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 [...]
There is no difference. KPI is more stylish name to Keyfigures. But the organizations say that more important KFs which are crucial to the Organizations should be termed as KPIs.
Key figures are Numeric Values and stored in SAP data type Amount, Quantity, Number, Integer, date, Time.
Key Performance Indicators, also known as KPI or Key Success [...]