Stack Overflow
Stack Overflow

Questions tagged [cognos-bi]

IBM Cognos Business Intelligence is a web-based, integrated business intelligence suite by IBM.

It provides a toolset for reporting, analysis, scorecarding, and monitoring of events and metrics. The software consists of several components to meet the different information requirements in a company.

358 questions
1
vote
2 answers

In Cognos BI, how do I select first/last element of a dropdown parameter to be the default?

I've racked my brain trying to find an easy way to do this and I think I'm going to have to resort to a programmatic solution (if that's even possible). I'm using Cognos BI 8.4 and have a query set up to retrieve all distinct dates from my database…
paxdiablo
  • 854,327
  • 234
  • 1,573
  • 1,953
1
vote
1 answer

Cognos Analytics 11

I'm trying to read logs in Cognos Analytics 11.0.7 and prior there was a logviewerv2 that made reading logs very simple. I read in a form that in version 11.0.6, IBM removed this feature. I was hoping to get confirmation on this, and if there are…
Chris Markel
  • 13
  • 2
1
vote
1 answer

% Modulus Operator in DB2 V.9

I'm new to querying from a DB2 but have a scenario where I need to select vendor payments that are divisible by 5 with no remainder, over 1k, and three or more payments of the identical amount. SELECT T.VendorID, T.Amount, T.Date, ROW_NUMBER () …
BStinson
  • 13
  • 1
  • 3
1
vote
1 answer

How to format crosstab corner in Cognos

I am using crosstab in my report where i wanted to hide crosstab corner (say "Contract count") but when i tried setting box type equals to none, the output overlapping the column fields into the place of crosstab corner. I want rows to be get…
VIRAL_ZONE
  • 43
  • 1
  • 7
1
vote
0 answers

Cognos report number formatting into 1 decimal form

I have two different reports in Cognos. Whereas in both the reports I have the field called "%Target". In the report 1 the field is directly coming from db and in the report 2 the field is formulated. My question is for e.g. if a value is 98.47%…
VIRAL_ZONE
  • 43
  • 1
  • 7
1
vote
2 answers

Accessing TM1 Cognos REST API through C# , when server hosted with Integrated mode 5 (CAMPassport)

I am trying to call the REST API exposed from IBM TM1 Cognos. Using the HttpWebRequest object. Getting the 401 when i tried to pass Authorization header with base64(user:password:namespaceId).
Nandish Hosmane
  • 107
  • 2
  • 18
1
vote
1 answer

Continuous dates in Cognos

I need some suggestion to generate a continuous dates in between a specified selected date range in Cognos. I can create a separate Data item for this but I don't know what to do after that. Looking for a quick help
user9204747
  • 13
  • 2
1
vote
3 answers

Cognos Report Studio (case statement) - Syntax error

I have a case statement in Cognos report studio in which if the date is 1st of the current month of previous year then it should fetch data for last whole month (1 to the last date) data of the previous year. I think it is a syntax error. Below is…
VIRAL_ZONE
  • 43
  • 1
  • 7
1
vote
1 answer

Is it possible to pass parameter in the cognos by SQL?

I am having SQL query as "select * from all_objects where owner = : owner;". Can it be possible to create prompt with this query in cognos 10.2.2.Please suggest me.
lucky
  • 25
  • 1
  • 6
1
vote
1 answer

Unable to fetch data item columns of external SQL query into Data source in congons

I am new to Cognos. I want to create a report in 'Cognos-bi' for the external SQL query, which is having multiple parameters with multiple values. For the "each" parameter I need to use value prompt, which should display each parameter values like a…
lucky
  • 25
  • 1
  • 6
1
vote
1 answer

How do you prevent a Cognos report from allowing you to filter data items that don't exist in the report?

I have a list report, and it pulls from a query subject that contains the following products: a, b, c, d, e. However, the report query contains a filter that filters for a, b, c. Once you execute the report in HTML it displays products a through…
helloworld22
  • 11
  • 3
1
vote
1 answer

Cognos BI Graph Sorting not working

I need to create a graph in cognos bi. My query and everything is ready and working fine. However, when i create the graph it does not sort as i want it to be. I selected month name and the month number in different columns. Put the month name in x…
Son Kur
  • 50
  • 5
1
vote
0 answers

Cognos report column with zero width appearing

I have a Cognos report with a few calculation columns that are necessary not to be hidden otherwise there are alignment problems. The grouping is quite intricate and requires these columns to be there. In order to hide the calculation columns I set…
Dimitris
  • 2,030
  • 3
  • 27
  • 45
1
vote
1 answer

Cognos, How can I track all burst reports and recipients

In Cognos environment there are many reports scheduled to be delivered to user's email id. How can I track all those reports without doing lot's of manual work. Using audit package's Run Jobs and Run Reports I am not able to track reports which are…
RanchiRhino
  • 786
  • 4
  • 21
1
vote
0 answers

Cognos Drill Through Report Issue With Boolean Variable

I'm running a drill though report on multiple pages. Page1 contains the source report. A target report is on Page2. I want the target report page to only render when a specific data item value is selected in the source report. Normally a Boolean…
hheld01
  • 11
  • 1
1 2 3
…
23 24