What is SAP B1?
B1 = Business One SAP Business One is an integrated enterprise resource planning (ERP) solution for small and medium ¬sized businesses, as well as divisions and subsidiaries of larger companies.
Can we format BEx reports/graphs using HTML and CSS
Manual says we can do format using HTML and Java Script, not CSS .
Why is there a restriction of 16 Dim tables in an Info Cube and 16 key fields in an ODS?
In all of the database systems there is maximum number of fields allowed to create a primary key (composite key) is 16. An in the case of cube, to fetch a single record a combination of all dimension is used, so this is the reason behind having maximum no. of dimension in cube is 16 only.
Why we have only 16 Dimension tables in a cube. Is there any reason. Is it a limitation?
SAP BI InfoCube Can have maximum 16 Dimension, Why because Cube shape will have only 16 Dimensions and also Normal data base table will have only 16 keyfields. When we create InfoCube system is going to create tables like F¬table and E¬table So,we should follow that database concepts Because of that InfoCube will Have only 16 Dimensions..
Why we are going for customization? Give me a scenario?
For Requirement as per company
Reporting As Per Module
Remove Complexity From End User
Approval procedures can be defined for which of the documents
Sales Order
Goods Receipt
Purchase Order
In SAP Business One, approval procedures setup and implementation is no longer restricted to just sales and procurement documents, it has been extended to include inventory transactions such as goods receipt and goods issue.
Are you Looking SAP Business One Training? Please Enroll for Demo SAP Business one..! |
Explain about item master data?
An inventory item can be changed to non-inventory item and vice versa only when the total quantity of the item is zero and the item has no open document.
SAP Business One has been limited or controlled especially as it affects item master data. This is to enforce control in the management of inventory and non inventory items. For you to effect a change in the status of an item from stock item to non stock item and vice versa, two conditions must be satisfied namely: the total quantity of the item is zero, there are no open documents for that item.
In SAP Business One, a one account is used for Accounts Payable Reserve Invoice, is this statement correct?
Yes, the Account Payable Reserve Invoice is used to create a pro forma invoice. An additional account has been added to allow the posting of accounts payable reserve invoice transactions to a separate allocation account
When is landed cost posted?
Automatically, when you create the document
The landed cost functionality allows companies that import goods to calculate the purchase prices of the imported items including customs, insurance, transport etc. In SAP Business One 2007, landed cost is now posted automatically when you create the document. Landed cost is initially posted as an estimate and you can update it later if you so desire.
As the stock keeper of your company, you want to get a report of items with no transactions in the report period. How will you achieve this?
Run the inventory audit report in SAP Business One, The inventory audit report in SAP Business One allows you to display items with no transaction. You do not need to write any query.
What advantage of ic with aggregates?
If we create aggregates on infocube then query performance
will be improved if our query accessing attributes data
frequently.The sequence when we execute the query is:
1.Query first goes into cache if it finds relevant data in
cache will fetch data otherwise
2. it goes into BI ACCELERATOR(BIA)
3. Aggregates
4. Finally it goes into IC if the data is not available in
above 3 stages.
If we maintain aggregates or BIA olap no needs to come
upto IC. So time will be reduced. Query performance will be
improved.
What are three dimensions provided by SAP?
SAP Given Three different kind dimensions for InfoCube.Those are.
Data Packet Dimension : Which is going to hold the
technical information like request Number etc..
Unit Dimension: This dimension can hold the all Unit
characteristics like Reference Currencies , UNIT’S etc..
Time Dimension : This particular Dimension Can hold the
all time characteristics like 0calday,zdate, start date, end
date etc.
Explain process chain failure notifications?
Create a job at that time when all the process chains have ended. This job will send you a email alert what process chains have errors.
normally
red – failure.
black – start the next process.
What is transfer rules and update rules ?
Transfer rules is simply defined or applied when we map the fields of datasource to the fields of Infosource.
Update rules is applied or used when we map the fields(or infoobjects) of infosource to the subsequent data target.(ODS/CUBE/ INFOOBJECT)
Both the rules is used only to map fileds with some specific advantage of transform properties of infoobjects.
Note : But in BI 7.0 onwards we dont have these concepts of tranfer rules and update rules.
We have only transformations.
What are the common Transport errors in SAP BW?
NOT CORRECT USAGE.
Info Object not available in active version.
Navigational attribute does not exist
Explain the reason and solution for Transport error “Navigational attribute does not exist”?
Reason: If we mark an object in the cube as navigational attribute and navigational attribute does not exist as navigational in the target system.
Solution: Transport the info object with navigational attribute and then re-import this transport.
Explain the reason and solution for Transport error “Info Object not available in active version” ?
We get this error when we try to transport the Info Object Catalogs without transporting the info objects.
Solution: As a prerequisite first transport the info objects then transport info object catalogs.
Explain the reason and solution for Transport error “NOT CORRECT USAGE.”?
When we change the structure of any cube which has Business Warehouse Accelerator Indexes created for it. Change in structure could mean a change as simple as adding a navigational attribute.
solution: Delete the Indexes (BWA Indexes)first then transport and then rebuild the indexes
Are you Looking SAP Business1 Online Training? Please Enroll for Demo SAP Business one..! |
Where do you store the master data in BI 7.0?
Unlike the older version of BW which uses star schema, BI 7.0 uses the extended star schema. In this, master data is stored outside the cube.
In the star schema, both master data and transaction data resides inside the cube bringing many problems: master data not reusable, computing of alphanumeric values and analysis
being limited.
Why we are going for customization?
For Requirement as per company
Reporting As Per Module
Remove Complexity From End User
