I know this is probably simple but how can I group these?

Hey y’all, I’m wanting to use a report to create a dashboard, but when I create a new dashboard I don’t get the option to link the existing report to it. Anyone know if this is even possible?

I'm creating a crosstab from a custom data module which outputs very much like the below example I've put together.

What I'm struggling with is how to calculate a difference of one measure vs the same measure in the preceding member.

Example output

In my example output above, what I'd be looking for in the unpopulated Trend column is the difference between the Extreme Outdoors' profit in Q2 vs Q3, i.e. -2.2

How on earth do I do that?? Really appreciate any help you can provide.

Hey Reddit! I have a report in Cognos that has a page which creates detail pages. I have been trying for the life of me to figure out how to have the names of these pages to be dynamically named for output to Excel. Currently, the names of the tabs are Course Total_2,3,4,5,etc. I am trying to get these tab names to match the COURSE_IDENTIFICATION data item these pages are created for. I have provided pictures to help explain my conundrum. Thank you in advance for your help!

https://preview.redd.it/2oean0z2sdsd1.png?width=783&format=png&auto=webp&s=191049ebe78e41fc83e729bf8295de6ee8586452

https://preview.redd.it/vhzsx1z2sdsd1.png?width=249&format=png&auto=webp&s=b47ac0e980aef16e90800e12c86677228272614c

Hi! ...can you help?!

To simplify, I'll use this example: I currently have a list report, let's say it represents employee's -each department currently is setup for page breaks so it's setup to go the a new page for each department (separate tab exporting to Excel).

I want to add a 2nd list per each page and for it to follow in the same manner, each department is on the same page of the first list, but page break with new department.

Page 1 would be

(List Report) Department 123 (Employee Information for those in department 123)

(List Report) Department 123 (Beneficiaries Information for beneficiaries tied to employees in department 123)

Page 2 would be

(List Report) Department 456 (Employee Information for those in department 456)

(List Report) Department 456 (Beneficiaries Information for beneficiaries tied to employees in department 456)

How do I reference the 2nd list report (Beneficiaries) to stay aligned per page by department per each page. Can you reference a 2nd list to be joined to a first list by keying on a data item? (in this case, by department)

Sorry if a bit confusing, struggling to outline clearly what I'm asking : (

Hi everyone,

We are running burst reports and when I do the Right click on burst report > View Versions > Expand a report version > click on “Delete report version” I get “CM-REQ-4380 You cannot update or delete objects that have not been archived”.

I am logged in as system admin

Can someone please help?

Edit: I was able to resolve the issue by following https://www.ibm.com/support/pages/how-deleteupdate-data-set-report-or-report-version-error-cm-req-4380 . The person that initially did the steps left the xml file in the same folder causing it run into the same error. Removing that file from the folder did the trick. Thanks to everyone that tried to help 🙂.

Hello Guys!

I use TM1 every day and there are reports that I have to refresh three times a day. Has anyone written a macro for this? Can I make a macro that automatically log in Pafe/PAX and updates the report? (For me the hard part is the automatic log in and not the refresh).

Thank you! :)

Hi,

The thing is we have to show all the unapproved time off or leaves in the future. I am facing the issues

The format they are asking us to have is in Decimals. So 1 hour 15 mins will be 1.25. What I have done to achieve that is to extract hours and extract minutes separately and then converting them to Decimal but now the output I am getting the output like 1 or 1.5 or 4.75. I want the output to be consistent as xx.yy format.

case

when([START_TIME_HHMM]=NULL)

then([END_TIME_HHMM]-cast('00:00:00',time))

else([END_TIME_HHMM]-[START_TIME_HHMM])

end

The above one is the logic i used to get the time off calculations

(cast(extract(hour,[Future Leaves].[Duration]),decimal(9,2)))

(cast(extract(minute,[Future Leaves].[Duration]),decimal(9,2)))/60

I have tried casting it but no benefit. I have tried char function but no success. I am getting this is not supported by the cognos even though its a vendor function.

I have made a separate query for leaves which is just if the day is off take time off as 8.00 hors and converted to char(8.00,'.') but the time off is giving issues.

Could anyone let me know what to do here.

NOTE: I want it as an CSV format so there is no hope for Formatting

Apologies if this has been asked before. I’ve searched google and this sub for the answer but couldn’t find it. I receive at least 10 cognos reports a day that somebody else added me to the scheduled email list. Is there anyway to stop receiving these?

Right now I am working on a report where I have case statement for certain paycode.

case

when([Paycode] = 'N')

then(cast('0.000',decimal(9,2)))

when([Paycode] = 'NA')

then(cast('0.000',decimal(9,2)))

when([Paycode] = 'PP')

then(cast('1.000',decimal(9,2)))

when([Paycode] = 'C')

then(cast('1.250',decimal(9,2)))

when([Paycode] = 'O')

then(cast('1.500',decimal(9,2)))

when([Paycode] = 'D')

then(cast('2.000',decimal(9,2)))

else (cast('1.000',decimal(9,2)))

end

When running the report the output is coming as 1 or 1.5 but it should be coming 1.00 or 1.50. I need some help on what I am doing wrong here.

I have tried creating a new data item as using cast to cast 1 as a decimal but no luck.

https://preview.redd.it/k8bhxv46flld1.png?width=136&format=png&auto=webp&s=faa656a7174a40ec3e16dcb02ba9fd7ca49270a9

Have a cognos installation for a vendor's product. No matter what we do it runs extremely slowly. Have tried everything. Was wondering if upgrading the JRE version can help. Any advice would help troubleshooting performance. Have edited cogconfig to the best of my ability with increased memory etc

https://preview.redd.it/m98w7g6xuhkd1.png?width=842&format=png&auto=webp&s=6e2fc561a73beca379925f93ad887065f724beb3

If you know Excel syntax, basically I'm trying to replicate this functionality in Cognos:

=LET(x;10;x^2+2*x)

That would return 120 as expected. My real data and calculations aren't obviously this simple. Instead the x is actually [SOME_OBNOXIOUSLY_LONG_PATH].[HERP_DERP].[Incomprehensible_CorpoAbbreviation_Thingamajig]. So, I'm trying to find a way to make it at least somewhat readable.

In Cognos, I did figure out there is a let command also, but it looks like it only accepts strings, so for example

# let x=5; x+1 #

returns a 51. And I can't find a way to do actual calculations with this. Any ideas how I could achieve what I want?

My data has employee pay data and the effective date of the increase. I know what their current pay is, I need to find what it was previously. (So the max date has the current pay and I need the 2nd max row to find what the pay was before.)

Hello. Hope you all are doing well.

I am creating a dashboard for the survey responses and many of the survey questions have blank values as people did not respond to those questions which are 10 of them. When I am showing them in a bar graph, I see that it shows "(no value)" and I want to replace it with "No Responses" for each and every question where there are blank values. How can I do that?

Have a good one.

Hi, Can anyone help me on getting “Year on Year percentage growth” in cognos. The data has multiple years.

Thanks.

We recently upgraded from Cognos 10 to Congos 11, specifically 11.2.4.

In Framework manager from Cognos 10 if I make a Query Item from a "Date Time" Query Subject, which was in turn created by an Oracle 12 data source of type "Date" I of course get a Query Item of "Date Time". We changed the data type to "Date" by adding a Cast(Query Subject, Date) function to the Query Item and this worked fine in Cognos 10.

In Cognos 11, if I add the Cast(Query Subject, Date) function to my Query Item expression then I get a blank Data Type which we can not alter. This causes the Query Item to not allow filtering because it doesn't know the data type.

In Congos 11 how do I convert a "Date Time" query subject to a simple "Date" data type?

Our project is about to end and we have almost 1000 reports ( Report studio,Analysis Studio, Query Studio) scheduled from Cognos including User created reports.

Obviously we can't manually Disable the schedules of these reports. Is there a scheduler or something similar which if disabled will disable the schedules of all the reports.

Hi I wonder if anyone can help I have an issue trying to do a case statement on a query calculation data item.

My statement is

CASE WHEN CONTAINS ([Make or Buy Code], ‘M’) THEN [MO ID] WHEN CONTAINS ([Make or Buy Code], ‘B’) THEN [PO ID] ELSE ‘N/A’ END

When I try validate the expression I get “fails to load the report specification. QE-DEF-0260 parsing error before or near position: 20 of: “CASE WHEN CONTAINS”

Any help is appreciated

We have created a report with some data columns. The customer wants to hide the header of the report when running as a CSV.

We have tried hiding the column header using properties and Box type as none. The result is working for everything except CSV. Is there any other solution I can try to achieve this. We also don't want to keep the name of the header as blank spaces, that will just keep a row of headers without anything

So, I have a user who want to run a report as a job. I told him how to do that and he added myself and him in 'TO'.

Immediately he ran that Job and I received that output in mail as well in Excel format.

But immediately I received another mail like, 'Send failed: Report Name'.

We were unable to send a message to one or more recipients. Error message: CNC-SDS-0335 Error returned from SMTP server. The error message was : the message could not be sent

Can anyone please let me know, what this means and why it comes

Hello everyone,

We often have several industries selected for our vacancies. If I now have a report on closed vacancies and the Industries column there, I get three rows for a job if the job has three different industries. This duplication makes it difficult to evaluate something later in Excel. So my question is: Is there a way to display all industries in one cell? Or is it possible to create a separate column for each individual industry so that the vacancy does not appear more than once? (I hope the screenshot makes it clearer).

https://preview.redd.it/t28wuqaeb9ed1.png?width=1383&format=png&auto=webp&s=82f21678051494441cf7869476ae1ddee67ca332

https://preview.redd.it/h94p74snb9ed1.png?width=646&format=png&auto=webp&s=03fc5d9e3bf7752c1c94a81dd2e1b4e8e6ac0481

Maybe a expression?

I have interview by CogBee for Cognos, any one has any experience.

I will appreciate any input.

It's taken by human or totally computer(AI) based interview? they ask questions or I have to write code on screen?

Thanks

I have made her a report that has two pages, one with summary totals, the other with details.

The problem is, when viewing that report in HTML format, it's not blatantly obvious that there is another page that you can view.

Is there a way to make it so that either the page names are listed or make a button that says go to the next page?

Would using drill through definitions work here?

Edit:

The report is a Live HTML report. Saved HTML or PDF solutions won't work for this.

When I say "page names are listed" I mean "show a box on the right-hand side of the report displaying the names assigned to all pages of the report"

I am trying to create a filter that will first select the "data column" and then allow me to select a "data response" in that column.

With the current data dropdown and filter options, I can only selection a "data response" in a pre-chosen "data column." If I want to change the "data column" there is no way to do so without changing it in the fields settings.

Does anyone know of a way to do this?

NOTE:

Data column = one of the 32 questions I ask folks to respond to. these are generated in the "sources" panes of Cognos and are columns in my data spreadsheet.

Data response = one of three responses a user could chose for each question that populates the data columns above. This represents a single response to a single question and is cell in my spreadsheet.

We have created a report and when we are running the report in HTML format all the data is coming correct without any issue. But whenever we run the report in CSV format there is a column which just stops giving any data in the output. There is a single page in the report. No variables are defined. The Csv output is having the header of that column but not data in the column.

Any tips on fixing it ?

We will soon upgrade our IBM Cognos environment from 10.2.2 to the latest 12.0.3. One of the things we are looking forward to is more dynamic charts and visuals specifically the speedometer This is the first image depicting one of the limitations in palette color scheme, we prefer that it would be dynamic coloring based on certain logics . In addition to this axis range that takes hardcoded manual. Any hopes that these would be advanced features on Cognos 12.0.3?

 Thank you!

https://preview.redd.it/cmd2oncnvi8d1.png?width=356&format=png&auto=webp&s=2ba12ffc337b651a5d6ffa435f93e4632a2ddd9d

https://preview.redd.it/4fq3nxosvi8d1.png?width=293&format=png&auto=webp&s=fed79b93ab82c2a16c5fc54b2dcceeda8b7d1db1

Would anyone know how to create a prompt parameter. That lets you select the year and the current month/date?

I have created a schedule in IBM Cognos 11.1. The schedule is running fine. No failures no errors nothing. But the issue that I am facing is when I check the run history for the reports. It is showing Report Output as no. What does that mean and how do I solve that one

Please let me know if someone knows something about it