OBIEE Online Training

OBIEE Online training by ex-Rittman Mead and Oracle trainer.
Contact : naveen@bipracticals.com
Watsapp : +65-82830121
Training will be real time and more hands on.
Number of slots available : 2/5

Saturday, August 25, 2012

BI Publisher in OBIEE 11G

Hey Friends...Iam going to work with BI Publisher in my next project. I am using this post to share the links of important resources in the internet related to BI Publisher. I will be exploring this tool and will be posting more details soon.




See the below link for exploring more on the benefits of BI Publisher.

http://www.oracle.com/technetwork/middleware/bi-publisher/overview/index.html



For getting hands on in BI Publisher see the link below:

http://st-curriculum.oracle.com/obe/fmw/bi/bip/bip11g/gettingstarted/gettingstarted.htm


For steps to be followed to install OBIEE so that you can try out BI Publisher see the link below:

http://pagelock.blogspot.in/2012/06/obiee-11115-installation.html

Wednesday, August 22, 2012

Implicit Fact Column


A User may request a report where it may have only Dimensions and no Fact columns such as No of Customers in an Year or Product Category and Product Description. When these are requested the server may sometimes gets confused as from which fact table should it join to fetch the Data. So it joins to nearest fact table and pulls the data through it. So the result obtained may be different from what user is expecting.

So, to avoid this sort of confusion  We can create in a Dummy Fact table in a Physical Layer and Join all Dimensions to this Fact table in BMM Layer. Then in the Presentation Catalog we assign dummy fact table column as implicit fact column . So, Whenever a report on Dimensions are requested it joins through dummy fact table and fetch data.

New RPD Modeling Features in OBIEE 11g


New Features in OBIEE 11gR1 for Data Modeling
• ID Columns for Descriptive Columns (“Double-columns”)
• Lookup Tables                            
• Support for Ragged, Skip-Level and Parent-Child Hierarchies
• Hierarchical Subject Area Columns
• LTS Priority Ordering
• Repository Passwords
• Deployment of Repository Files using Fusion Middleware Control
  
Lookup Tables: - LOOKUP function introduced with OBIEE 11g allows lookups on logical and physical tables

Useful for several scenarios
·         Pushing currency conversions to separate calculations
·         Accessing columns that cannot use GROUP BY (e.g. CLOB)
·         Avoiding unnecessary outer joins in LTS.
It allows you to define a logical table as being a lookup table and can be accessed via a logical calculation using SPARSE or DENSE lookup.

Ragged and Skip-Level Logical Dimensions
Level based hierarchies may have skip-levels, or ragged hierarchies. Skip levels are when members may not have an immediate parent and Ragged hierarchies are when leaf members are not all at the same level.














Ragged and Skipped Level Hierarchies are present in the underlying tables in the form of   NULL values

LTS PRIORITY GROUP ORDER
A single logical table can have multiple logical table sources defined. Usually, the selection of LTS by the BI Server is straightforward and defined by the context of the query. When multiple aggregate LTS are defined, however which one is chosen id difficult to determine.
OBIEE 11gR1 LTS Priority group order makes this more explicit.
Lower Value = Higher Priority
LTS Priority Group becomes main decider in which LTS to use.

























Let’s consider an example
A logical fact table has two LTS mapped; one detailed level and one aggregate
By default aggregate source is used for aggregate queries.
This behavior will be over-ridden when LTS priority ordering is amended.
Setting it to 1 makes it lower priority than the detail-level LTS



Repository Passwords and Repository Identity Management
Repository files now have a password. They are now encrypted, and compressed. RPD password is all that required to edit RPD offline. BI admin Role is required to edit RPD online.


Thank you

- Naveen