Wednesday, September 17, 2014

Two quick answers on RPD design: Foreign Keys

Why must line must be drawn from fact to dim in physical diagram join?

  When you create the join between the two tables, the table at the start point of the drawn line will be where the foreign key object will be created that describes the reference from the fact to the dim.  If one does not already exist, a key object will also be created on the join column(s) on the table at the end point of the drawn line (the dimension). So foreign key on fact, key on dimension as would be expected in a 1:M join.


Why should you uncheck foreign keys when importing tables?

The only references I could find to unchecking this box during import suggested that including the foreign keys might make the import take longer.    If the foreign keys are imported, it would still be a good idea to review all join conditions between the tables after importing.

Thursday, September 11, 2014

Error when attempting to schedule an agent that has a calculation in an IS PROMPTED filter

When attempting to schedule an agent for an analysis that has IS PROMPTED filters, an error occurs if any of the filters are based on a calculation (for example, a case statement).  
You will need to save a copy of the analysis without those calculated filters in order to schedule the agent.



OBIEE Favorites Menu privileges

Came across this issue today.   Users with only BI Consumer application role were unable to see the Favorites link on their dashboards even though the privilege had been granted to BI Consumer on the Home and Header->Favorites Menu option on the Manage Privileges page in OBIEE.

The reason?  Because they also needed to have the Personal Storage (My Folders and My Dashboard) privilege granted as well under the Catalog section as well.   In this case, that privilege had only been granted to BI Authors.