topic Re: BIW -Security in Application Development and Automation Discussions

BIW -Security

Former Member — Sun, 28 Jan 2007 08:00:50 GMT

Hi,

We are presently working on BIW Security which is new to me.

In BW we have Infocube,Infoobject,Info area...

Can any one tell me in which hierarchy all these object are been created in BIW and their relationship.

Thanks

prash

Re: BIW -Security

Former Member — Sun, 28 Jan 2007 09:03:28 GMT

Hi,

BW system is a Online Analytical Process system. it extract the data from various sources, like SAP systems and non SAP systems.

extracted data will be stored in the PSA, from PSA it moves to Infoprovider.

Infoprovider contains Infocubes, ODS objects, Info Objects, Multi provider and info sets. Logical grouping of info providers is Infoarea.

in BiW security is primarily focused on data level, mainly on Info area.

in the view of Basis security its on object level.(normally how we restrict users at cost center level in SAP R/3) we have to restrict users at info provider and its objects and its field level.

few Authorization objects will play kea role in BW security.

ex: 1. S_RS_COMP

2.S_RS_COMP1

3. S_RS_ICUBE **

4. S_RS_MRPO **

5. S_RS_ADMWB **

Thanks,

Praveen.

Re: BIW -Security

Former Member — Sun, 28 Jan 2007 19:15:08 GMT

Hi,

BW is OLAP .

BW has Characteristics and Key Figures which are collectively termed as Info Objects.

Key Figures are numeric values or quantities and Characteristics are descriptions of key figures.

Info Objects are like bricks which are used to build a house called Info Cube.

The Info Cube comprises of Fact tables and its associated dimension tables in star schema.

In BW info cubes and ODS objects are collectively called as Data Targets.

In BW Info Areas are the branches and nodes of a tree structure.

Info cubes are listed under the branches and nodes.

RSA1 is the Tcode user to create the objects in BIW.

BW can accept data from all kinds of source systems like:

R/3 Systems, BW Systems, lat Files, Eternal Systems.

The following hierarchy is been followed in BIW/BW:

1. Create Info Area

2. Create Info Object Catalogs ( Characteristics and Key figures)

3. Create Info Objects(Characteristics and Key figures)

4. Create Info Cube

Loading Data into the Cube:

1. Create a Source System from which you want to load the data into BW.

2. Create an Application Component

3. Create an Info source for Characteristic Data

4. Create Info Packages to load Characteristic Data

5. Check the loaded Characteristic Data

6. Maintain Master data

7. Create Hierarchy

8. Activate the Newly created Hierarchy

9. Create an Info Source for Transactional Data

10. Create Update rules for the Info Cube

11. Create Info Packages to load Transactional Data

12. Check the info cube contents i.e. Manage

*Pls award points if usefull.

Thanks

Re: BIW -Security

Former Member — Sun, 28 Jan 2007 19:23:08 GMT

Thanks a lot

It solved my problem

Bye