Search results for query: *

Does anyone have much experience with bursting reports in ReportNet? I've been playing around with bursting using one query, but the report my end users would like to burst is pretty complex. Thought I would ask for any advice before jumping in to the multiple query report. Does anyone know...

Oops, I meant to make this post a tip, not a question, so I'm posting it again... Just thought I'd post a couple of the issues we've experienced with upgrading to 1.1 MR2. I just got back from being on leave, so I apologize if this is redundant. I've been out of the loop. -- You can no...

Is it possible to display a list "vertically" in CRN? I.e. have the list column titles display on the left? I've tried using a crosstab, but the data I need to display is informational, non-numeric text. I keep getting a #!Error message in the cells for the non-numeric facts. Thanks! Stacy

I published a cube from PPES 7.3 to CRN 1.1 MR1. The cube appears in CRN, but when I try to access it, I get the error 'The request failed because the there is no ticket or passport.' Both CRN and PPES are using the same Active Directory namespace for security. Any suggestions? Thanks in...

I have a crosstab report. When I add summaries to the crosstab, they are all added with one aggregate function, i.e. 'Total'. However, the crosstab contains percentages, which should be calculated rather than totaled. When I try to change the aggregate function of fields in the crosstab, I...

Thought I would post these tips here, after I told a Cognos Help Desk Analyst about them, who had not yet found them. On a report page, if you right-click on a table, text item, or other object, you can select "Go to Query" and it takes you to the corresponding query. Saves time sorting...

Has anyone used a multi-select prompt with a stored procedure data source in Cognos ReportNet? I want to offer a required multi-select prompt, so that the user can select one or more values. Then, in the SP, the SQL would contain a 'WHERE COLUMNNAME in (input_parameter)' clause. Just not...

Has anyone used tabular references in ReportNet? I don't intuitively see how to use these, and there's no instruction in the documentation. How does one use this object? Thanks, Stacy

We're using S7 Access Manager for security in CRN. I want to use users' Basic Signons or OS Signons to limit data queries in ReportNet reports. However, the available session parameters appear to be only account.defaultName, account.personalInfo.givenName, account.personalInfo.surName...

How can I use parameters with custom SQL? I have a query that I want to convert to custom SQL because the generated Cognos SQL runs slow. However, I am passing prompt values to parameters. How do I incorporate the filters in the custom SQL? Thanks, Stacy

How can I pinpoint where performance issues are occurring, i.e. SQL generation vs query vs calculation vs report generation vs download time? I haven't set up loggin in the database -- does it track those items? We're having a problem with remote users (laptop, VPN, etc) having much slower...

Help... Upgraded CRN and FM to 1.1. Opened project, verified model. Saved project and published package. Opened report, report validated. However, when I run the report, and select an item in a prompt that another prompts uses as a source for cascading, I get the following error: QE-DEF-0103...

I'm having problems with existing reports in CRN 1.1. Has anyone else experienced issues like this? This affects multiple reports (which I have no time or desire to create from scratch, they're somewhat complex). Upgraded CRN and FM to 1.1. Opened project, verified model. Saved project and...

I'm about to install this. Has anyone else tried it? Any feedback or problems encountered? Per Cognos, it was created to address specific issues "including" the delay between cascading prompts, which is what we want to check out. Just wondering what other issues might have been...

Does anyone have any ReportNet performance optimization tips? Here's my specific problem. I have a report which I SWEAR was running quickly yesterday. Today, it's a dog. Anyway, the slow query section is designed like this: Query Object Parent Tabular Model (PTM) Child...

I have a list report grouped by Week, Date. However, I am still getting mulitple rows per date rather than a sum. Any thoughts? Thanks, Stacy

How can I create a report title in ReportNet, that does not repeat on each page? There are sections for page header and page footer, but not for a report header and report footer. I have a list that spans several pages. I tried putting the title in a block above the list, but this block...

Hi, I am loading Access Manager with Batch Maintenance. However, I can't see all the users that are loaded via Access Manager - Administration. For example, I load users asmith and abrown via batch maintenance. When I open Access Manager - Administration, I only see abrown in the Users...

Anyone else out there having problem using ReportNet with Directory Services? We are trying to use Active Directory for security for ReportNet. Worked fine in the development environment, but when we moved to production it seemed Cognos couldn't handle the volume of objects. Cognos Support...

What syntax do I need to use in a CSV file to set users' Email addresses via in a macro? I am trying user.EmailAddress = "sarundale@bost.com" but am having problems. Thanks in advance, Stacy