Dynamic Data security in OBIEE

Here is an interesting scenario that I came across recently. The client has 2 hierarchies based on cost centers, Management and P&L. The business push behind this was that lot of users had dual roles in terms of how they look at expenses. Both the hierarchies had cost center at the lowest level and the [...]

Letting the users pick joins in OBIEE

The users want to define the joins between tables in answers, when doing adhoc queries. These views are used for real-time reporting and were sitting on top of EBS tables. This requirement was driven by the fact that most of these views could be joined in more than 2 ways depending of the business scenario. [...]

Dynamic selection of connection pool / DB user id

Sometimes in data warehouses, there would be more than one user created for the OBIEE application. This makes more sense in Teradata data warehouses. This is mostly done to so that any single user (Data base user id used in the connection pool) doesn’t run out of spool space. Lets say we have three user [...]

Procedure to create a simple Time Dimension Table seed data

Here is how to create a simple time dimesion table and to populate it with seed data. CREATE TABLE “CUBE_DATA”.”W_DAY_D” (    “ROW_WID” NUMBER(10,0), “DAY_DATE” DATE, “YEAR_NUM” NUMBER(10,0), “MONTH_NAME” VARCHAR2(30 BYTE), “MONTH_NUMBER” NUMBER(10,0), “QUARTER_NAME” VARCHAR2(30 BYTE), “QUARTER_NUMBER” NUMBER(10,0), “WEAK_YR” NUMBER(10,0), “WEAK_MTH” NUMBER(10,0), “MONTH_AGO_WID” NUMBER(10,0), “QUARTER_AGO_WID” NUMBER(10,0), “YEAR_AGO_WID” NUMBER(10,0), “FISCAL_YEAR_NUM” NUMBER(10,0), “FISCAL_MONTH_NUMBER” NUMBER(10,0), “FISCAL_QUARTER_NAME” VARCHAR2(30 BYTE), “FISCAL_QUARTER_NUMBER” [...]