List of Contributions

NIGEL CAMPBELL

Contact Details

My Content

1 to 20 of 50+ total
Posted By NIGEL CAMPBELL Wed March 27, 2024 06:29 PM
Found In Egroup: Cognos Analytics
\ view thread
ISO-SQL defines functions which may not include a window specification. Dynamic Query provides both a built-in implementation of the ISO-SQL regression aggregates (non-Windowed), it will push them to vendor's whose product/version supports them re the equivalent form. Regarding another facet of your ...
Posted By NIGEL CAMPBELL Fri March 15, 2024 08:22 AM
Found In Egroup: Cognos Analytics
\ view thread
The driver is performing an http get via the URL you are providing. If the server can be reached and returns a JSON response, the driver will attempt to infer a schemata (sample). Should it be unable to connect you would see errors similar to figures below. Should it connect and be unable to infer schemata, ...
Posted By NIGEL CAMPBELL Thu March 14, 2024 07:39 AM
Found In Egroup: Cognos Analytics
\ view thread
In my reply the Connection URL was jdbc:ibmcognos:autorest:sample="https://pokeapi.co/api/v2/evolution-chain/1/" In your reply you wrote jdbc:ibmcognos:autorest:sample="pokeapi.co/api/v2/evolution-chain/1/", which is incorrect and would fail. ------------------------------ NIGEL CAMPBELL ----- ...
Posted By NIGEL CAMPBELL Wed March 13, 2024 07:51 PM
Found In Egroup: Cognos Analytics
\ view thread
jdbc:ibmcognos:autorest:sample="https://pokeapi.co/api/v2/evolution-chain/1/" Additional info etc. under https://www.ibm.com/docs/en/cognos-analytics/12.0.0?topic=details-progress-datadirect-autonomous-rest-connections ------------------------------ NIGEL CAMPBELL --------------------------- ...
Posted By NIGEL CAMPBELL Mon March 11, 2024 11:48 PM
Found In Egroup: Cognos Analytics
\ view thread
The discussion around page 78 references an old approach to eliminate branches of expressions. For several years, during query planning Dynamic Query will apply a concept called constant folding. Meaning, where applicable the engine will determine if parts of an expression can be rewritten/simplified. ...
Posted By NIGEL CAMPBELL Mon March 11, 2024 11:36 PM
Found In Egroup: Cognos Analytics
\ view thread
When you are using DQM, you have more choices to control re: explicit, query associated to data container (layout) etc. In-report joins potentially will use re-use where may not be desired. https://www.ibm.com/docs/en/cognos-analytics/12.0.0?topic=mode-dynamic-query-governors. Persons who want to ...
Posted By NIGEL CAMPBELL Mon February 26, 2024 10:14 AM
Found In Egroup: IBM Business Analytics
\ view thread
The second two errors are expected given the ORACLE classes are compiled such that a new JRE is required. CA is using JRE 8 and you would be using using IBM JRE or perhaps ORACLE JRE. That said, when you say 'does not connect' you did not provide any details. Suggest you open a support call if you have ...
Posted By NIGEL CAMPBELL Mon February 26, 2024 07:08 AM
Found In Egroup: IBM Business Analytics
\ view thread
You have put a copy of a JAR file into \drivers compiled for a higher Java version such as Java 11, 17 etc.. See ojdbc8. https://www.oracle.com/database/technologies/appdev/jdbc-downloads.html ------------------------------ NIGEL CAMPBELL ------------------------------
Posted By NIGEL CAMPBELL Wed January 24, 2024 07:38 AM
Found In Egroup: Cognos Analytics
\ view thread
In general, changes to Query engine features (new or changed) are referenced in the what is new section where the changes are first introduced. For example refer to - 12.0.2 re topics related to Singlestore, Datasets etc. https://www.ibm.com/docs/en/cognos-analytics/12.0.0?topic=2024-administration ...
Posted By NIGEL CAMPBELL Tue January 23, 2024 12:33 AM
Found In Egroup: Cognos Analytics
\ view thread
Certainly using macros be very effective at injecting what you "really need" vs SQL-expressions. That said, query engine (DQM) has been able to apply the concept of constant folding during query parsing for several years. For example 10 * 20 could be replaced with the value 200. Similarly, expressions ...
Posted By NIGEL CAMPBELL Fri December 08, 2023 12:23 AM
Found In Egroup: IBM Business Analytics
\ view thread
Have you set the option that causes the W (wide) API calls to the ODBC driver manager to be used re character data? https://www.ibm.com/docs/en/cognos-analytics/12.0.0?topic=connections-odbc-connection-parameters ------------------------------ NIGEL CAMPBELL ------------------------------
Posted By NIGEL CAMPBELL Wed November 01, 2023 11:44 PM
Found In Egroup: Cognos Analytics
\ view thread
Support for CData Connect Cloud (not other CData products) first introduced in 11.2.4 see release notes https://www.ibm.com/docs/en/cognos-analytics/11.2.0?topic=administration-cdata-cloud-connect-support Should you have further questions, please contact Cognos support. ------------- ...
Posted By NIGEL CAMPBELL Mon October 30, 2023 09:23 PM
Found In Egroup: Cognos Analytics
\ view thread
Per Henk and docs. https://www.ibm.com/docs/en/cognos-analytics/12.0.0?topic=mode-creating-summary-query-in-model As you may recollect, persons might define a query subject in FM, go to test it thinking they'd see a grouped-query as in RS. Which is why the auto-summary check box is there in FM. ...
Posted By NIGEL CAMPBELL Mon October 30, 2023 09:15 PM
Found In Egroup: Cognos Analytics
\ view thread
Should a query result in local query compensation/decomposition (meaning the whole query does not push to the database), then you may see files under the \temp\xqe etc folders. The reasons can vary ranging from: - something cannot be pushed to a vendor due to them not supporting an equivalent concept ...
Posted By NIGEL CAMPBELL Thu September 28, 2023 07:28 AM
Found In Egroup: Cognos Analytics
\ view thread
There are products in the market, such as Yugabyte which will state their compatibility relative to PostreSQL. https://docs.yugabyte.com/preview/explore/ysql-language-features/postgresql-compatibility/ In turn, applications would have to connect using the PostgreSQL JDBC driver. This does not ...
Posted By NIGEL CAMPBELL Wed July 26, 2023 09:03 AM
Found In Egroup: Cognos Analytics
\ view thread
With respect to the comment about performance of the driver Google BigQuery distributes. https://cloud.google.com/bigquery/docs/reference/odbc-jdbc-drivers Have you proven outside of Cognos Analytics where the JDBC driver Google distributes causes performance issues? In turn, did you open issues ...
Posted By NIGEL CAMPBELL Wed June 14, 2023 02:40 PM
Found In Egroup: Cognos Analytics
\ view thread
If a procedure assumes to receive several values in a single parameter, then you'd need to use the macro features. See examples in Chapt4 re split/join etc https://www.redbooks.ibm.com/redbooks/pdfs/sg248121.pdf Normally you would set them up in a model and define how the values are passed (prompts ...
Posted By NIGEL CAMPBELL Tue June 06, 2023 06:54 PM
Found In Egroup: Cognos Analytics
\ view thread
It appears your data resides in two locations. One being a local set of data (flat file) and one being a database table. EXCEPT would allow you to returns rows of not found in Given you have data in two locations, that would require CA to retrieve the data from the database to complete the ...
Posted By NIGEL CAMPBELL Wed May 17, 2023 12:27 AM
Found In Egroup: Cognos Analytics
\ view thread
The are not "Is " or "Safe/try cast" built-in functions in the query engine. You can use the regex capability. This basic example returns a non-null string which matches a numeric literal which can include an optional leading sign. This expression can be referenced in another expression ...
Posted By NIGEL CAMPBELL Fri April 28, 2023 07:12 AM
Found In Egroup: IBM Business Analytics
\ view thread
use the _seconds_between expression, which will be generated using an equivalent vendor specific expression. ------------------------------ NIGEL CAMPBELL ------------------------------