1. How can use the entities from two different objects to perform a single query?
You can create two separate queries using the WebiClient and then use the option to merge these queries. Performing the set functions like UNION, MINUS or INTERSECTION between results of the different queries can also give useful data.
2. What are details objects related to dimensions?
The detail objects are the information that are added onto a dimension. Assume the company name to be a dimension, then the detail objects may include the company address, contact details, status of order etc.
3. Can we have many security domains?
No. All the other types of domains can be multiple, but security domain is always maintained as a single entity.
4. What are the different domains involved in the basic step? What identifies the relationship between these different domains?
There are three types of domains in basic step namely Secure, universe and document domains. The relationship between the various domains is indicated by the domain model.
5. What is a Broad Cast Agent?
The BCA is the one that is used to publish and update the documents at specified intervals of time. The scheduled update and publishing can optionally include the exporting of the document in specific formats and sending to the users involved.
6. What is a universe? What are they used for?
The universe refers to a subset of the relational database. The Universe offers the view of classes and objects over the database, thus simplifying the logics of data access. It offers the metadata information regarding the entire database, thus acting as an intermediate layer of business logic.
7. What is the information contained in the universe file?
The universe file contains the following information regarding the database:
● The connection configuration and other parameters for all the databases involved.
● Information regarding the class->objects relationships as seen in the higher level.
● The data extraction information (for example, the various combinations and joins that are applied to tables before getting the final object as seen by the user).
The file system is used for the storage of the Universe details. This makes it easier for the universe shifting, replacements and report generations.
8. What are the ways in which you can check the integrity and reports?
There are buttons available for the check of the integrity and consistency of the joins, data manipulations etc. This is at the business object level. The check can also be performed at the SQL level and the reports can also be tested by testing the underlying universe it uses.
9. What is analysis in the BO? How is it done?
The Analysis of the data in the object helps us to manage our documents and reports. We can do it in the following ways:
● Drill mode: This is where we can perceive the data at the different dimensions and levels. This is helpful when dealing with a database that is based on few aspects interlinking against the various dimensions.
● The Slice and dice: This is where we analyse the data in the documents and reports and add ways to organize them. We can sort or rank the various documents. We can also create a master report that will have a detailed information on the generation of other reports.
10. How does the use of Aggregate tables improve performance?
The Aggregate tables help us maintain the frequently calculates data readily available in the database in the form of an interlinked column. This table depends on the values and their updates in the various other tables. During report generation of general data access, the calculation and computation time is reduced as it already rendered during updates.
11. What is the use of BO SDK?
The BO SDK allows us to customize the various aspects and interactions between the business objects. This can come in handy when we need additional uses and optimization to be done on the business Objects. The programming languages like .NET/VB/Java can be used and the APIs that are made available in SDK give us more features than what is readily available.
12. How are metrics useful to a process?
The metrics are usually the quantitative results and numbers that we use to determine the operational statistics of a business. By have the parameters rightly measured, the calculation of metrics can lead to analytical data which can give insight into how the specific business process has performed over the specific duration of time. This is essential for the understanding the trend and coming up with adaptable solutions and alterations.
13. Is there any way to limit access to specific rows of a table in Oracle DB?
The Oracle 9 and above has the option for the row-level security. The other versions can also be implemented with row level access permissions by configuring the supervisor accordingly.
14. What are the different types of object qualifiers?
There are 3 different types of object qualifiers:
● Detailed: Which are the objects that give additional information regarding the dimension.
● Measure: These are the quantitative numbers or related information for inferring about the performance and metrics.
● Dimension qualifier: This is the main identifier that gives the reference to certain data set.
15. What are aliases and contexts used for?
The Aliases and contexts are the references to the different tables that we are dealing with the databases. These help us to avoid the circular loops and also in better logical picturing of the data when queries are implemented.
16. What are the various ways by which you get the necessary data out from the entire data?
Obtaining the necessary data from the database can be done by use of the following markers and classification mechanism:
● Alerters: This will give the scope of view to the specific set of data that can have the necessary data.
● Breaks: These are used to group and classify data according to certain parameters.
● Condition and filters: These are the ones that will separate out the data from the entire set. The condition provides the exact requirement and the filters may be a range of different aspects that we expect the data to qualify for.
17. How can you define Linked universes?
The data when is obtained by the combination of accesses from different data providers will have inter-related objects and such universes are called as Linked universes.
18. What are the different joins that are used over the database tables? How are they useful?
The joins refers to the combinatorial values that are obtained by combing the rows and columns from different tables according to specified condition. According to the condition that we specify the joins can be classified as inner join, outer join, right join, left join or full join. These are used when we want the data from multiple tables. For eg, if we are having a customer table with customer information and sales table with sales per customer information, we can join both to get the information regarding sales per area.
19. What is the difference between master-detail and break?
The Breaks just group the different rows in the table according to certain value of data. It does not change the format of the table involved. The Master-detail is the metadata information regarding the data in various tables. The attribute that is defined as the master is the center of operation. In this case the outcome or report is involving the changed format to the table that is involved.
20. What is the difference between the class and an object?
The class is more like a definition of what is grouped for access at the logical level. The object is the run time entity that is created as an instance of the specified class. The class is more abstract specification which is used for just the logical structuring of data and it acts as the template to be used by the application through object instances.
21. What is a category?
The grouping of the entities which can be objects or data sets, according to a specific characteristic or aspect is called a category.
22. What is repository?
The repository is the accumulated information of all the databases and other configurations that are used for each of them. It represents the underlying framework over which the entire database is built over. It is usually installed during the database software installation. Whenever you add or delete a table, the repository information changes accordingly.
23. What is RDBMS?
RDBMS refers to Relational Database Management System. It is the concept of storing the data as tables with each of the different data having a realtionship between them stored in turn as a table. This comes in handy in storing huge chunks of information in a logically interpretable form. Most of the database systems use this relational model based database management techniques for logical and storage simplicity.