Mario Talavera Writes

- My Development Journal

OBIEE RPD Consistency Error [nQSError: 15019] Table % is functionally dependent upon level % …

leave a comment »

Complete Error:

[nQSError: 15019] Table Calendar is functionally dependent upon level Month, but a more detailed child level has associated columns from that same table or a more detailed table.

error

 


Where It Happens

I encountered this error while trying to create Calendar Hierarchy as shown:

errortofixsix

Reading the table name in question from our error message, we go to the Business Model & Mapping (BMM) and examine the logical Calendar table. 

Why It Happens

Consistency check is complaining about our logical Calendar Table having more than one key in BMM Layer.  This error seems counter intuitive to me as I all these keys depending which aggregation table I would like used depending on granularity desired. 

I am certain my questions will be answered as I continue working on this RPD.

errortofix

Solution

Removing this error (and additional ones for all extra keys in Calendar Table) required removing keys until only lowest key was left.

errortofixfive

To get the sought after

errortofixfour

And allowing us to save our model.

About these ads

Written by Mario Talavera

July 17, 2012 at 8:59 am

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 59 other followers

%d bloggers like this: