*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
Release | Yes/No |
|---|---|
| 8.2.x |
|
| 8.1.x |
|
| 8.0.x |
|
| 7.3.x |
|
*Observed on RDBMS
RDBMS | Yes/No |
|---|---|
| Oracle Server |
|
| Microsoft SQL Server |
|
| CSS2 |
|
Details
- Select the pages you are interested in.
- 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
- 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
