I have a report where a query named "Query1" is created using the default data items present in the package. When I look into the Tools ---> Show Generated SQL/MDX, IBM Cognos shows 2 generated Native SQL queries for the query named "Query1". How does 2 query get created --- Query1.0 & Query 1.1 ? Under what scenario does this happen? FYI --- The changes that is done in the environment is that a new model is added under a product family at the starting of this month. Could this be the reason why 2 SQL queries has been generated? Can someone explain what happens at the backend?
2 Generated SQL/MDX queries under a SQL query in IBM Cognos
1k Views Asked by user3215886 At
1
There are 1 best solutions below
Related Questions in SQL
- SQL schema for a fill-in-the-blank exercise
- Hibernate: JOIN inheritance question - why the need for two left joins
- What's supposed to be the problem in this query?
- Compare fields in two tables
- How to change woocomerce or full wordpress currency with value from USD to AUD
- Dynamic query creation with Array like implementation
- SQL query to get student enrolled in this month in a course - Moodle
- SQL LAG() function returning 0 for every row despite available previous rows
- Convert C# DateTime.Ticks to Bigquery DateTime Format
- Use row values from another table to select them as columns and establish relations between them (pivot table)
- SQL: Generate combination table based on source and destination column from same table
- how to use system's environnement variables in sql script
- PHP fetchAll on JOIN
- Multitable joining in Sql
- How to display name starting from 'z' by using BETWEEN cmd only?
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 NATIVE-SQL
- Return list type java entity field with jpql or native sql
- Invalid SQL result in INNER JOIN
- How to make native query for nested projection in Spring Data JPA
- ConverterNotFoundException only in Testing time
- Horizontal Rows as Vertical Columns in SQL Server
- How to generate metadata with native SQL // how to retrieve the generated data without column names?
- How do I execute native SQL with tortoise ORM
- Problem Hibernate 5.2.18 with SQLNative and CustomeType
- I am having a hard time joining between unrelated domains in JPA
- How to escape '--' in hibernate createSqlQuery?
- Is it possible for unit test cases for Spring boot data jpa @Query native queries?
- Spring Boot cannot successfully POST data to db (ORA-00942)
- How to access child class entity fields in native query?
- createQuery vs createNativeQuery, performance difference for update/delete statements
- Native SQL + Hibernate Multitenant
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?
Generally, there are two reasons that you will see multiple separate queries in the generated SQL:
In the case of 1 you will end up with a cross join. In the case of 2, Cognos will retrieve the data separately from each source and then stitch them together in memory on the Cognos report server.
There may be other reasons that more than one separate query is shown in generated SQL but these two are the ones I've come across in my work.