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
0
votes
1 answer

Error on converting CQM model to DQM model in Cognos

Ive converted a CQM model to DQM without errors but when I open some (2/10) of the reports - they are giving me an error. The error: "XQE-PLN-0131 The SQL can not be generated because a circular reference is found in the sub-queries" Im not able to…
Ashish B Sathish
  • 121
  • 2
  • 4
  • 16
0
votes
1 answer

Data validation using MotioCI

I am working on doing a POC for automated regression testing of Cognos reports using MotioCI. I have gone through the assertions and it seems only numeric data can be validated. Is there a way to validate string values retrieved in the report…
Ketan Pandey
  • 1
0
votes
1 answer

Creating a chart with Bluemix Embedded Reporting

Using IBM Bluemix I created an app, a Cloudant NoSQL DB, a dashDB and an Embeddable Reporting service. In dashDB I created a table with a couple of columns and some simple data. Next I configured the Embeddable Reporting service and pointed it to…
Kolban
  • 13,794
  • 3
  • 38
  • 60
0
votes
0 answers

Comparing Fields in Cognos BI and Returning Values Where They Don't Match

I am trying to compare the data between two fields in Cognos BI that are coming from two different datasources. So, I ultimately want the dataset in which said fields are distinct, i.e they do not match. The fields are, say "[Query1].[Organization…
Vegeta the Prince of Saiyans
  • 113
  • 9
0
votes
3 answers

Extract year from cognos report expression

I want to extract current year, last year in report expression field but am not able to get it. date2timestamp(Today()) and Today() This works fine to get date _add_years(date2timestamp(Today()),1) and extract("year",Today()) but this shows error. I…
Rohit Chaudhari
  • 757
  • 3
  • 14
  • 33
0
votes
0 answers

Cognos Security at #prompt Token#

I am working on cognos 10.2 and our company had 4 servers located in different places, all the servers are OLTP and have the same schema and tables, which catch transaction data of sales in different locations, Question By using #prompt token # i am…
Anil Reddy Gudipati
  • 1
0
votes
1 answer

Calendar Report in Cognos 10 Report Studio

How to create calendar type report in "cognos" report studio with separate month wise display and also with weekend and holidays highlighted??????????? I already created a report which displays calendar layout, but i'm not able to implement holiday…
Dinesh
  • 31
  • 5
0
votes
1 answer

How to get user ids from Cognos Audit report?

I am able to retrieve the usernames stored in cogipf_userlogon tables but I am not able to retrieve the usernames. Please help me.
Ashish B Sathish
  • 121
  • 2
  • 4
  • 16
0
votes
1 answer

Cognos Report Author and Conditional Style to Hide or Display Columns

I have two columns of the Crosstabs. CAR 1 CAR 2 1 2 0 8 Now, I have it going fine using the Conditional Style Advanced option to NOT To SHOW CAR1 in the resulting Report, if CAR 2 is…
user5586610
0
votes
1 answer

IBM Cognos SDK login with custom authentication provider

I am trying to login to cognos using the SDK but keep getting the following error: AxisFault faultCode: Client faultSubcode: faultString: CM-REQ-4342 An error occurred with the client. faultActor: faultNode: faultDetail: …
user2963623
  • 2,267
  • 1
  • 14
  • 25
0
votes
0 answers

Cognos Report Author 10.2.1 and Drill-thru parameters

I have a unique issue that I need to deal with. I have Multiple Drill-Thru running from Source to Target Report. So, Report A has multiple Drill-Thurs from each Intersection to different Drill-Thru Reports. It was a little tricky but I got it…
user5586610
0
votes
1 answer

CONTAINS inside CASE statement in COGNOS

I am trying to implement a nested CASE in Cognos. Here is my code, case when ?Radio Button for selection? = 'Y' then (substring( cast ([TN_Base_Views].[TktCoupon].[CouponStatusChangeDate], VARCHAR(10) ), 1, 7)) when ?Radio Button for selection?…
Ashish B Sathish
  • 121
  • 2
  • 4
  • 16
0
votes
1 answer

Options in Date Prompt in Cognos Studio

I have a date column in the database. I have got a "Date from" and "Date to" in the prompt page to filter the data. Now, I want to give 3 options to user in the prompt page a) Year over Year b) Quarter over Quarter c) Month over Month Say the user…
Ashish B Sathish
  • 121
  • 2
  • 4
  • 16
0
votes
2 answers

How do I get the name of the month (char) and the Year (date) to appear in my data item and column in Cognos

My Accounting Period Date is using a Numeric data type 1990-01-01 2008-08-01 2008-07-01 So I applied CAST function in the data item. And the results appeared like this. Jan 1, 1990 Aug 1, 2008 Jul 1, 2008 Is there a way to make it appear like…
BongReyes
  • 205
  • 2
  • 7
  • 19
0
votes
1 answer

Cognos: How to show shorten dates in a cross tab in report studio?

I have this report where in cross tabs the column header shows month and year in the format of "September 2014". I want it to show "Sept 2014" instead. Can someone help me with this? The format is actually coming from the database table so me trying…
Rey
  • 13
  • 3
1 2 3
…
23 24