Comments
1. Standard infoobjects are SAP defined and infoobjects those are starts with z are user defined and based on the requirement we have to create to infoobjects starts with z.
2. In the same way user defined cubes are starts with z.
3. Cumulative value change means the value of that kf does not change frequently and non-cumulative means value changes frequently. It means,for ex: The stock value in a godown differs from the start of the day to the end of the day. There is lot of inflow of material and outflow of finished goods or products.
4.When we are creating an infoobject it will show reference ch. it means we are refering another ch io here and changes made to that io will be made here also. But in the case of template, here also we are refering another ch io here but any changes made to that io will not be taken here.
27.Data packet size can maintained in DTP settings.. In Extraction tab
23. When the size of dimenssion table exceed from 20% of fact table size then we made it as High cardinality dimenssion.
22. When your dimension table becomes large (>10% of the fact table) then you can make the dimension a "line-item" dimension.By this only one char can be assigned to the line item dimension . By making the dimension as line item the SID values are directly used and the Dim ID table is not created and thus it provides lesser joins and hence query performance is better.
21.Based on strong entity we are going to create extended star schema
5. Compounding defines superior info object which must be combine to define object. For example when you define cost center then controling area is compounding (superior) object.
24. To stop the process chain for one hour and re ran it from where it was stoped, you have to follow these steps.
1. tcode SM37.
2. Input the job name which is surfix with the day of the week. It is system date and time (GMT). Eg. ‘BW SCHED START-DAILY FRIDAY’ and Execute.
3. Select the job and go to the menu path job => change.
4. Choose start condition.
5. Give the required time for postponed the process and save it.
31 ODS Activation Failed.
31.1 Why does the error occur?
• During data load in ODS, It may happen sometimes that the data gets extracted and loaded
completely, but then at the time of the ODS activation it may fail giving status 9 error.
• Or due to lack of resources, or cause of an existing failed request in the ODS. For Master Data it is
fine if we have an existing failed request.
• This happens as there are Roll back Segment errors in Oracle Database and gives an error ORA-
00060. When activation of data takes place data is read in Active data table and then either Inserted
or Updated. While doing this there are system dead locks and Oracle is unable to extend the extents.
31.2 What happens when this error occur?
• The exact error message would be like “Request REQU_3ZGI6LEA5MSAHIROA4QUTCOP8, data
package 000012 incorrect with status 9 in RSODSACTREQ”. Some times it may accompany with
“Communication error (RFC call) occurred” error. It is actually due to some system error.
• The message appears in the Job Overview in RSMO, or in “Display Message” option of the Process
in the PC.
• The exact error message is “ODS Activation Failed”.
31.3 What can be the possible actions to be carried out?
• Whenever such error occurs the data is may or may not be completely loaded. It is only while
activation it fails. Hence when we see the details of the job, we can actually see which data package
failed during activation.
• We can once again try to manually Activate the ODS, here do not change the QM status as in
Monitor its green but within the Data Target it red. Once the data is activated QM status turns into
Green .
• For successful activation of the failed request, click on the “Activate” button at the bottom, which will
open another window which will only have the request which is/are not activated. Select the request
and then check the corresponding options on the bottom. And then Click on “Start”
• This will set a background job for activation of the selected request.
• Monitor the load for successful completion, and complete the further loads if any in the Process
Chain.
• In case the above does not work out, we check the size of the Data Package specified in the
InfoPackage. In InfoPackage -> Scheduler -> DataS. Default Data Transfer. Here we can set the size
of the Data Package. Here we need to “reduce” the maximum size of the data package. So that
activation takes place successfully.
• Once the size of the Data Package is reduced we again re trigger the load and reload the complete
data again.
• Before starting the manual activation, it is very important to check if there was an existing failed
“Red” Request. If so make sure you delete the same before starting the manual activation.
• This error is encountered at the first place and then rectified as at that point in time system is not
able to process the activation process via 4 different Parallel processes. This parameter is set in
RSCUSTA2 transaction. Later on the resources are free so the activation completes successfully.
8. Safety Intervals are used in Generic Data Source to make sure that no data records are missed, even if those are not stored in the DB table when the extraction took place. Time stamps got created during extraction and which is in turn used for delta extraction.
1) 0CALDAY => If we setup delta on base of calday we can run delta only once per day that too at the end of the clock to minimize the missing records.
2) Numeric Pointer => This type of delta is suitable only when we are axtracting data from a table which supports only creation of new records, but not change of existing records. Ex: CATSDB(HR time management table)
3) Time Stamp => Using time stamp we can run delta multiple per day but we need to use safety lower limit and safety upper limit with minimum of 5 minutes (300 seconds to be given)
20. Structure determines the sequence & number of keyfigure or charecteristics value in the column and rows of the query.
Very less amount to learn SAP BASIS, SAP Security & SAP BW/BI for all Student’s & Employees, from real time consultant- Bangalore.
Dear Reader,
I have a SAP course materials with all modules screen shots like SAP Basis, SAP Security, SAP ABAP,SAP BI/BW, SAP BO, SAP XI, SAP Portal, SAP HR, SAP FICO, SAP SD,SAP CRM, and many more…………..
In very less amount required materials call me on below no….
I also have above mentioned SAP Video materials of ALL Modules, and Interview questions with answers.
AHAMED
(M) 09036947964.
Dear ALL STUDENT & EMPLOYESS, (B.Tech, BE, MBA, M.sc, B.sc, MCA, BCA, BBM, B.com & others)
It’s good opportunity to learn SAP now the market are booming in SAP every companies are hiring SAP all modules, so don’t waste the time make a bright future in your life learn SAP for future details call me below mentioned mobile no.
Hi, this is ahamed SAP Consultant from Bangalore, if any body wants to learn
SAP Basis & SAP Security with GRC tool
SAP BW/BI
In very less amount contact limited seat only….
I will tech you online classes also, plz let me know the availability of the time so i can start the class for online.
SAP Basis & SAP Security with GRC tool
SAP BW/BI
Contacts to me feel free for further detail on below mentioned mobile no
(M) 09036947964.
I will tech you SAP complete from the Starch.
SAP Basis Complete
SAP/ERP
MY SAP
Business ONE
SAP Basis Complete
SAP BASIS/NetWeaver Introduction
Installation
Client Administration
Transport Management System
Support packs and Add-ons
System Monitoring
CCMS and Performance Tuning
Background Jobs
Spool Administration
Language Installation
Database Administration
OSS Note Application
SAPNET
Kernel Upgrades and also
Solution Manager
any many more....................................
SAP Security Complete
Sap R/3 Security ALL
SAP Security ADUITING_ALL
SAP BI Security 7.0
SAP Portal Security
and many more...........................
I will provide you course materials, course assignment, Interview question with answer, 100% jobs assistance for above SAP BASIS,SAP Security, and SAP BW/BI
Thanks & regards
any body needs training contact me feel free for further details
Ahamed
(M) 09036947964
Hi,
We were a batch of 4members completed sapbi training, but not satisfied with the training.we are looking for a realtime bi consultant who can answer our few questions regarding to realtime projects and we will pay the amount.Please can anyone help us .mail me to meena.leo05@gmail.com
23: High Cardinality : If the dimensions exceeds 10% or less then 20% of the size of the fact table then use high cardinality dimensions. If its exceeds 20% then use line item dimensions