Thursday, June 5, 2008

SAP BI Questionaire : 14

Which of the following objects keeps the aggregate and InfoCube in synchronization?

Read pointer
SID pointers
Surrogate pointer
All of the above

2. Following are required to implement Transitive Attributes.

Infoset
Multiprovider
Aggregates
APD

3. What are the limitations of a Remote-Cube?

System dependent
Only for transaction data
Small volume
All of the above

Monday, June 2, 2008

SAP BI Questionaire : 13

1. Left outer joins are not possible for InfoCubes?

True
False

2. Which of the following values are not supported for Information Broadcasting?

Daily
Weekly
Monthly
None of the above

3. Can we include KeyFigures as key fields in DSO?

Yes
No

Thursday, May 29, 2008

SAP BI --> Questionaire 12

1. Transaction ODS cannot act as an InforProvider. Hence no Query can be built directly?

True
False

2. Which is true regarding Delete function in BW-BPS?

Delete function will directly delete the data from InfoCube
Delete function is used to remove data from selected Planning Package
Will delete the data from selected requests
None of the above

3. It is recommended that you use InfoCubes, where needed, instead of ODS objects for Line Items?

True
False

Wednesday, May 28, 2008

Tip : 10 things to help you get a good night's sleep

· Have and stick to a regular bedtime and wake up schedule. Try to go to bed and get up about the same time each night and morning.
· Make sure the time that you set for your bedtime, is a time in which you are sleepy.
· Do not go to bed too soon or you may have trouble falling asleep or your sleep may be restless.
· Do not nap. Napping can disrupt normal sleep cycles. Try skipping your nap and see if your regular sleep patterns improve.
· Make your bedroom a "quiet" room. Do not watch television in your bedroom. Use it for sleeping or quiet reading.
· Establish relaxing before-bed routines. Take a bath, drink a glass of warn milk, or do some light reading before bedtime.
· Develop relaxation techniques. Learn yoga, deep breathing, quiet mediation or listen to soft music while trying to fall asleep.
· Avoid troubling news right before bed. Violence in newspapers or on television may bother some people making it difficult to fall asleep. Try reading a book instead.
· Avoid stimulants. Do not use stimulants or drink things that contain caffeine(tea, coffee, cola etc.) 6 hours before bedtime.
· Do not use alcohol or tobacco products close to bedtime. Use of these products may calm you at the time of use, but they can have disrupting effects on your sleep during the night.
· Exercise regularly. Regular activity helps the body and mind healthy, but be sure to avoid vigorous exercise right before bedtime.

Friday, May 23, 2008

SAP BI --> Questionaire 11

1. Which Data Mining modeling technique can be used to establish composite effects in master data?

Association Analysis
ABC Analysis
Decision Trees
Clustering
All of the above

2. Data sources with real-time data acquisition can also be used for standard data transfer

True
False

3. An InfoSource is a quantity of logically related InfoObjects, which stages consolidated and transformed data for updating to data targets

True
False

Thursday, May 22, 2008

SAP BI --> Questionaire 10

1. When you extract transaction data with the LO method, the following update method allows you to write delta records to the update table, and is kept there until the data is read with an update collection run and processed.

Direct Delta
Queued Delta
Unserialised Delta Update
Unserialised Queued update
Unserialised V3 update

2. Once navigation attributes has been defined in the InfoObject definition, it is available for use in all queries where that InfoObject is used.

True
False

3. The type of data (transaction or master) that can be updated and the data targets that can be updated depend on the type of the DataSource

True
False

Wednesday, May 21, 2008

SAP BI --> Questionaire 9

1. Where are properties like time dependency set in SAP BW for both navigation attributes and hierarchies?

In the InfoCube Definition
In the InfoSource Definition
In the InfoObject Definition
In the Query Definition

2. When a result set query is executed, the pre-query results are displayed first and then the result set query results are displayed.

True
False

3. Of the following variable types, which cannot be replacement path processing?

Characteristic
Text
Hierarchy and Hierarchy Node
Formula

Tuesday, May 20, 2008

SAP BI --> Questionaire 8

1. What tables will be created when we activate the LIS structure and Activate Delta update?

S5nnBIWS
S5nnBIW1
S5nnBIW2
All of the Above

2. S_RS_COMP1 enables you to limit access to queries by query owner

True
False

3. A free characteristic which is restricted can affect the whole report even it is not used in drill down.

True
False

Monday, May 19, 2008

What do you think !

What do you think ?

Regardless of your politics and recent history notwithstanding, General Powell has some good points to make:
From the book, “ The Leadership Secrets of Colin Powell" (New York: McGraw-Hill, 2002), By Oren Harari

Lesson 1: "Being responsible sometimes means pissing people off."
Lesson 2: "The day soldiers stop bringing you their problems is theday you have stopped leading them. They have either lost confidence that you can help them or concluded that youdo not care. Either case is a failure of leadership."
Lesson 3: "Don't be buffaloed by experts and elites. Experts oftenpossess more data than judgment. Elites can become so inbred that they produce hemophiliacs who bleed to death as soon as they are nicked by the real world."
Lesson 4: "Don't be afraid to challenge the pros, even in their own backyard."
Lesson 5: "Never neglect details. When everyone's mind is dulled or distracted the leader must be doubly vigilant."
Lesson 6: "You don't know what you can get away with until you try."
Lesson 7: "Keep looking below surface appearances. Don't shrink from doing so (just) because you might not like what you find."
Lesson 8: "Organization doesn't really accomplish anything. Plansdon't accomplish anything, either. Theories of managementdon't much matter. Endeavors succeed or fail because ofthe people involved. Only by attracting the best people will you accomplish great deeds."
Lesson 9: "Fit no stereotypes. Don't chase the latest managementfads.The situation dictates which approach best accomplishes the team's mission."
Lesson 10: "Perpetual optimism is a force multiplier."
Lesson 11: "Powell's Rules for Picking People:” Look for intelligence and judgment, and most critically,a capacity to anticipate, to see around corners. Also look for loyalty, integrity, a high energy drive, a balanced ego, and the drive to get things done.
Lesson 12: "Great leaders are almost always great simplifiers, who can cut through argument, debate and doubt, to offer a solution everybody can understand."
Lesson 13: "Have fun in your command. Don't always run ata breakneck pace. Take leave when you've earned it: Spend time with your families. Corollary: surround yourself with people who take their work seriously, but not themselves, those who work hard and play hard."
Lesson 14: "Command is lonely."
Conclusion: " Leadership is the art of accomplishing more than the science of management possible.”

SAP BI --> Questionaire 7

1. During change run, Is it possible to roll up of aggregates that are not affected by the change run?

Yes
No

2. For Time dependant and language dependant text tables the key fields consist of?

DATUM and LANGU
DATE and LANGU
DATETO and LANGU
A & B

3. Unit Conversion is possible only in BEx Designer?

Yes
No

SAP BI --> Questionaire 7

1. During change run, Is it possible to roll up of aggregates that are not affected by the change run?

Yes
No

2. For Time dependant and language dependant text tables the key fields consist of?

DATUM and LANGU
DATE and LANGU
DATETO and LANGU
A & B

3. Unit Conversion is possible only in BEx Designer?

Yes
No

Wednesday, May 14, 2008

SAP BI --> Questionaire 6

What is the transaction code to examine the structure of an InfoCube?

Listcube
Rsdcube
Rsicube
None of the above
LISTSCHEMA

2. The metadata for a DataSource in SAP BW mirrors the transfer structure.

True
False

3. If the technical field names in the DBMS Tables or views exceed 16 characters, such fields are not available for extraction?

True
False

Monday, May 12, 2008

SAP BI --> Questionaire 5

1. If a characteristic is defined as attribute only, how can it be used for another characteristic

As a Navigational attribute
Navigational & Display attribute
Display Attribute
None of the above

2. Which of the following are data staging tools

DB Connect
ETL Tools
UD Connect
Both A and C
All of the above

3. What is the lowest level of information available in BW?

InfoObjects
Infocubes and InfoObjects
InfoProvider
Datasource

Friday, May 9, 2008

SAP BI --> Questionaire 4

1.What kind of reporting is used in ODS object

a).Multidimensional reporting
b).Detailed reporting
c).Selective reporting
d).Both B and C

2.We cannot make entire Hierarchy time dependent

a).True
b).False

3. Restricted Key Figures in the InfoProvider display are available to

a).All Queries for the InfoProvider
b).Only restricted queries for the InfoProvider
c).Only in the Query for which it is created
d).All Queries for all available InfoProviders

Thursday, May 8, 2008

SAP SD Notes and document flow


Above dataflow will show you how the various types of sales documents are inter-related and how data subsequently flows into shipping and billing documents.

SAP SD Document flow :





Presenting to you the inter-relationship between different documents created in SD cycle.





1.Customer can inquire you on telephone and you may record in the system.


2.Ccustomer next requests a quotation, Create quotation w.r.t the inquiry.


3.Customer later places a Purchase order on the basis of the quotation and you create a sales order with reference to the quotation.


4.Ship the goods and bill the customer.This will generate Outbound delivery document which will be created w.r.t Sales order.


5. After delivery of the goods, the customer claims credit for some damaged goods and you create a free-of-charge delivery with reference to the sales order.





The entire chain of documents – the inquiry, the quotation, the sales order, the delivery, the invoice, and the subsequent delivery free of charge – creates a document flow or history. The flow of data from one document into another reduces manual activity and makes problem resolution easier. Inquiry and quotation management in the Sales Information System help you to plan and control your sales.




Some additional notes :





à Invoice Information can be accessed from table VBRP, the invoice document number is same as billing document number.

VBRP à Billing document line item.
VBRK à Billing document header data. Billing type field = FKART, for invoice = “F2”

Invoice document = Billing details + any discounts + other condition types (related to pricing procedure)

0BIL_QTY à Billing Qty in Base unit
0INV_QTY à Billing Qty in Sales unit

In R/3, go to T-code : VA03, open any sales order --> from menu bar --> go to documents --> select invoice document --> press F1 on the technical field --> find table for that field --> Go to t-code LBWE --> Identify which datasource corresponds to this table --> Set up the communication structure and Activate the data source.

Inquiry(customer) --> Quotation(vendor, company) --> Purchase Order (Customer) --> Sales Order (Vendor, internal) --> based on stock availability Purchase, Procure or Produce --> Shipping (Billing document, Invoice is a type of billing document ) --> Delivery note (It will have final qty delivered to customer), R/3 T/C apply at this point ( SD Pricing procedure )



Document Structure…




Description Numbering Range

Sales Orders 80000000 – 89999999

Billing Document 90000000 – 99999999

Credit Notes 60000000 – 69999999

Customers 800000 – 899999

Materials 2000000 - 2999999




Common Transaction Codes :

Create Sales Order :VA01
Create Credit Memo :VA01
Change Sales Order:VA02
Display Sales Order:VA03
List Sales Order:VA05


Create Billing Doc :VF01
Display Billing Doc:VF03
Cancel Billing Doc:VF11
Print Billing Doc:VF03


Display Customer :XD03
Display Material: MM03
Display Customer Line Items:FBL5


Create Sales Order
1. Use Transaction Code VA01
2. Identify Sales Office
3. Enter Sold-to-party (customer) and purchase order number and date if applicable
4. Enter material, quantity and rate
5. Credit income to account (Internal Order or WBS element)
6. Enter partner (University contact details)
7. Save Sales Order

Create Billing Document
1. Directly after saving the Sales Order, follow the path Sales document> Billing.
2. Save the billing document
Other than as a follow-on function
1. Use Transaction Code VF01
2. The sales order number will default in – check that it is correct
3. Save the Billing document

Print a Billing document immediately
1. Use transaction code VF03
2. Enter the Billing Document number.
3. Follow path Issue Output to > Printer
4. Click on execute twice
5. To preview, follow the path Issue Output to > Screen and click on execute twice to view

Document Flow
1. Use transaction code VA03 (Sales Order/Credit Memo or VF03 (Billing document) or
2. Follow the path Environment > Document Flow
3. Enter the document number
4. Click on the document overview icon

SD – Returns/Refusal Dataflow:

1.Create a sales order (0050001445) with qty: 10 (RV45A-KWMENG) and Order Value: 484.50. (VBAK-Netwr)
2.Create Outbound delivery document(80001537) with delivered qty = 7, (This is created w.r.t sales order )
3.Create P.G.I (Post Goods Issue) with reference to “Outbound delivery”
4.Create Invoice document w.r.t P.G.I, Actual Invoiced Qty = (VBRP-FKIMG) = 7, Header Net Value = VBRK-NETWR = 339, 15 and line item value = VBRP-NETWR (net value of billing line items including all values and discounts).
5.Create Returns/Refusal i.e. Create Sales Order with Order type = ZRC (refusal) or ZRE (Standard Returns).
6.From Menu bar à go to Schedule line à “Confirmed Qty” = 2 = VBEP-BMENG.
7.One Sales Order can have multiple “Outbound deliveries” .Now, How to find sales order and order type from delivery number?
Ans: Answer to this is the following link between VBAP (Sales order line item) and LIPS (delivery line item), i.e. LIPS-VGBEL = VBAP-VBELN and
LIPS-VGPOS = VBAP-POSNR

Wednesday, May 7, 2008

SAP ISU Tables : (Data Model)

Industry Service Utilities : Data model. This is really handy when developing ABAP or BI reports. Once the table and linkages are known, BI datamodel can be easily built.












SAP BI --> Questionaire 3

Time dependant master data in the Query can be selected using

Key Date

2. Only one Info Package can be created for a Data Source for real-time data acquisition

False

3. How do we maintain the delta update in Generic Extraction

Calday
Numeric Pointer
Time Stamp

.......... to be continued

Talkanaut : Talk free from your phone to Gtalk users worldwide !

Here is an interesting article.................

Talkonaut 4.0, native (SIS) Symbian S60 edition released.
26th of February 2008.
Mobile VoIP the way it meant to be. During last 6 months our team had been working on two major improvments to our Talkonaut mobile application: 1. moving Talkonaut application to native Symbian S60 platform, and 2. implementing real VoIP stack that allows Talkonaut users to make voice calls over most data connections your mobile phone might have, such as: GPRS, EDGE, 3G and WIFI. With this new 4th release of Talkonaut we present our achievments in these directions, we believe all they make Talkonaut more consistant, outstanding and break-through mobile VoIP + Chat application ever available.
Features:
Talkonaut 4.0 was entirely rewritten in C/C++ and now runs on Symbian S60 3rd edition based Nokia smart-phones. Moving from Java to native platform allowed to reduce memory usage, improved speed and to add some functionalities that were not previously available for Jave applications, like VoIP, access to file local system (improved file transfer) and interaction with other applications (Web Browser for opening URLs right from chat window).
Using a set of narrow-band Speex codecs and relying on Jingle Audio extension to XMPP protocol (same as implemented in Google Talk), Talkonaut now brings to the world a very powerful combination of IM chat, Presence and VoIP calls made over data connection. Unlike standard SIP stack, that is available on some Nokia smart-phones, Talkonaut is not bound to WIFI only, and can make calls over GPRS, EDGE, 3G or WIFI. Talkonaut does not require to do any VoIP configuration and overcomes all the hassle with SIP settings.
Talkonaut 4.0 allows to make free VoIP calls to Google Talk users, to SIP phones, to MSN, Yahoo, AIM and ICQ voice capable IM clients, as well as to other Talkonaut fellows.
Talkonaut 4.0 allows to receive free calls from SIP phones (or any other VoIP networks), from Google Talk, MSN, Yahoo, AIM and ICQ users.
Talkonaut 4.0 allows to make cheap VoIP calls (check our rates) to any mobile or landline phone number in the world.
Talkonaut 4.0 allows to define any number of SIP accounts and use them to make free or cheap calls over third-party VoIP/SIP carriers. A flexible Dialing Plan feature is helpful for choosing routes to destinations between different carriers.
Talkonaut 4.0 is fully equipped with all the features previously available in J2ME version of Talkonaut 3.0, inherits the same graphical user interface and menu structure.
Talkonaut 4.0 runs on the following sets of Symbian S60 based Nokia smart-phones:
2nd Edition: N70, N72, N90
3rd Edition: 3250, 5500, 5700, 6110, 6120, 6121, 6290, E50, E51, E60, E61, E61i, E62, E65, E70, E90, N71, N73, N75, N76, N77, N80, N81, N81 8GB, N82, N91, N92, N93, N93i, N95, N95 8GB
Talkonaut 4.0 can be downloaded over-the-air using mobile web browser from http://get.talkonaut.com/, or via PC from http://www.talkonaut.com/download.shtml.

Monday, May 5, 2008

SAP BI --> Questionaire 2

1. For a DSO with real-time data acquisition, the data is written to the following table

Active

2. In Query Designer, restrictions on default values apply to entire result set and cannot be changed.

False

Explaination :
In the Query Designer you can define characteristic restrictions to restrict the amount of data. You have two options for restricting the data: characteristic restrictions and default values. If you use characteristic restrictions, you cannot change the values at runtime. If you use default values, you can change the restrictions at runtime.



3. What will happen, if a characteristics with compounding information is added to a Query definition

Compounding characteristics will be added automatically

Explaination : Compounding is done when it is required to define a characteristic uniquely. e.g Cost center & Controlling Area.

.......to be continued

SAP BI --> Questionaire 1

1. Key figures that are set for exception aggregation MIN or MAX in an aggregate cause the aggregates to be completely rebuilt for each change run alignment.

True

2. True statement(s) related to the start routine in the update rules:

All records in the data packet can be accessed
Variables declared in the global area are available for individual routines
Return code greater than 0 will abort the whole packet

3.True about info sources :

One info source can have more than one source system assigned to it
Communication structure is a part of an info source

........to be continued