SQL Queries - CAST Knowledge Base - Corruptions - Corruptions on datafunctions

*Purpose

This page consists of all the SQL queries which have to be executed on Knowledge Database that is Analysis Service database related to Data Functions. For instance these queries provide information such as getting the list of Data Functions that present a self merge, etc

*Observed in CAST AIP

ReleaseYes/No
8.2.x✅
8.1.x✅
8.0.x✅
7.3.x✅

*Observed on RDBMS

RDBMSYes/No
Oracle Server✅
Microsoft SQL Server✅
CSS2✅

Details

  1. Select the pages you are interested in.
  2. If you do not find the information you are looking for or solution for your problem, please contact CAST Technical Support

Notes/comments

Related Pages

SQL Queries - CAST Knowledge Base - Corruptions - Corruptions on datafunctions - How to find the DataFunction ID of a merged item without a merge root or when its merge root is not a Data Function

SQL Queries - CAST Knowledge Base - Corruptions - Corruptions on datafunctions - How to find the Datafunction ID which belong to a Tree of merged items

SQL Queries - CAST Knowledge Base - Corruptions - Corruptions on datafunctions - How to find the objects id of Datafunction which is merged with itself

SQL Queries - CAST Knowledge Base - Corruptions - Corruptions on datafunctions - How to list the Datafunction ID being a merge root of a DF but it doesn't have the flag stating it is a merge root

SQL Queries - CAST Knowledge Base - Corruptions - Corruptions on datafunctions - How to list the merged item having more than one merge root