I want to find the data source vendor oracle or sql or DB2 on a query subject definition.How to achieve the same?
Cognos Analytics 11.x - Find database vendor type in a query subject definition
58 Views Asked by adiCool At
1
There are 1 best solutions below
Related Questions in COGNOS
- Should always pull the monday of the week beginning
- Cognos 10 content store database
- Cognos Analytics Upgrade - Replace NOT working with Parameter
- Cognos Audit User: Read-Only to Everything
- Cognos External Report Server process BIBusTKServerMain & BmtMDProviderMain cannot be started
- Cognos Analytics 11 - Decimal length won't exceed 8 decimal places
- legacy studio cognos v12.0
- Using the Cogos Analytics REST API from PowerShell
- Cognos Report not suppressing the prompt coming from unrendered prompt page
- Cognos Report Rendering Issue: Gender Field Visibility Based on Customer ID Count
- Cognos Multipage Bursting
- How to Hide a line in cognos if List does not have any data
- How to programmatically retrieve Cognos Report Metadata 11.1.7 using the Java SDK
- Using IF Then Else with Days Between - Cognos
- IBM cognos analytics 11.1 group_cocat
Related Questions in COGNOS-10
- Should always pull the monday of the week beginning
- Cognos Report not suppressing the prompt coming from unrendered prompt page
- Cognos Report not returning the total of a calculation in the report
- Cognos excel report name not showing based on page break while scheduling why?
- Difficulty displaying a date in a Cognos BI 10.2.2 crosstab node member
- IBM Cognos IF/casewhen + _days_between
- Cognos Analytics 11.x - Find database vendor type in a query subject definition
- Errors in cognos schedule by trigger
- Total value on the x axis using Marimekko widget using IBM Cognos
- How to generate Authentication Token in Cognos Analytics 11.x
- Cognos 10 Row cumulative expression
- Need a help to Run reports without html pagination
- Cognos Analytics Rest Api/Api-docs 404 not found issue
- Cognos 10 Framework manager crashes with 'BMTUI2' error. 'An error is at the origin of this program malfunction. Close the program'
- How to show data label values in Cognos 11
Related Questions in COGNOS-BI
- Should always pull the monday of the week beginning
- Cognos Audit User: Read-Only to Everything
- Cognos External Report Server process BIBusTKServerMain & BmtMDProviderMain cannot be started
- Looking for a few sample XML report files for Cognos 10 or 11
- Cognos Analytics 11 - Decimal length won't exceed 8 decimal places
- Using the Cogos Analytics REST API from PowerShell
- Cognos Report not suppressing the prompt coming from unrendered prompt page
- How to Hide a line in cognos if List does not have any data
- Formatting date - Cognos Report Studio
- Login via URL in IBM Cognos Analytics
- Cognos Report not returning the total of a calculation in the report
- Cognos excel report name not showing based on page break while scheduling why?
- Error: unable to insert an object of type list cell in the selected location
- Invalid Variable After Being Validated (Cognos BI)
- Cognos Calculate Variance between dates
Related Questions in COGNOS-11
- Cognos Report where total of one column is start for another column
- Cognos Analytics 11 - Decimal length won't exceed 8 decimal places
- Using the Cogos Analytics REST API from PowerShell
- Cognos Report not suppressing the prompt coming from unrendered prompt page
- How to create a multi level select stmt on the same table with different variable
- New columns in uploaded excel file not showing in data module
- Cognos samesite attribute to none causing cognos mashup auth url to fail
- Basic chart types missing basic features
- Sorting the categories axis (x-axis) of a Cognos report doesn't seem to work
- Cognos 11.2 data module - custom SQL table from an existing custom SQL table
- Cognos 11 report listing contact phone number
- Cognos Job to send one email with all reports
- why are we getting a Identifier not found '_row_id' in Cognos 11
- Login via URL in IBM Cognos Analytics
- Cognos 11 Reports: I am using a date prompt in a filter and in data items but receive Error QE-DEF-0426
Related Questions in COGNOS-8
- IBM Cognos IF/casewhen + _days_between
- Cognos Analytics 11.x - Find database vendor type in a query subject definition
- Cognos Report Studio: CASE and IF Statements
- Join and max date with null values
- Filter the data in one query based on the result from another query in Cognos
- CognosTM1 Error: Syntax Error on or before Value
- Cognos : create custom groups in report studio
- Applying custom colors to bar charts in Cognos11
- Migrating Reports From Cognos8 to SSRS Report Builder 3
- CASE statement in Report Studio filters
- Congnos Ranking lowest as Rank 1
- Cognos framework join issue
- sqlopenresult' status='-239' / cognos report error
- Cognos Reports are not distributed to al the mail id's
- Need help building a Data Item in Cognos Report Studio
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular # Hahtags
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
You can use the lineage tool if the data sources are named properly. https://www.ibm.com/docs/en/cognos-analytics/11.1.0?topic=vlidi-cognos-analytics-lineage-tool
Alternatively you can create a calculation with a bogus function and examine the error stack. For example an expression of add_spare(current_date) causes the following error:
XQE-DAT-0001 Data source adapter error: com.ibm.db2.jcc.am.SqlSyntaxErrorException: No authorized routine named "ADD_SPARE" of type "FUNCTION" having compatible arguments was found.. SQLCODE=-440, SQLSTATE=42884, DRIVER=3.72.54 RSV-SRV-0042 Trace back:
Which tells you the data source is DB2