Search results for query: *

Are you installing on a server? This is probably too obvious, but can you connect to the database from the server using SQL*Plus? Do you have the new database defined in the tnsnames.ora on the server?

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...

You can return more than one column in your child tabular model. If you need to use more than one returned value from the child query in your 'filter,' you would just need need to add the second field to the filter in the parent tabular model: [LOGIN]=[Child Tabular Model].[LOGIN] and...

You can't put SQL in the filter in your query. However, you could add another tabular model or a tabular SQL as a child under your existing tabular model. Have the model or SQL return the list of logins, then in your parent tabular model, add a filter that sets the login in the parent model...

Can you add the user_permission table to your model, and add a filter for permission_type = 'supplier'?

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...

Thanks JGirl, that is what I ended up doing. There is a required prompt that filters to one record. I was just looking for a better solution, as formatting the table is a pain! FYI, in 1.1 MR2, you can no longer associated a query to a page. So beware! I had to put the table inside a list...

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

FYI, Two things were wrong. First, we had CRN set up to use ISAPI, and PPES to the defaults. So in Configuration Manager, Server Configuration, I changed the Gateway URL's to use the alternate gateways for ISAPI. Second, I changed the Gateways to use the fully qualified name, i.e...

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...

After NINE business days trying to figure this out, we finally have CRN 1.1 MR1 running. Our issue was that MR1 would not connect to the Content Store database. We would get a 'Dispatcher still initializing' error at the URL, and the error ' DPR-CMI-4007 An request to perform an active content...

I'm currently trying to upgrade from 1.1.230.2 to 1.1MR1 in our development environment, and I am experiencing the same error. I am trying to upgrade the existing content store (which still works with the old version and should have the correct characterset), and used the old crnstartup.xml(so...

I did eventually get this crosstab to work as I wanted. What I did was this... -- For the columns that were totals, I changed the aggregate function to 'Automatic'. -- For the calculated percentage columns, I made the aggregate function 'Calculated' and changed the calculations to...

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...

This isn't my area of expertise, so not sure this will make sense, but... We had some issues when switching to a new AD domain. One issue had something to do with the pdc emulator fsmo role. I asked my Network Admin for more info, I'll post it when (if) he gets back to me. The other issue...

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...

flex13 is right, you want to include column3 in the query and sort by it, but do not include it in the list. I haven't found a way around the totals moving over when hiding a column. However, I wanted to add a tip that has helped me a lot. Under Tools --> Options, de-select "Delete...

If you want to use the userid from within a ReportNet report, the following session parameters are available in 1.1 (we're on 1.1.230.2, using Access Manager for authentication, there may be more available in later versions or with other LDAP providers): account.defaultName...

Maybe this is too complicated, but the solution that comes to my mind is to have a conditional block in your report. Create a variable based on the first parameter, i.e. if ?parameter1? is null then 1 else 2 If ?parameter1? is null then show the block that does not contain the column. If...

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...