Looking for field holding the value for BENCHMARK

highpoint · Post by **highpoint** » Mon Jun 27, 2011 1:39 pm

Hi,

I have an existing customized view and would like to enhance it by adding the field "BENCHMARK" value for the rule .

I am have searched the xmeta for the table with names 'BENCH'
i got 3 tables:

INVESTIGATE_XMETAGEN_BENCHMARKCATEGORYEC1481DF
INVESTIGATE_XMETAGEN_BENCHMARKMASTEREC1481DF
INVESTIGATE_XMETAGEN_QUALITYBENCHMARKEC1481DF

The table in bold has a column called "VALIDITYVALUE_XMETA"

Is this the column that holds the BENCHMARK value to pass or fail a rule?

And also how to join this with other tables of my existing view.

Is there a place i can get data model for xmeta?

ray.wurlod · Post by **ray.wurlod** » Mon Jun 27, 2011 3:10 pm

I can only answer your final question. That answer is No. (That probably addresses the other questions as well.)

highpoint · Post by **highpoint** » Mon Jun 27, 2011 3:23 pm

ray.wurlod wrote:I can only answer your final question. That answer is No. (That probably addresses the other questions as well.)

We got this view intially created by a contracting company.

How did they get to join the tables in the view. And view seems to work fine.

There should be some way for us to add an addtional field to this view.
Other than being at the mercy of contracting company.

ray.wurlod · Post by **ray.wurlod** » Mon Jun 27, 2011 3:26 pm

You can perform the same hacks that they performed.

highpoint · Post by **highpoint** » Thu Jun 30, 2011 10:48 am

ray.wurlod wrote:You can perform the same hacks that they performed.

Glad i was able to get the benchmark values from XMETA to the view, so that the DataStage can read it.