Author Archives: idatcu

Oracle: Partition by Range– Example

The following post will walk you trough an exercise of creating a partitioned table, using the range partitioning (with auto define of partition names), populating and testing the partition pruning. Please note I will also post the scripts at each section so … Continue reading

Posted in DW | Tagged , , , , , , , | 1 Comment

Oracle: Partition by List – Example

The following post will walk you trough an exercise of creating a partitioned table, using the list partitioning, populating and testing the partition pruning. Please note I will also post the scripts at the end of the post, so you … Continue reading

Posted in DW | Tagged , , , , , , , | 2 Comments

Slowly Changing Dimensions – explained

Overview In discussing Slowly Changing Dimension, the first thing you must consider is first of all, your attributes type. Base on this, you will have various SCD types or combination of types. Dimension Attribute Types: Type 0: dimension attribute that … Continue reading

Posted in DW | Tagged , , , , , | Leave a comment

OBIEE Security (3) – 11g Dashboard Security

What? Security can be applied also at a more granular object level, and used in customizing the same dashboard for different users groups, by securing sections and tabs. When would you use this?  When you want to have users accessing … Continue reading

Posted in OBIEE | Tagged , , , , | Leave a comment

OBIEE Security (2) – 11g Catalog Objects & Access to Users Folders

What? You would have been into the situation where you were requested to apply security on the OBIEE exposed objects. First level of security that we are going to discuss now is folder level security (this implies granting access to … Continue reading

Posted in OBIEE | Tagged , , , , , , | 4 Comments

OBIEE Security (1) – Users, Groups and Application Roles

Why? As OBIEE is targeted as an enterprise wide solution for reporting, and single point of truth, you might experience the need for securing your content based on your targeted audience. This series of OBIEE Security posts will explain how … Continue reading

Posted in OBIEE | Tagged , , , , | Leave a comment

OBIEE Action link passing Hierarchical Column level

Issue Faced In a summary report we are using a hierarchical column. We now need to link this summary report to a detail report. Challenge is while linking the two, since parameter passing does not support pass of Hierarchical columns. Solution Implementation … Continue reading

Posted in OBIEE | Tagged , , , | Leave a comment