Hello Dale,
I saw your previous post with the title "Invalid coercion from 'member' to 'string'" and concluded that you are using a dimensional package. A so called DMR package.
And if you are new to Cognos this is far more complex than a relational package. So my advice would be to use a relational package if available and you can use the statements in your post.
Or create a dataset from the package with all the data you need for your report and add this to a datamodule and use the datamodule as the source for your report.
But if that all is not possible, then keep in mind that you should only use dimensional functions in a dimensional package.
The second is that you should
not use detail filters in a dimensional model. They are performance killers as you have experienced.
What you could do is:
Remove the detail filter and create several query items:
[Part/Concern] with the definition [Qls Rpr Part - Long Name] + [Qls Rpr Conc - Long Name]
[Concern] with the definition filter ( [Qls Rpr Conc]; [Qls Rpr Conc - Long Name] in ( ?ConcLongname? ) )
[Part] with the definition filter ( [Qls Rpr Part]; [Qls Rpr Part - Long Name] in ( ?PartLongname? ) )
Then add these in the list and run the report. it should be faster.
------------------------------
Thomas van der Meer
------------------------------
Original Message:
Sent: Mon November 23, 2020 02:37 PM
From: Dale Simpson
Subject: Concatenated Fields - Detail Filter Slows Down Report
Hello,
I have a report set up in Cognos Analytics 11.xx. I created a data item that concatenates two other data items, such as below:
[Qls Rpr Part - Long Name] + [Qls Rpr Conc - Long Name] (Named: Part/Concern)
The concatenated field works as needed. However, when trying to use the new field as detail filter, the report slows down to an unusable rate, i.e ~10+minutes.... The detail filter is set using a text box prompt, with the expression written as below:
[Part/Concern] in ?Prompt_Values?
Any idea's why this would be so slow? If I remove one of the fields and set the filter accordingly, it only takes ~1 second to run. Image of resulting report shown below.
Thanks!
------------------------------
Dale Simpson
------------------------------
#CognosAnalyticswithWatson