Questions tagged [report-studio]

Tag for questions related to building & modifying reports in Cognos: Report Studio

21 questions
1
vote
1 answer

Cognos UDA-EE-0094 ERROR Operation "greater" is invalid for the following combination of data types

So, in Cognos Report Studio i have a query item with this expression that is getting me an error that i still need to figure out. The expression is this: IF (( current_date - [Submission date]) > 30) then ('Yes') ELSE ('No') And the error is…
1
vote
0 answers

Gaps and Islands analysis in Cognos

Using Cognos Analytics 11.1.7IF9, but asking about Cognos Analytics/Business Intelligence report development in general. Continuation of my SQL question regarding gaps and islands. For performance reasons, I have created SQL code using CTEs and have…
dougp
  • 2,810
  • 1
  • 8
  • 31
1
vote
1 answer

Tab order on prompt page

Using Cognos Analtyics 11.1.7IF9. I have a user who, oddly enough, wants Cognos to make his workflow more efficient. (The nerve!) He thinks that if he can use the TAB button to navigate a prompt page, he'll be faster because he never needs to…
dougp
  • 2,810
  • 1
  • 8
  • 31
1
vote
1 answer

How to display multi select parameter in data item Cognos Analytics

I am using IBM Cognos Analytics 11.0.13. I want to pass a multi select parameter to a data item in a query. When I try to place the parameter in a data item, the multi select feature goes away and I can only make one selection. For example, the end…
laubnerb
  • 21
  • 3
1
vote
3 answers

Cognos 11 Repeater & Export to Excel Data

I am using cognos 11.1.3 and I am using a repeater within a list. The "repeated" column is using a master-detail relationship. However, I could export the report to Excel with the repeater created. Unfortunately, the repeater will be disappeared…
Willie S
  • 73
  • 6
1
vote
0 answers

compute a division using list summary field in cognos report studio

I have a Cognos Report created by a List. I used the Total function the report has to create a row of Totals, i.e. Total [TodayOrderCount] and Total [#ShipmentDaysOrder]. I then need to compute a division: Total [#ShipmentDaysOrder]/Total…
Liliana
  • 11
  • 1
1
vote
2 answers

Cognos report studio - Text Prompt

I'm running a report where I'd like to populate the text box prompt with data run from a local query. How do I populate that prompt with a query that gets, let's say, the latest Value that changes daily in the local query? I'm spoiled by this being…
1
vote
1 answer

COGNOS 11.1.3 - Drop down prompt disable parameter name and dotted line

I have a question about value prompt in Cognos 11.1.3. I have a required value prompt with selected drop down UI. Prompt is using static choices. The problem is that in Cognos 11.0.3 we disabled showing of parameter name and dotted line in UI by…
3georgo3
  • 95
  • 1
  • 14
0
votes
0 answers

In Global Handler when i use SystemException in If condition then why SelectorNotFoundException not falling in Systemexception

Code ImageQuery 2 Image Query 1- I have used GlobalHandler.xaml file in my project and in GlobalHandler.xaml file i have mentioned condition in if statement like - errorInfo.Exception.GetType().Name.ToString.Contains("SystemException") then {Do…
0
votes
1 answer

Add data to a value prompt using javascript in Cognos 11

I would like to know if we can add data in a value prompts using java script? The data doesn't come from any query subject, but hard-coded in java script? For example, I have a value prompt named 'country'. And if I want a display value: 'US' and…
0
votes
1 answer

Report Studio 10.2.2: Showing distinct values in value prompt

Good afternoon, I'm busy making reports in Cognos Report Studio 10.2.2 and as part of this, I need to group a number of accounts based on a group designation, so I can report on all records where the accounts from these groups are mentioned. I've…
Fengshen
  • 1
  • 2
0
votes
1 answer

COGNOS 10.2: Auto-Submit only works by running the report out of report studio

Hello i am facing following problem. I am have an report with a prompt page that contains three dates prompts. For each of these prompts I have added a JavaScript-Element so that a specific value is always selected. For this i have used following…
Kre
  • 69
  • 12
0
votes
1 answer

Change the time period after selection of date prompt

I have a promt page in Cognos where you can select "start_date" and "end_date". Now I would like to use the following: If the first day of a year is selected as "start_date" for example 01.01.2018/2019/2020 then it should use 01.12.2017/2018/2019…
Kre
  • 69
  • 12
0
votes
1 answer

Cognos : create custom groups in report studio

I am new to Cognos and I know SQL but it seems I can’t figure out cognos logic for some basic stuff. It's been two days I am trying and I have been looking all over the internet without finding anything. Here’s the problem. I have a Dimension…
Mara S
  • 13
  • 2
0
votes
1 answer

FOR fuction causing comatibilaty issues looking for alternate of FOR fuction

I am using DQM package in Cognos 11 report Studio. I have two queries which are joined to make a third query. In third query I am using filter condition as [Cardex].[Transaction Date] = maximum( [Cardex].[Transaction Date] for [Cardex].[Lot/Serial…
Pushp Sharma
  • 11
  • 1
  • 3
1
2