What is the difference between obiee 10g and 11g

About Support Center. Trends OBIA 7. By kashif on August 24, Some of the key features include:. Interaction with Other Oracle Products. The following new and revised SQL functions enable you to create time series calculations and level-based measures:.

Enhanced database function usage capability. The Oracle BI Presentation Catalog is a powerful, underlying storage directory-based system that contains the objects dashboards, scorecards, prompts, and KPIs for example that you create. Using the catalog, you can:. In addition to these tasks, administrators can:. Newer Post Older Post. Anonymous 8 October at Kris 11 September at Unknown 11 September at Level keys : Each logical level except the topmost level defined as a Grand Total level must have one or more attributes that compose a level key.

The level key defines the unique elements in each logical level. The dimension table logical key has to be associated with the lowest level of a dimension and has to be the level key for that level.

Time dimensions and chronological keys : You can identify a dimension as a time dimension. At least one level of a time dimension must have a chronological key. The following is a list of some guidelines you should use when setting up and using time dimensions: Unbalanced or ragged hierarchy : A hierarchy in which all the lowest-level members do not have the same depth For example, a site can choose to have data for the current month at the day level, previous months data at the month level, and the previous 5 years data at the quarter level.

For example, a Time hierarchy might have data for the current month at the day level, the previous month's data at the month level, and the previous 5 years' data at the quarter level. This type of hierarchy is also known as an unbalanced hierarchy. Note that unbalanced hierarchies are not necessarily the same as parent-child hierarchies.

Parent-child hierarchies are unbalanced by nature, but level-based hierarchies can be unbalanced also. Skip-level hierarchy : A skip-level hierarchy is a hierarchy where there are members that do not have a value for certain higher levels.

For example, in the United States, the city of Washington in the District of Columbia does not belong to a state. The expectation is that users can still navigate from the country level United States to Washington and below without the need for a state.

Hierarchy with Unbalanced and Skip-Level Characteristics. Parent-Child HierarchiesA parent-child hierarchy is a hierarchy of members that all have the same type. It is a value-based hierarchy Consists of values that define the hierarchy in a parent-child relationship and does not contain named levels. This contrasts with level-based hierarchies, where members of the same type occur only at a single level of the hierarchy.

For example, an Employee hierarchy might have no levels, but instead have names of employees who are managed by other employees. Employees can have titles, such as Vice President.

Vice Presidents might report to other Vice Presidents and different Vice Presidents can be at different depths in the hierarchy. The most common real-life occurrence of a parent-child hierarchy is an organizational reporting hierarchy chart, where the following all apply: Each individual in the organization is an employee. Sign me up. Already have a WordPress. Log in now. Loading Comments Email Required Name Required Website. Post was not sent - check your email addresses! Sorry, your blog cannot share posts by email.

Specify permissions that determine the folders and objects that users can view. Create folders. Work with properties such as changing the ownership of a folder or viewing the creation date of an object. Archive the entire catalog, folders or objects to unzip them in another directory location. Actions: We can create actions that navigate to related content or that invoke operations, functions, or processes in external systems.

We can include actions in analyses, dashboard pages, agents, scorecard objectives, scorecard initiatives and KPIs. Open navigation menu. Close suggestions Search Search. User Settings. Skip carousel. Carousel Previous. Carousel Next. What is Scribd? Uploaded by valladi. Did you find this document useful?