Category Archives: OBIEE

Buffer Busy Waits – Reverse Key Index – Demo

We discussed earlier about indexing, and specifically reverse key indexing. I mentioned that is a solution for buffer busy waits on numerical consecutive inserted keys (like the sequence based generated ones) . This post will test that solution. For regular … Continue reading

Posted in DW, Indexing, OBIEE | 1 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

An invalid Username or Password was entered

What is ‘BISystemUser’ OBIEE System User ‘BISystemUser’ “BISystemUser” is an internal OBIEE system user used as an inter-bi-component communication user, this could also be used when Impersonation is used. This is referenced by an Authenticator (usually Default Authenticator unless changed … Continue reading

Posted in OBIEE | Tagged , , | 2 Comments

Undo drills and view prompts

1.    About ‘Undo drills and view prompt values’ message We have the following scenario: A dashboard prompt on column A. A report on this dashboard, which uses column A as a table/pivot table prompt. In some cases, even though … Continue reading

Posted in OBIEE | 15 Comments