Assuming that the Detail Aggregation is Total for Var 1, Var 2, and Var 3, my guess is the one that is working is basically being interpreted as

Var 3 = (total(If (year=2023) THEN (A) ELSE (NULL))/total(If (year=2023) THEN (B) ELSE (NULL))*100
So when you try
Var 3 = If (year=2023) THEN (A/B) ELSE (NULL)it's performing the calculation before aggregating A and B.  And since NULL/B and A/NULL and NULL/NULL all result in NULL, and this is before the values are being aggregated, you will get different results than if you aggregate before calculating.

You can check this by clicking the 3 dots in the top right (next to Properties) and using Show Generated SQL/MDX.  That will enable you to inspect the SQL to see what's really going on.

Quote from: dougp on 05 Mar 2025 11:59:39 AMThat's better, but I'd still need more clarification.

"cats" and "dogs" are not in your list of search terms, but you indicate you want them found.  How would that work?

Does the word need to be the first, last, succeeded by punctuation, or surrounded by spaces?  (...meaning, it's the whole word.)  What if it is found as part of a word?

description keywords People in recovery groups can be dogmatic. dog Cattle can be scatty. cat, cat And are the terms case-sensitive?

Would like to find part of the words. So if the parameter is cat and test, it also finds cats, cattail and test01, test02, testing etc...

It's also necessary in our filter because the input of the text description is not always grammatically correct and therefore we need to filter on multiple parameters in 1 text description field.

It does not have to be case sensitive.

Hello,
  I am trying to create a list report where I need to divide columns A/B (data rolled up from detail for each columns) to get a result across years.

Looking to have
                      DIM 2023   2024   2025
 
                       A      6.2   7.3    5.7

To achieve this, For 2023, I am currently creating 3 variables (query calculation) and is working. Var3 is the result.
   Var 1--If (year=2023) THEN (A) ELSE (NULL)
   Var 2--If (year=2023) THEN (B) ELSE (NULL)
   Var 3--(Var1/Var2)*100

If I try to do these in single variable as below, it is not giving the intended result. Can I know what I am doing incorrect?
    If (year=2023) THEN (A/B) ELSE (NULL)
     I am keeping Detail aggregation as Total.

Thanks,

Hi,
In 11.2.4 FP3, you can create an API key for a user that you want to login with from SDK. This was the purpose of this feature introduction. Save the API key in a password vault (eg: Cyberark ID Vault), and use it to retreive the api key from the vault and login using this key.

That's better, but I'd still need more clarification.

"cats" and "dogs" are not in your list of search terms, but you indicate you want them found.  How would that work?

Does the word need to be the first, last, succeeded by punctuation, or surrounded by spaces?  (...meaning, it's the whole word.)  What if it is found as part of a word?

description	keywords
People in recovery groups can be dogmatic.	dog
Cattle can be scatty.	cat, cat

And are the terms case-sensitive?

Quote from: Bago on 05 Mar 2025 02:53:44 AMGreetings everyone,


I'm currently facing an issue with grouping in Cognos Report Studio. While I've successfully grouped the first two columns to eliminate redundant items, I'm encountering a problem with the remaining columns. Instead of consolidating into a single row, they are resulting in two separate cells.

Specifically, I am working with items that have zero stock. These should be displayed in a single row, indicating "Y" for zero stock and showing the number of days since they've reached zero. My goal is to ensure all relevant columns are presented in one row without any duplicates.


I appreciate any guidance or insights you may have on resolving this issue. Please find the relevant details in the attached file.

Hi,

The issue here is that the first "Zero in" column has both Y and N values for each item. Is this a value being read in from the data source, or is it being calculated (and if so, what is the expression)? As an interim test (to make 100% sure this is the issue), what do you see if you remove that column from the report? From the sample you attached, it looks like the first "Zero in" column is Y when the first "Days Since Out of Stock" column is not null? You could perhaps change the item to use an expression that looks for this?

Cheers!

MF.

I've used the following filters,

1. Filter with values with comma and spaces (example: test, test1, test2, test3)

[DATA COLUMN] in (#csv( split(',', prompt('PROMPTNAME', 'token') ) )#)

2. Filter values without spaces but with comma (example: 01,02,03,test1)

((#sq(prompt(''PROMPTNAME'', 'token', 'testValue'))# <> 'testValue') and [DATA COLUMN] in (#csv( split(',', substitute(' ','', prompt(''PROMPTNAME'', 'token')) ) )#) ) or ((#sq(prompt(''PROMPTNAME'', 'token', 'testValue'))# = 'testValue'))

Hope this helps

Greetings everyone,


I'm currently facing an issue with grouping in Cognos Report Studio. While I've successfully grouped the first two columns to eliminate redundant items, I'm encountering a problem with the remaining columns. Instead of consolidating into a single row, they are resulting in two separate cells.

Specifically, I am working with items that have zero stock. These should be displayed in a single row, indicating "Y" for zero stock and showing the number of days since they've reached zero. My goal is to ensure all relevant columns are presented in one row without any duplicates.


I appreciate any guidance or insights you may have on resolving this issue. Please find the relevant details in the attached file.

Quote from: dougp on 26 Feb 2025 11:42:17 AMI think what you have shown are your two inputs:  The list of keywords for the filter and a sample text description.

Please show the expected outcome.  More sample text descriptions, at least one that contains none of the keywords, would also be helpful to better demonstrate the problem.

It is correct that I want 2 outputs. So one column that has the filtered text description and one column that shows the filtered words.

But I have the problem that the cognos filters do not loop in a text field. The filter searches one word at a time in the text description so you get double results.

Desired output:

Text description column

The test1 module has been tested and shows good results on cats and dogs. The module has been tested and shows good results on fox. Keywords output column test1, cat, dog fox

Doug, I agree with the fundamental points you are making for getting the vendor to accept a standard .CSV output (without any double quotes).
However, what I don't understand is why the following results would occur in Cognos for HTML vs. .CSV output???

Column1  '"' || cast([Data Item1] as varchar(256)) || '" where Data Item1 = a
Column2  '"' || cast([Data Item2] as varchar(256)) || '" where Data Item2 = b

In HTML, output is:
"a", "b"

In .CSV, output is:
"a", """b"""

For the .CSV output, why isn't the double quote wrapping working consistently for the first column vs. all subsequent columns?
It doesn't even matter what the data type is - character, numeric, date - I always get the same formatted set of results. First column single double-quotes, subsequent columns triple double-quotes.
If it is a matter of wrapping double quotes in additional double quotes, why isn't it doing it gor the first column?

It just doesn't make sense to me, but again I could be misunderstanding something!

Adam.