What are the different types of Strategies?

In Designer we can specify two types of strategies:

1) Built-in strategies and

2) External strategies

Built-in Strategies: Designer provides a number of default strategies which we can use. These are strategies for extracting joins, detecting cardinalities, and creating default classes and objects. Options for indicating default strategies are located in the Database tab of the Options dialog box.

External Strategies: We can also create our own strategies. Such strategies are referred to as external strategies. With an external strategy, we can specify the exact way that objects and joins are to be extracted from the database structure. The strategy we use, for example, can be a script generated from a CASE Access tool. An external strategy is specific to one RDBMS.

How do you specify external strategies?

With an external strategy, you can specify the exact way that objects and joins are to be extracted from the database structure. All external strategies are contained within the same text file. The name of this text file is indicated in the .prm file specific to your RDBMS. In the .prm file, the strategy file is declared as follows:

STG=[StrategyFileName] where StrategyFileName is the name of the strategy file.

An external strategy, whether for objects or for joins, is made up of the following sections:

a name and description (These are visible in the Strategies tab of the Universe Parameters dialog box.)
a type parameter: object or join
an SQL parameter or file parameter
an optional parameter that points to a connection other than the universe connection.

An external strategy can be based on SQL or a file.

I have Customer dimension table and a fact table with cust_to_ship_key and cust_to_bill_key. How do I get the corresponding customer names?

Create an Alias table for Customer dimension table. Join the cust_to_ship_key with a customer key of Actual customer table and join the cust_to_bill_key with customer key of the Alias.


What are strategies?

A strategy is a script that automatically extracts structural information from a database or flat file.

What is the typical strategy employed in developing/maintaining/distributing Universes?


Phase 1: Break down the informational system into functional areas.

Phase 2: Analyze the information needs of users.

Phase 3: Design a conceptual schema

Design the specification of the user.

Phase 4: Create a Universe with designer.

Test the Universe with the Business Objects module.

Distribute the Universe.

Repeat the other steps for other Universes.

Phase 5: Update and maintain the Universe.

Notify end users of changes.

What is Incompatibility?

The set of incompatible objects you specify determines which aggregate tables are disregarded during the generation of SQL. With respect to an aggregate table, an object is either compatible or incompatible.


The rules for compatibility are as follows:

When an object is at the same or higher level of aggregation as the table, it is compatible with the table.

When an object is at a lower level of aggregation than the table (or if it is not at all related to the table), it is incompatible with the table.

Can a Universe have more than 1 fact Table?

Yes. Typically a universe can have more than 1 fact table and numerous aggregated tables.


What is Aggregate Awareness?

Aggregate awareness is a feature of DESIGNER that makes use of aggregate tables in a database. These are tables that contain pre-calculated data. The purpose of these tables is to enhance the performance of SQL transactions; they are thus used to speed up the execution of queries.

Of course, the reliability of the technique depends on the accuracy of the aggregate tables. In fact, they must be refreshed at the same time as all fact tables. A universe that is “aggregate aware” has one or more aggregate objects with alternative definitions based on these tables. These definitions correspond to levels of aggregation. For example, a Profit object can be aggregated by month, by

quarter, or by year. Queries built from such a universe return information aggregated to the appropriate level at optimal speed.

Aggregate awareness is a feature that makes use of predefined aggregate tables to enhance the performance of SQL transactions. It is used to improve the speed by which aggregates are calculated in the database.

To set up aggregate awareness in a universe, you define one or more objects using the @Aggregate_Aware function.


The syntax for this function is as follows:

@Aggregate_Aware(aggregate_table_1, ... aggregate_table_n)

The arguments of this function are all the names of alternative aggregate tables. When you formulate the syntax, you should be aware of the order of the arguments. The precedence is from left to right; this means that BusinessObjects determines the aggregate to use beginning from the leftmost argument.

As a general rule, you should enter the most aggregate table as the first argument, the next most aggregate table as the second argument, and so on. You must then use the Aggregate Navigation editor to set up a list of incompatible objects and/or incompatible conditions for each aggregate table in your universe.

These are the components that cannot be used with an aggregate table. You can either set up these lists manually, or cause the list of objects to be detected by Designer.

What is a Hierarchy?

Groups of related dimension objects are referred to as dimension hierarchies.

An example of a dimension hierarchy is Geography, which can consist of City, Region, and Country.(Hierarchy is an ordered series of related dimensions, which can be used, in multidimensional analysis)

Good examples of hierarchy are geography and time.

What are objects?

An object is the most refined component in a universe. It maps to data or a derivation of data in the database. Using objects, end users can build queries to generate reports. The name of an object suggests a concept drawn from the terminology of a business or discipline.

For a human resources manager, objects might be Employee Name, Address, Salary, or Bonus, while for a financial analyst, objects might be Profit Margin, Return on Investment, etc.

For the purposes of multidimensional analysis, objects are qualified as one of three types: dimension, detail, or measure.

What are classes?

A class is a logical grouping of objects within a universe. In general, the name of a class reflects a business concept that conveys the category or type of objects.

For example, in a universe pertaining to human resources, one class might be Employees. A class can be further divided into subclasses. In the human resources universe, a subclass of the Employees class could be Personal Information.

As designer, you are free to define hierarchies of classes and subclasses in a model that best reflects the business concepts of your organization.

What is Designer?

Designer is a BusinessObjects IS module used by universe designers to create and maintain universes. Universes are the semantic layer that isolates end users from the technical issues of the database structure.

Universe designers can distribute universes to end users by moving them as files through the file system, or by exporting them to the repository.


What are the components of the Designer interface?

In Designer, you create a universe using three areas: the Universe pane, the Structure pane, the Table Browser. The Universe pane displays the components of the universe from the point of view of BusinessObjects; that is the classes, objects, and conditions.

The Structure pane reflects the underlying database structure of the universe including the tables, columns, and joins. The Table Browser is the component that lets you create the classes and objects of the universe from the tables and columns of a database.

DESIGNER

What is a universe?

Universe provides a semantic layer between you and the database. It consists of classes and objects named in business terms. It is basically a mapping of table and the columns in the database to classes and objects respectively in the query panel.

Alternatively, It is logical mapping of data in business terms.

In the BusinessObjects User module, universes enable end users to build queries from which they can generate and perform analysis. Universes isolate end users from the complexities of the database structure as well as the intricacies of SQL syntax.

What is a database connection?

A connection is a set of parameters that provides access to an RDBMS. These parameters include system information such as the data account, user identification, and the path to the database. Designer provides three types of connections: secured, shared, and personal.

What is a macro?

A macro is a series of commands and functions that are stored in a Visual Basic for Applications module and can be run whenever you need to perform the task. If you perform a task repeatedly, you can automate the task with a macro. You create macros using the Visual Basic Editor.


What is an add-in?

Add-ins are programs that add optional commands and features to BUSINESSOBJECTS. Add-ins are usually created by those responsible in your company for adding customized features to BUSINESSOBJECTS. All you probably need to do is install and uninstall add-ins that are sent to you.

How many modes are there in BO & Designer?

There are 2 types:

1) Enterprise Mode,

2) Workgroup Mode.


What are Enterprise and Workgroup modes?

Designer lets you save universes in either enterprise or workgroup mode. Enterprise mode means that you are working in an environment with a repository. Workgroup mode means that you are working without a repository.

The mode in which you save your universe determines whether other designers are able to access them. By default, a universe is saved in the mode in which you are already working.

For example, if you launched a session in enterprise mode, any universe you save is automatically in that mode.

Frequently Asked Questions

1) What is Universe.

2) How can we create Universe.

3) What are the parameters that we are using at time of Universe Creation.

4) What is Repository.

5) How can we restrict rows in the report in Business Objects.

6) What is .key file.

7) What are Domains.

8) Can we create a report with Data Providers.

9) What are Locks.

10) What is Broad Cast Agent.

11) What is trouble shooting in Broad Cast Agent.

12) What is Adhoc report.

13) What are Loops in Business Objects. How to Use it.

14) Definition of Universe.

15) Explain grouped cross tab.

16) Who launches the Supervisor.

17) How do you write Factorial function in PL/SQL.

18) What is Refrense Cursor.

19) What is Procedure and Function.

20) Who launches the Supervisor.

Frequently Asked Questions

21. What are the differences between a formula, variable and user objects?

22. Did you face any problems while creating reports? Name? Solutions?

23. How do you schedule the reports?

24. How were the reports scheduled and how to resolve unexecuted documents?

25. What is a micro cube? How many can a document have?

26. Have you worked with multiple data sources? If yes. How do you link them?

27. What are templates? Explain what you have created?

28. I have some multi data providers (excel, text, universe). I want only retrieve the data from excel only. How to write the query in query panel?

29. What is slice and dice? What is the use of slice and dice?

30. What is core dimension?

31. How do see the query performance in report?

32. I want to display the last refresh report date and time in the below of the report, how will you do that?

33. While running the query how much time it will taken, I want to see the time?

34. What is Report Bursting?

35. What is the use of alias and context? Which is the better for solving the loops? Why? Why we use alias and why we use context?

36. How to improve the query performance in to report level and designer level?

37. I have 3 tables A, B, C. I connected A to B and B to C. I want to report ABC, is there any loop problem will occur or not?

38. I have 4 tables A, B, C, D. I connected A to B, B to C, C to D and D to A. I want to report ABC, is there any loop problem will occur or not? What is the Problem?

39. How to interactive with Clients?

40. Can u tell me, what is the major problem you faced in your experience? How did you resolve the problem?

41. I have one problem? My Client to told resolve the problem with in 2 hours, but its taken by full day (8 hours). How will u convince the client?

42. How Many Classes and Objects you have in your Universe?

Frequently Asked Questions

1. What is an Universe?

2. How many Universes did you create?

3. Tell me how many classes where there, and objects in each class?

4. What is Object qualification?

5. Tell me about a complicated object you have created?

6. What was the size of the database? Which server?

7. How many user were there?

8. What problems you have faced while creating an universe? tell me
an incident and how you went about solving it?

9. Were any experts called from BO while you were on the project?

10. What was the Database? Was it a data warehouse?

11. How many Tables was the universe built?

12. What is a loop, how do you resolve them?

13. What do prefer an Alias or a context? Why?

14. What is join? Explain different types of joins?

15. What are linked universes? Have you worked with them,
problems faced and solutions?

16. How many reports have you created? Explain a few?

17. What are alerters, filters, breaks, and master-detail?

18. What's the difference between master-detail and Breaks?

19. What's the difference between filters and conditions?

20. What are pre-defined conditions? Compare with report conditions? Justify?