Cognos Analytics

Hi Stephune, I tried the following with the gosales samples database and it works fine. On a report I added the detail filter: rank (random() for [Order Number] ) < 4 [Order Number] is a data item defined as: [C].[C_gosales_8_2_src].[ORDER_DETAILS].[ORDER_NUMBER] ...

Thanks for the response, Philipp, but this does not apply to what is happening here. 10.2.2 Fix Pack 7 has been applied and I am trying to run a report and have the results emailed as an attachment. However, I do not see the " Send the report by email" ...

Hello community, We are trying to create a button that triggers another report. For example: With the "Drill-through definition" functionality this works fine, however, the link is only the text on which the Drill-through definition is defined. ...

Hi Scott, there's an according new capability in 11.1.7: https://www.ibm.com/docs/en/cognos-analytics/11.1.0?topic=access-capabilities#reportnetsecuredfunctionsandfeatures__capability_attach_outputs Since you're using 10.2.2 maybe there exists something ...

Hi all, I'm sure this is not the first time someone has posed this question, so here is my challenge: I was able to use the Random function to get a specific number of Random values. All was good, except, this applies to the entire data set. What the ...

Hi all, I am trying to filter out all rows where a particular column has the value 'No'. I select a cell with 'No' in the column, go up to "Filters", and select "Exclude No." But instead of excluding/removing full rows, some subset of column ...