Purpose of Query
The SQL query in this page lists the objects id of data functions that present a self merge.
Applicable CAST Version
Release | Yes/No |
|---|---|
| 8.3.x |  |
Applicable RDBMS
RDBMS | Yes/No |
|---|---|
| CSS | |
Query for CSS
SELECT object_id FROM dss_datafunction WHERE object_id = cal_mergeroot_id ORDER BY object_id;
Query result example
7397329
Query result interpretation
The above result return the ID of the data function that present a self merge
In order to fix this "self-merge" you can correct the Data Function's Calibration by running the below query on the analysis service then compute the function points and load results.
Remediation
UPDATE dss_datafunction
SET cal_mergeroot_id = 0,
cal_flags = ( cal_flags - ( cal_flags & 4 ) )
WHERE object_id = cal_mergeroot_id
Notes/comments