27interviews.blogspot

This blog doesn't contain any copied information or copyright content from other sites. Every topic i presented in this blog is authored myself. Every time i tried to help the sapients to understand the concept in an easier way. Thats it. Have a Grt Day!

Translate

RSA1 GROUPING MODE OF BW OBJECTS IN TRANSPORTS:


RSA1 GROUPING MODE OF BW OBJECTS IN TRANSPORTS:


Many of them don’t know what exactly the RSA1 Grouping means.
Without thorough knowledge we can’t do anything perfectly.
I had elaborated the topic to make you understand the concept in depth.

Concept is below:
We often develop objects in SAP. Like InfoObjetcs, InfoCubes, Queries, WebTemplates, TransformationRules, InfoSources etc.

But where to develop the objects?
In Development Box or in Production Box?

We develop objects in Development Box because; it’s highly risky to develop objects in Production Box as:
·         We can lose the data,
·         And the data flow changes also.
After developing the objects in Development Box, then we transfer to Production Box
I.e. in SAP Terminology it’s simply Transporting.

The quality of data which is transported will affect the activation process and gives errors.
The dependencies of the objects are mapped by Grouping Mode by which the objects are collected.

SO BELOW ARE THE 5 GROUPING METHODS:
Here the mandatory point to be noted is that, data will be collected from DEV BOX and collected to PRO BOX.

·         Only necessary objects
·         In data flow before
·         In data flow after
·         In data flow before and after
·         Save for system copy

ONLY NECESSARY OBJECTS (DEFAULT OPTION):
If we select only necessary objects, only the necessary or related objects are selected and transported.

IN DATA FLOW BEFORE:
If you select this option, InfoCube, TransformationRules & InfoSources are collected and transported.

IN DATA FLOW AFTER:
If you select this option, Queries and WebTemplates are collected and transported.

IN DATA FLOW BEFORE AND AFTER:
If you select this option, InfoCube, TransformationRules & InfoSources, Queries and WebTemplates are collected and transported.

SAVE FOR SYSTEM COPY:
If you choose this option, it’s mainly used for copying or renaming the SourceSystem, i.e. recreation of objects for SAP DEV & SAP PRO systems are avoided. And all the objects are SourceSystem dependent DataSources are collected in a change/TransportRequest.

The main logic to understand is that, by selection save for system copy helps saving the mapping between the objects & SourceSystem is not deleted after the request is applied or imported.

GROUPING MODE CONCEPT IN DEPTH:
(All the figures for illustration purpose only)

Figure 1
 

Here in the above diagram Figure 1, you can see, I had mapped the newly developed objects to the grouping mode, shown graphically. In this we can see newly developed objects such as InfoObjetcs, InfoCubes, Queries, WebTemplates, TransformationRules, and InfoSources are mapped to the corresponding Grouping Modes.

MAPPING LOOKS LIKE THIS IN ABOVE ILLUSTRATION:
In Data Flow Before mapped to InfoCubes, TransformationRules & InfoSources.
In Data Flow After mapped to Queries & WebTemplates.
In Data Flow Before and Afterwards mapped to InfoCubes, TransformationRules, InfoSources, Queries and WebTemplates.

So see all the corresponding mappings.

Figure 2


In Figure2 above we can see the screen shots in depth, which I had mapped the Grouping mode.

Figure 3:


Actually this is the DataFlow of SAP BW and SAP BI. Here if you see, you can easily understand the whole concept about what we do in the In Data Flow Before & In Data Flow Afterwards.


COLLECTION MODE:
In the collection mode there are 2 options
One is default which is Collect Automatic ally
And second is Start Manual Connection

After doing the above Grouping and Collection we click on Transportto transport the objects.


Thanks for reading!

Correct me if there are any mistakes.

Template versus Reference InfoObjects - SAP BIW


Dear Readers,
This question is most important. Many of them don't know the exact difference between Template and Reference InfoObject. So I had tried maximum to explain in a very easier way to understand the concept.

So these are the differences between Template InfoObject and Reference InfoObject:

Differentiation point
Template InfoObjects
Reference InfoObjects
Use
We can use these both Template and Reference in Development projects as per requirement. And Creating new InfoObjects using Template and reference slims the time, in Development Projects.
Main Difference
When using Template, we can consider as Navigational Attributes.
When using Reference, we have only Display Attributes. If Navigation attributes used, they will reflect / seen as Display Attributes only
Restrictions
No restrictions
Restrictions
What will be copied
Master data attributes, compounding attributes and technical properties are copied to new InfoObjects.
Master data attributes, compounding attributes and technical properties are copied to new InfoObjects and all the reference InfoObjects data also can be used
Editing & Modifications
Yes by changing attributes, data type, length of the newly created InfoObjects
No, we cannot change the length, data type, master data attributes, compounding attributes
Maintain Master Data
maintain master data is possible
But maintain master data is not possible
Master Data Table
It will have its own master data table if we use Template InfoObject
It will have the same master data table as Reference InfoObject
Transformations
Yes possible
Not possible, error message occurs
Loading data
Yes
Not possible because reference not allow transformations
Used as Data Target (Insert Characteristic As InfoProvider)
Yes
No
Drill down Capability
Yes
No

Interview Point of View:

We can use these both Template and Reference in Development projects as per requirement. And creating new InfoObjects using Template and reference slims the time, in Development Projects.

Template InfoObjects:
When using Template, we can consider as Navigational Attributes. Master data attributes, compounding attributes and technical properties are copied to new InfoObjects. Editing and modifications are possible by changing attributes, data type, and length of the newly created InfoObjects using Template. It will have its own master data table if we use Template InfoObject. And maintain master data, Transformations, Loading data is possible, and can be used as Data Target (Insert Characteristic As InfoProvider) and Drill down capabilities for InfoCube are supported using Template InfoObject.

Reference InfoObjects:
When using Reference, we have only Display Attributes. If Navigation attributes used, they will reflect / seen as Display Attributes only. Master data attributes, compounding attributes and technical properties are copied to new InfoObjects and all the reference InfoObjects data also can be used, but we can’t change the length, data type, master data attributes, compounding attributes and it will have the same master data table as Reference InfoObject & maintain master data is not possible. Transformations not possible, Loading data not possible, Cannot be used as Data Target (Insert Characteristic As InfoProvider) (error message occurs: Not possible because reference not allow transformations) and Drill down capabilities for InfoCube are not supported using Reference InfoObject.

A InfoObject (Main InfoObject) and
B InfoObject is a situation (reference or Template) using A InfoObject.

Simplest way to understand this concept of Template Reference InfoObjects:
This below is my assumption to make u better understand the concept!

So when we take into consideration of Reference and Template, just think these are twin brothers at home with same faces.
So,
Using Template (brother), he will be readily available for modifications.
Using Reference (brother), he will not ready available for modifications.
But both will work with same faces (faces here faces means Master data attributes, compounding attributes and technical properties)

At last
Template will accept changes/modifications.
Reference will not accept changes/modifications.


Thank you






ONLINE TEST - WISDOM JOBS

Dear friends, 
Happy to see all you again. Its great pleasure to find on-line test on SAP BW BI. When am updating my resume i found out this.
You all can test ur calibre.
I had also taken interview in Wisdom jobs!

These are the questions i answered(by taking test):

1. What application does not support delta update?
You answered:
FI/SL
 Correct Answer!
2. What is the T Code for "CAlling up AWB with LG Tree"?
You answered:
RSA13
 Correct Answer!
3. Third-party reporting tools can access SAP BW data directly via ODBO. (True or False)
You answered:
True
 Correct Answer!
4. What is the procedure for the LIS delta update?
You answered:
Activate “delta updating in the LIS” setting in the report “RMCSBIWC”
 Correct Answer!
5. In FI/SL we can create a ledger based on what type of tables?
You answered:
Summarization level tables
 Correct Answer!
6. Where can data be filtered in SAP BW?
You answered:
Query
 Correct Answer!
7. On the update rule, when I choose to initialize the data, what does that mean?
You answered:
I want to create a routine that blanks out the characteristic
 Correct Answer!
8. The following statements are not true about navigational attributes.
You answered:
Once an attribute is made navigational in an info cube, it is possible to change it back to a display attribute if the data has been deleted from the info cube.
 Correct Answer!
9. In BW, special characters are not permitted unless it has been defined using this transaction:
You answered:
rskc
 Correct Answer!
10. Can a single InfoSource be used to load Data to different InfoProviders?
You answered:
Yes
 Correct Answer!
11. How do we decide on the Characteristics to be included in a Dimension?
You answered:
When the fields (InfoObjects) have m: n relationship.
 Correct Answer!
12. Which of the following occurs as a result of degenerating dimensions?
You answered:
The grain of the fact table represents actual working documents like order number or invoice number
 Correct Answer!
13. What is a MultiCube query?
You answered:
It is a query divided using the relevant Basic Cubes into several queries that can be processed in parallel
 Correct Answer!
14. Which statement describes the functionality of drill-down?
You answered:
Manipulate the results of a query to consolidate detailed data to a higher level of summarization without having to rerun the query
 Correct Answer!
15. In which of the following elements can data transformation take place in SAP BW?
You answered:
Transfer rules
 Correct Answer!


Cheers
Hav Grt Day!

Replicate the data from source system in BI, How many ways I can do? (Screens)

I want to Replicate the data from source system in BI, How many ways I can do? (Screens)

3 methods we can do:
1.       Navigation: AWB, SourceSystems, select your source system, go to your data sources (MM), context menu, and then click on replicate DataSources
2.       By entering Transaction code RSDS
3.       Main Screen, go to DataSource, Select replicate DataSource (Ctrl+Shift+F2)


With screen shots:
1.       Navigation: AWB, SourceSystems, select your source system, go to your data sources (MM), context menu, and then click on replicate DataSources




2.       By entering Transaction code RSDS



3.       Main Screen, go to DataSource, Select replicate DataSource (Ctrl+Shift+F2)

Types of InfoObjects-Different types of InfoObjects SAP BI BW

Warm wishes to all readers again. Grt to see u all again.
Correct me if there are any mistakes pls.

The question may like this:

What are InfoObjects?
What are the types of InfoObjects?
What are Fixed Dimension InfoObjects, Can you say some of them? And how they differ from Characteristic InfoObjects and KF InfoObjects?


InfoObject:
Business evaluation objects are known in BI BW as InfoObjects. These play vital/important role in modeling. Everything is based on InfoObjects we create. Business evaluation objects (for example, customers, and sales) are referred to as InfoObjects in BW. InfoObjects are the smallest components in BW. For exapmle, Business Object like customer, product, etc....

So what they are so used for?
They are used to structure the information that is needed to create larger BW objects, such as InfoCubes or ODS Objects or InfoProviders.



InfoObjects are divided into:
1.       Characteristic InfoObjects  (Diagram 1)
2.       KeyFigure InfoObjects (Diagram 2)
3.       Fixed Dimensions –SAP defined (Diagram 3)
a.        TimeCharacteristics
b.       TechnicalCharacteristics
c.        UnitCharacteristics

Types Of InfoObjects

1.       Characteristic InfoObjects: Objects that are used to calculate and analyze present Key Figures.
                Eg.           Sales Office: 0 SALESOFFICE,
                                Customer: 0CUSTOMER,
                                material: 0MATERIAL)
                               
2.       Key Figure InfoObjects:
Data part of an InfoObject. They are quantifiable values. (provides the values to be evaluated)
                Eg.           Quantity Sold: 0QUANTITY,
                                Revenue: 0REVENUE)

3.       Time Characteristic InfoObjects :
Characteristics that are assigned to the dimension of time. Time characteristics form the time reference frame for   many data analyses and evaluations. they are delivered with Business Content & its not possible to define your own Time Characteristics.
                Eg.           calendarday: 0CALDAY: Time characteristics with largest granularity
                                calendaryear:0CALYEAR : Time characteristics with smallest granularity
                                Fiscal Year: 0FISCYEAR : Time characteristics with smallest granularity)
               
4.       Technical Characteristic InfoObjects:
Only of structural use within BW. These have an organizational function within SAP.
                Eg.           requestid: 0REQID
                                Changeid: 0CHNGID
                                (infoobject changeid delivers the numbers allocated during change runs)
                                (infoobject 0reqid delivers the numbers the system allocates when loading requests)
5.       Unit InfoObjects:
Units for the Key Figures. they enable keyFigure values to be partnered with the corresponding units in evaluations.
                Eg:           currency: 0CURRENCY
                                amount 0AMOUNT
                                unit: 0UNIT



Characteristi InfoObjects: (Diagram1 )
KeyFigure InfoObjects: (Diagram 2)


FixedDimension InfoObjects: (Diagram 3)





The vital/imprtance of InfoObjects  of Incan be evaluated by reading the below points:
Everything is based on InfoObjects!
The Communication Structure displays the structure of the InfoSource. It contains all (logically grouped) of the InfoObjects belonging to the InfoSource of the SAP (BW) System, like Chars & KeyFigure Objects.
Extract Structure is a record layout of InfoObjects.
Transfer Structure maps data source fields to InfoSource InfoObjects.
The update rules specify how the InfoObjects (Key Figures, Time Characteristics, and Characteristics) are updated in the DataTargets from the Communication Structure of an InfoSource. You are therefore connecting an InfoSource with an InfoCube or ODS object.
The update rules assign InfoObjects in the InfoSources to InfoObjects in data targets & establish many to many relationships between InfoSource & DataTargets.
Transfer rules are a set of transformations defining the mapping of fields available in a specific DataSource to the fields used in the InfoSource definition. We create transfer rules by assigning a data source to InfoSource and assigning InfoObjects to the fields.
From 3 types of transfer rules, you are only ever allowed to enter one which is InfoObject.
Routine: Conversion routines are ABAP programs that you can create yourself. The routine always refers to just one InfoObject of the transfer structure.
An InfoSource is a quantity of InfoObjects that belong together and that contain all the information available on a business process (for example, cost center accounting). The structure where the InfoObjects are stored is called a communication structure.
An InfoSource contains a number of InfoObjects which structure the information needed to create InfoCubes / ODS Objects in the SAP (BW) System.
Is used to load data from Communication Structure to Data Targets i.e ODS, Infoobjects, InfoCubes by using Update Rules.
The components of an InfoSource is
Communication Structure
InfoObject
InfoArea is used to organize InfoCubes & InfoObjects. Each InfoCube is assigned to an InfoArea.
Through IOC, each InfoObject is assigned to an InfoArea.



Thanks for reading

HOW TO CRACK SAP BI BW - INTERVIEW


Warm wishes to all readers. Its grt to see u all again.

 Am getting many mails from readers asking questions regarding the interview.
They asked:
Am fully perfect (prepared) in SAP BI, but am having fear of attending the interview.
What the questions the recruiter ask?
How much experience to add in my resume?

Don't get fear, no one will shoot u if u go to attend interview.....
Questions will be as per the Company's Project Requirement......
Experience to project? More the experience u project, much tough will be the interview.....

So what to do: Consider u r going to war, assume u had no exact weapon. so what happens, ultimate failure occurs. So in our scenario, Weapon is SAP BI BW knowledge to win.

If you want to study all the SAP BI BW contents, it may take 2-3 yrs, i.e. equally time taken for graduation course. But i want to say one thing thoroughly prepare the concepts, where your work will flow in Real-Time.

Your work will focus on only these concepts:
Modeling of:
InfoObjects
InfoCube
InfoProvider
InfoSets
DTP
InfoPackages

Extractions: FI_SL , FI_GL, CO_PA, Generic Extractors, and Various DataFlows
Reporting: Creating Input Ready Query, BEx Query Designer, BEX Wad etc.

Others:
Process Chains
APD-Analysis Process Designer

Maintenance:
Performance regarding Front end (Reporting) and Back end (Modeling & Extraction)

These are the common interview questions repeatedly they ask in every interview face-to-face or telephonic.


  1. Tell something about your self?
  2. Differences between star schema & extended star schema?
  3. Checking extractor & How its working?
  4. What is reference and template?


If any one ask u the 3 questions, leaving 1st question.
What the answer will be?
Memorize the answers now as this is a real interview.

You must explain each concept broadly minimum 3-5 minutes for each question, so that the interviewer comes to know you have knowledge. Am only insisting on main thing, gather knowledge (Theoretical concepts) to crack interview.

Ok.
  1. Tell something about your self?
What you say? Don't say your history starting from ur child hood (Introduction). If u say all about: starting of education and the year of passing and regarding the career, the interviewer will become bored.

So what to do?
Try only to explain the strengths u had, and explain ur work on SAP BI as a consultant.


Now feel relaxed.
Ok Readers! Just rate (1-10) your self now how perfect you are. So u r now in ur shoes and know ur capability.

I like this below quote said by Dr. Seuss
You have brains in your head. You have feet in your shoes. You can steer yourself in any direction you choose. You're on your own, and you know what you know. And you are the guy who'll decide where to go.
Said by Dr. Seuss 

Prepare well.

Thank you so much reader
Hav Grt Day



Star Schema Vs Extended Star Schema (Differences)


Correct me if there are any mistakes pls.
This question will be asked in every BI BW interview.
May be it may comes in second or third in ranking.



DIFFERENTIATING POINT
STAR SCHEMA
EXTENDED STAR SCHEMA
STRUCTURE
Fact table surrounded by dimension tables
Fact table surrounded by dimension tables, surrounded by SID table, surrounded by master data attributes texts & hierarchies.
DIM & MD TABLES
Dimension tables=master data table (i.e. Same)
Dimension table not =master data table(i.e. Not same)
Master data resides inside the fact table & dimension tables also reside inside the cube
Master data resides outside the InfoCube & dimension tables reside inside the InfoCube & contains no master data
GRAPHICAL REPRESENTATION
Star like
Not star, scattered
ANALYZING
16 angles
16*248(SID tables)
Common dimensions
Unit & time
Keys
Fact table: PK ( primary key)
Dimension table: FK ( foreign key)
PK, SID (SID tables provide the links between the md & the dim tables)
Size
Fact table : huge
Dimension table: small
Fact table: small
Dimension Table: Big
Tables
No SID tables, only fact tables & dimension tables
F table, E table, Packaged dimension, Time dimension, Unit dimension, N=user dimension tables. Extra tables that are SID tables, master data tables( P, Q, T, X, Y)
Multiple languages
No
Yes because hierarchies are present
Data retrieval & performance
Data retrieval & performance  slow as degraded uses alphanumeric keys in fact table
Data retrieval & performance fast as SID’S is a numeric key in fact table
Slowly Changing Dimension
Not applicable
Yes applicable time dependent
Query Performance
Slow or degraded
Enhanced performance, because aggregated KF are stored in their own fact tables
Dimension sharing
No
Yes shared by using SID tables
MD reusability
No
Yes, reusable
Aggregates
No
Yes, aggregates in its own table for faster access
SAP terminology
Simply cube
Simply InfoCube
Data Redundancy
Dim tables are specific to a fact table, i.e. Dimensions are not shared across other fact tables and Cubes. When another fact table needs the same dim data, another dim table that’s specific to a new fact table is needed. So this situation leads to slower performance, because data will be duplicated in several dim tables  instead of sharing data from one single table
There is no data redundancy because, there the dimension tables are shared from one single table.
Diagrammatic representation
Overall
See below Diagram 1
See below Diagram 2
Diagrammatic representation
Elaborated
See below Diagram 3
See below Diagram 4

Diagram 1 Star Schema:



Diagram 2 ESS Extended Star Schema:


Diagram 3 Star Schema elaborated:


Diagram 4 ESS Extended Star Schema elaborated:




For interview purpose you can explain as below:



STAR SCHEMA – a representation of a cube:
Star Schema is a model in which Fact table surrounded by dimension tables. Dimension tables=master data table (i.e. Same ) and Master data resides inside the fact table & dimension tables also reside inside the cube, appears as a star like in diagram or graphical representation. We can analyze the data in 16 angles and has two common dimensions, Unit dimension & time dimension, with two keys (primary key) PK for Fact table: and FK (foreign key) for Dimension table. Actually the size of the Fact table is huge and the size of Dimension table is small. Data retrieval and performance is slow as degraded because of alphanumeric keys in the fact table. So the query performance also will be slow. In SAP terminology, it is simply called CUBE. Important point here to consider in star schema is data redundancy or data duplication occurs, i.e. dimension tables are specific to a fact table, i.e. Dimensions are not shared across other fact tables and Cubes. When another fact table needs the same dimension data, another dim table that’s specific to a new fact table is needed. So this situation leads to slower performance, because data will be duplicated in several dim tables instead of sharing data from one single table. The major drawbacks include, star schema doesn’t support aggregates, hierarchies, multiple languages, slowly changing dimensions, and master data is not reusable and no drill down capabilities supported.

Extended Star Schema: E S S: Representation of an InfoCube:

Extended Star Schema is a model in which the fact table is surrounded by dimension tables, surrounded by SID tables, surrounded by Master Data attributes, texts and hierarchies. Dimension tables are not equal to master data tables, I.e. not same and master data resides outside the InfoCube and dimension tables resides inside the InfoCube and contains no master data, appears not as a star like, rather it looks like scattered in diagram or graphical representation. We can analyze the cube in 16 into 248 (SID tables) and has three common dimensions like packaged dimension, time dimension & unit dimension, with PK (primary key), SID tables which provide the links between the master data and the dimension table. Actually the size of fact table is small and dimension table is big. Here in the E S S apart from F, E, P, T, U, N tables, extra tables that are SID tables master data tables that are P, Q, T, X, Y are formed. Data retrieval and performance is fast as SIDs has numeric key in the fact table. So the query performance will be faster. In SAP terminology it is simply called InfoCube and the master data in InfoCube-E S S is reusable. And there will be no data redundancy because dimension tables are shared from one single table. Importance of E S S is that it supports aggregates as it has aggregates in its own table, supports Hierarchies, supports Multiple language, supports slowly changing dimensions, supports drill down capabilities & the master data is reusable.




Correct me if there are any mistakes pls.
There was an error in this gadget