Find Answers

Filter Search Results
All Operating Systems:
All Products:

All Solution Types:
Source:
 
Ask a Question
Example: "Database could not be verified"  
Tips | Start Over | Solutions | Alerts | Patches | Defects  
Pages [Next]
  Results
CMS-XML SBM 11+: Creating Query Views for Advanced Reports (SBM Advanced XML Report)
database, and you can write SQL queries that join data from tables outside the SBM
CMS-XML Copy Database fails when database has a solution view or Advanced SQL Queries for Reporting
Processing will now halt. ORA-00942: table or view does not exist Option value changed.
CMS-XML User with Create/Modify Advanced SQL reports can't see the "Advanced SQL" checkbox
User with Create/Modify Advanced SQL reports can't see the " Advanced SQL " checkbox
CMS-XML Preview of Advanced Distribution Report drilldown shows incorrect results when using a search filter
To reproduce: (1) Create an advanced distribution report e.g group rows = owner, group columns = state (2) Add a search filter which will change the results e.g. Project does not contain "Project x"
CMS-XML RLC 6.0: How to see which deployment units have been deployed to an environment, and which Engineers deployed those deployment units (SBM Advanced XML Report)
On the Query tab, change the TS_ENVIRONMENT value to be: { TITLE} Deploy the changes.
CMS-XML RLM 5.1: How to see the Turnover, Component, and Component Versions deployed to a specific environment (SBM Advanced XML Report)
On the Query tab, change the TS_ENVIRONMENT value to be: {TITLE Deploy the changes.
CMS-XML RLC 6.0+: How to see the Release Package associated to a Request (SBM Advanced XML Report)
On the Query tab, change the TS_REQUEST_ID value to be: {_TABLEID }:{_RECORDID Deploy the changes.
CMS-XML RLC: How to see Release Package information from the Manual Task form (SBM Advanced XML Report)
On the Query tab, change the TS_RECORDID value to be: { _RECORDID} Deploy the changes.
CMS-XML Advanced reporting - views to internal tables gives error when try to filter on these values - Error: Request Failed. Please contact your administrator
If you use Advanced Reporting and create a view to system tables e.g.TS_PROJECTS, TS_GROUPS, TS_SELECTIONS then you try to create a Listing Report against this view. If you select in the filter a field to one of the system tables then the values are not populated to be able to select them and if you input a value to search that you know exists then you get "Request Failed. Please contact your administrator!".
CMS-XML Reports: Advanced SQL filters do not work well with Query at Runtime on the same report
If you attempt to use Query at Runtime in a filter, while also setting some Advanced SQL filters on the same report, you may see behaviour similar to that described below. 1. Create two reports with QAR field at Basic conditions and ASQL condition, which could be the following:
Pages [Next]

Welcome kb sso

My Recent Searches

Search Feedback

Are we answering your questions?

Product Demos

Dimensions CM: Working with items, part 1 (demonstration)
This Dimensions CM demonstration shows you how to perform impact analysis to determine which files are affected by specific changes

Additional Assistance

  • Submit a Case Online
  • FAQs