If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Recent posts

#1
Report Studio / Re: Subtract minutes from Date...
Last post by Laynlowz - Today at 10:37:30 AM
Nevermind that formula works there was a weird data item that was left in the query that caused this.

Thanks!
#2
Report Studio / Re: Subtract minutes from Date...
Last post by Laynlowz - Today at 09:52:53 AM
this is the error i receive

XQE-GEN-0018 Query Service internal error has occurred, please see the log for details.
CAF-WRN-2082 An error has occurred. Please contact your administrator. The complete error has been logged by CAF with SecureErrorID:2024-06-13-14:31:03.549-#1544
#3
Hi,

We have a new Cognos instance of 11.2.4 version set up and running. I just found that I can only run the existing reports but cannot run newly created reports. When I create a new report by using the New -> Create -> report option and try out a simple list report with a few query items, it keeps on running but does not throw output. Also found that I cannot run tabular data (the same thing happens) of any of the existing report queries.

Please suggest how I can get this resolved.
#4
Report Studio / Re: Subtract minutes from Date...
Last post by bus_pass_man - Yesterday at 04:04:57 PM
Really?  Nothing in the logs?

It works for me.  What's the data type of the column you are using?  Is it possible that there are other variables in play which you have not mentioned?

You cannot view this attachment.

Quotethere is a number of records with different date/times in the database so it would be any date/time record needs to have 12 hours subtracted.
Are.  Not quite sure what you mean.  Also, I'm not sure if what you mean by record is what is commonly understood to be record.

Also the time stamp data type and the 12 hours business makes me think this is related to https://www.cognoise.com/index.php/topic,38131.0.html
#5
Report Studio / Subtract minutes from Date/tim...
Last post by Laynlowz - Yesterday at 03:03:46 PM
How can I subtract minutes from a date/time field?


example is
Jun 4, 2024 12:20:45 AM

I want to subtract 12 hours from this to read
Jun 3, 2024 12:20:45 AM

there is a number of records with different date/times in the database so it would be any date/time record needs to have 12 hours subtracted.

I have tried _add_hours([Performance and Throughput].[Event Summary Header].[Facility - Event Start Date Time] , -12)  but the query just fails after running with no clear indicator of why it fails.
#7
Reporting / Unable to create new reports i...
Last post by mlodugu1 - Yesterday at 12:50:17 AM
Hi,

We have a new cognos instance of 11.2.4 version set up and running. I just found that I can only run the existing reports but cannot create new reports. When I try to create a new report by using the New -> Create -> report option and try out a simple list report with a few query items, it keeps on running but does not throw output. Also found that I cannot run tabular data (the same thing happens) of any of the existing report queries.

Please suggest how I can get this resolved.
#8
Event Studio / Re: Can we replace package in ...
Last post by Ajay - 11 Jun 2024 12:53:38 AM
Yes, it worked.


Thanks
#9
I have a large organizational change coming up, with lots of changes to the user base who I will be creating/running/maintaining reports for. For preparation, I would like to extract the job structure I have built over several years within Cognos into something more... manageable.

Is it actually possible for a user (I am not IT; they have made it clear already that I'll not be getting Motio or any other 3rd party tools) to somehow extract that information? Basically, I'm looking for two types of information:
- "Folder Public\org\bu\team contains jobs A, B, C and D"
- "Job Public\org\bu\team\A is running reports 1, 2, 3, and sending via email to recipient@company.org"

(edit: dammit, chose the wrong board. fwiw, this is in reference to cognos connection on a C10 instance!)
#10
Report Studio / Re: combining data by date tim...
Last post by bus_pass_man - 07 Jun 2024 05:46:39 PM
I think you want to get the count of the number of shifts someone has worked but you launch right into mucking about with casting without actually defining the problem you want to solve. Also I think you have two columns, one of which has the shift start time and the shift end time but that is a guess.  Knowing what you have in the larder helps determine what you can make for dinner and it's somewhat similar here.

Once that is straightened away, policy questions and exception handling for matters such as people only working part of a shift (they get called away to deal with personal matters, they go to the doctor or dentist, they fall down due to exhaustion due to overwork, they get bits of their person caught in a machine because 12 hours is a long time etc.) would then need to be clarified before a reasonably suitable response could be formulated.  For example, it's possible that using an interval would be helpful but without a clearly defined problem there's no way to know that with any degree of certainty.