Hi
13/June/2012
04/June/2012
04/June/2012
04/June/2012
04/June/2012
04/June/2012
04/June/2012
05/June/2012
Q.14 In which scenarios u have used ABAP (ABAP team)?
Ans Basically we can use ABAP Code in multiple scenarios while we are implementing BI project
Here some scenarios I have in used in my recent project
As you know in SAP BI 7.0 Four types routines are supported like
1.)Characterstic routine
2.) Start Routine
3.) end routine
4.) Expert routine
Characteristic routine: Is for simple routine used in project for calculation purpose at transformation level
Example you have 3 info object a.) cost price b.)net price c.) profit
You have to calculate profit info object value (formula: net price- cost price)based on other infoobjects(cost price and net price)
In this scenarios we can use is characteristic routine This can be done at report level also by using calculated key figure or formula.
The difference between Start routine and end routine is start routine perform its operation before trasformations(befor data loading ) end routine performs its operation after transformation(after data loading )
Scenarios for these start routine and end routines are
Start routine you can use in the scenario of while you want to load based on one condition like if sales > 1000 then only load otherwise no for this scenario we can use this routine
End routine we can use in situation we want to delete the records with zero sales value in this case we can use End routine(performs it operation after transformation)
Expert routine is totally different which will use in case of while our transformation not helping. In this case we can go for expert routine .Delete all our transformation and create the expert routine
Need perfect scenario for Expert routine Click Here
For all types routines document Click here
And also we can use these abap in customer exit at reporting level
Scenarios for customer exit if suppose you want to pop up current month and year in variable(default value) then in this case you can use customer exit
Actually here istep functions we are using to generate the current the current month in customer exit
they are four types of isteps function available
istep0,istep1,istep2,istep3
istep0 is for authorization check
istep1 is for populating default value (before variable pop up it operates)(current month)
istep2 is for generation previous month based on current mont or user input(operates after variable popup)
istep3 is validation check and to recall (not sure)
04/June/2012
04/June/2012
Q.12 What is line item dimension in SAP BI?
ANS When we have size of dimension table greater than 20%(SAP Recommendation) of fact table then we should make that dimension table as line item dimension
ANS For local we have option called SELECTION(rt click in rows/columns --> SELECTION)
Q.8 Types of DSO's available in SAP BI 7.X?
ANS There are 3 types of DSO's available in SAP BI 7.X
1.Standard DSO : which contains three table a.) Activation queue table(New data table)
b.)Active data table
c.) Change log table
When ever you load the data initially it get store in New data table,Data in this table not available for reporting
After activation only data move to Active data tale,and data is available for reporting
2.Write optimized DSO: Which contains single table .Data loaded directly to this table no activation need
This is used for when you large set of data use this WDSO before data loading in to cube,standard dso for testing purpose
3.) Direct update DSO: For this no transformation required to load data,which is updated direclty by function module,from datasource.
30/May/2012
Q.7 What is KPI?
ANS KPI means Key performance indication in business organization which show the performance of particular division in organization,
Example : Total work force is one type KPI related HR division in organization which show the employees and their details
29/May/2012
Q.6 What is compounding of info object in SAP BI? Explain briefly?
28/May/2012
Q.5 What are types of info objects available in SAP BI?
ANS. They are five types of info objects available in SAP BI ,
1. Characteristics,
2. Key figures
3.Unit Characteristics,
4. Time Characteristics
5.Technical Characteristics
27/May/2012
Q.4 What is tcode used to allow special characters in SAP BW system?
ANS. T-code:RSKC
26/May/2012
Q.3 What are the traps in SAP BO ? What are the steps to solve traps?
ANS. Generally,In SAP BO we might face 2 types of traps while construction universe on relational database.
They are one Fan trap and second one is Chasm trap
Fan trap occurs when two tables have join 1 to n happens two times simultaneously(Ex:1-->n,1--.n) the we face a fan trap.This can be solved by using alias for last table
Chasm trap occurs when two fact tables connect with single dimension table the Chasm trap occur This can be solved by making context for these fact tables
25/May/2012
Q.2 what is the tool used to transport the universe from dev to prod?
ANS. In SAP BO 3.1 XI R3 it is import wizard the transportation procedure changed in SAP BO 4.0 with LCM(Life cycle management tool)
24/May/2012.
Q.1 What is SAP BI?
ANS:SAP Business intelligence is a approach to integrate the data from different datasources into single data source to make reports for organization help in decision making for their organization by management.
Hope you like this post. Have any question can ask in comments colomns,Correct me if any thing found wrong
Welcome to question of day for SAPBI BO with simple Answer
13/June/2012
13/June/2012
04/June/2012
04/June/2012
04/June/2012
04/June/2012
04/June/2012
04/June/2012
05/June/2012
Q.14 In which scenarios u have used ABAP (ABAP team)?
Ans Basically we can use ABAP Code in multiple scenarios while we are implementing BI project
Here some scenarios I have in used in my recent project
As you know in SAP BI 7.0 Four types routines are supported like
1.)Characterstic routine
2.) Start Routine
3.) end routine
4.) Expert routine
Characteristic routine: Is for simple routine used in project for calculation purpose at transformation level
Example you have 3 info object a.) cost price b.)net price c.) profit
You have to calculate profit info object value (formula: net price- cost price)based on other infoobjects(cost price and net price)
In this scenarios we can use is characteristic routine This can be done at report level also by using calculated key figure or formula.
The difference between Start routine and end routine is start routine perform its operation before trasformations(befor data loading ) end routine performs its operation after transformation(after data loading )
Scenarios for these start routine and end routines are
Start routine you can use in the scenario of while you want to load based on one condition like if sales > 1000 then only load otherwise no for this scenario we can use this routine
End routine we can use in situation we want to delete the records with zero sales value in this case we can use End routine(performs it operation after transformation)
Expert routine is totally different which will use in case of while our transformation not helping. In this case we can go for expert routine .Delete all our transformation and create the expert routine
Need perfect scenario for Expert routine Click Here
For all types routines document Click here
And also we can use these abap in customer exit at reporting level
Scenarios for customer exit if suppose you want to pop up current month and year in variable(default value) then in this case you can use customer exit
Actually here istep functions we are using to generate the current the current month in customer exit
they are four types of isteps function available
istep0,istep1,istep2,istep3
istep0 is for authorization check
istep1 is for populating default value (before variable pop up it operates)(current month)
istep2 is for generation previous month based on current mont or user input(operates after variable popup)
istep3 is validation check and to recall (not sure)
04/June/2012
Q.13 What is aggregate awareness in SAP BO?
Ans Aggregate awareness is one type of option used in universe for
improving the performance of query while retrieving data
Example you have Objects like below in three table
Table 1 year
Year
Sales
Quantity
sold
|
Year
Qtr
Month
Sales
Quantity
sold
|
Year
Qtr
Sales
Quantity
sold
|
Tab1 (year) Tab2(year_qtr) Tab3(year_qtr_mnt)
If you fire a query on year and sales then query don’t where
to fetch the data because year object is available in three table
For this purpose we have to written the aggregate awareness
function for objects in universe
Aggregate awareness for year object is
Rt click on year objectàin
where section write like
@agregate_awareness(year.year,year_qtr.year,year_qtr_mnt.year)
Syntax:@agregate_awareness(table1.column,table2.column,table3,column…….)
Here table 1 is high priority and table n(last table) is low
priority for query to redirect
So if you select year and sales in query the query easily
goes to tab1(year) because as per aggregate awareness you have year tab1 has
high preference so it directly goes to tab1
Like this you have to write aggregate awareness for all
objects
For qtr
@agregate_awareness(year_qtr.qtr,year_qtr_mnt.qtr)
For month
@aggregate awareness(year_qtr_mnt.mnt)
Suppose if you mnt qtr sales objects are using in you query
,Query will directly goes to tab3 because mnt is available in tab3 only and
also as per aggregate awareness function qtr ,mnt available in tab3 only
We can write this aggregate awareness function for measure
objects also
Syntax @aggregate_awareness(sum(table1.column),sum(table2.column),sum(table3.column)……)
For sale
@aggregate_awareness(sum(year.sales),sum(year_qtr.sales),sum(year_qtr_mnt.sales))
qtr,mnt object are not available in tab1(year) so we have to
do aggregate navigation for this
Goto toolsàaggregate
navigationàselect
tab1(year) rt side all object will get disply
Check for qtr,mnt for this tab1(year)
Like this we have do same aggregate navigation function for
mnt also in tab2(year_qtr) because mnt is also not available in tab2(year_qtr)
Some go to toolsà
aggregate navigationà
select tab2(year_qtr) rt side check for mnt
If you do this aggregate navigation for those objects(mnt),if
query using the same object(mnt) then query will not redirect to tab2,tab1 because
we did aggregate_navigation for Query will directly go to tab3 in which mnt
object is available and as per aggregate awareness for mnt it is tab3
Ex:1 query contains year,mnt sales then query will directly
redirect to tab3
Ex:2 query contain qtr,quantity sold then query will directly
redirect to tab2
Ex:3 query contain year,qtr,sales then query will directly
redirect to tab2
All these above 3 example queries retrieving data as per
aggregate awareness and aggregate navigation.
To know more about aggregate awareness Click here
To know more about aggregate awareness Click here
04/June/2012
Q.12 What is line item dimension in SAP BI?
ANS When we have size of dimension table greater than 20%(SAP Recommendation) of fact table then we should make that dimension table as line item dimension
How to know the dimension table size have more than 20% of
fact table:
Using table: SAP _INFOCUBE_DESIGNS
There you will get all the cubes and their dimension table
size So you can easily find which does have high size
Use: By making dimension table as line item dimension then
no dimension table is created for that particular table, SID will take the role
of dimensions table.
Improve the performance by creating SQL quires at database
level instead of at BI side to retrieve data (when you fire a query)
Disadvantage: No possibility of add new characteristic to dimension table
For step by step procedure Click Here
For step by step procedure Click Here
03/June/2012
Q.11 We have RKF in BEX that is global for local what is the option?
02/June/2012
Q.10 If you fire a query on info cube at first to which table that query will redirect? to fact table or dimension table?
ANS Obviously to Dimension table because Dimension table consists of characteristics while fact table consists of key figure,Initially query checks for characteristics and then go to fact table for key figures (making calculations here)
01/June/2012
Q.9 what is the table nams of write optimized DSO?
ANS Actually write optimized DSO consists of only one table which store active data there is no specific name for this table,And also the data in this table available for Reporting,
One thing here in Write optimized DSO no SID are created at time of data loading SID will get generate at time of reporting,It results poor performance.
And also maintain semantic key for data uniqueness,if you perform check on data uniqueness option at DSO properties level
31/May/2012Q.8 Types of DSO's available in SAP BI 7.X?
ANS There are 3 types of DSO's available in SAP BI 7.X
1.Standard DSO : which contains three table a.) Activation queue table(New data table)
b.)Active data table
c.) Change log table
When ever you load the data initially it get store in New data table,Data in this table not available for reporting
After activation only data move to Active data tale,and data is available for reporting
2.Write optimized DSO: Which contains single table .Data loaded directly to this table no activation need
This is used for when you large set of data use this WDSO before data loading in to cube,standard dso for testing purpose
3.) Direct update DSO: For this no transformation required to load data,which is updated direclty by function module,from datasource.
30/May/2012
Q.7 What is KPI?
ANS KPI means Key performance indication in business organization which show the performance of particular division in organization,
Example : Total work force is one type KPI related HR division in organization which show the employees and their details
29/May/2012
Q.6 What is compounding of info object in SAP BI? Explain briefly?
ANS Suppose you have two info object like ZSTORE and ZCITY
ZSTORE infoobject have values like
S1,S2,S3(Store1,store2,store3)
ZCITY infobject have values like Bangalore,Hyderabad,Delhi
Hyderabad has stores s1,s2,s3 ,Bangalore has stores s1,s2……etc
Zstore infoobject definition in incomple with out object
zcity
If you use ZSTORE to show sales in you query no use with that infoobject your
results like might be
S1 100
S2 300
S3 890
By this you do not know the store1, 2,3 belongs to which city.
So here definition of info object (ZSTORE) is incomplete with
out compound info object (ZCITY)
We need to add compound info object (ZCITY) to info object(ZSTORE)
in compounding tab info object(ZSTORE) level
What happened after adding ?
Once you add the compound object to info object ,when ever
you add the object(ZSTORE) to info providers automatically it compound object
zcity also got added to your info provider
Now if you use this object (zstore) in query zcity object
also added automatically because it is compounding info object the results
looks like
Zcity/zstore sales
Bangalore/s1 499
Bangalore/s2 435
Hyderabad/s1 458
Hyderabad/s2 599
S this is meaning full query For this we have to add the compounding
info object
28/May/2012
Q.5 What are types of info objects available in SAP BI?
ANS. They are five types of info objects available in SAP BI ,
1. Characteristics,
2. Key figures
3.Unit Characteristics,
4. Time Characteristics
5.Technical Characteristics
27/May/2012
Q.4 What is tcode used to allow special characters in SAP BW system?
ANS. T-code:RSKC
26/May/2012
Q.3 What are the traps in SAP BO ? What are the steps to solve traps?
ANS. Generally,In SAP BO we might face 2 types of traps while construction universe on relational database.
They are one Fan trap and second one is Chasm trap
Fan trap occurs when two tables have join 1 to n happens two times simultaneously(Ex:1-->n,1--.n) the we face a fan trap.This can be solved by using alias for last table
Chasm trap occurs when two fact tables connect with single dimension table the Chasm trap occur This can be solved by making context for these fact tables
25/May/2012
Q.2 what is the tool used to transport the universe from dev to prod?
ANS. In SAP BO 3.1 XI R3 it is import wizard the transportation procedure changed in SAP BO 4.0 with LCM(Life cycle management tool)
24/May/2012.
Q.1 What is SAP BI?
ANS:SAP Business intelligence is a approach to integrate the data from different datasources into single data source to make reports for organization help in decision making for their organization by management.
Hope you like this post. Have any question can ask in comments colomns,Correct me if any thing found wrong
No comments:
Post a Comment