Recent Posts

Pages: [1] 2 3 ... 10
1
Reporting / Re: Rank Function for Item not in List
« Last post by Reinhard on Today at 02:00:06 pm »
Hi,

mark your list, go into properties > properties and check the box at Salesperson.

Regards
2
Administration and Security / Upgrade from 11.0.9 to 11.0.11
« Last post by cognosjon on Today at 01:33:52 pm »
Evening,

not sure if this is best posted in this or the Dashboard section so apologies.

I've today updated our 11.0.9 environment on Development to 11.0.11, all went well, or so it appeared.
After we have initiated testing we are now seeing that dashboards created in the earlier release (11.0.9) are causing huge problems. Whenever actioned, SQL server consumes upto 98% of the cpu and we have masses of select statements appear against the reporting database many at a suspend state. These statements then don't complete and have to be killed or the SQL instance restarted.

These dashboards have been written against an FM package?

Has anybody else seen anything like this?

I'm currently in the process of trying to recreate a dashboard in the new release to see what happens and then also create a dash using the Cognos samples to then import into 11.0.11 to see what happens.


Thanks
3
Hi all ,
I want to change the data type of the query item in FM but I am unable to  as data type drop down is disabled for that time .Any suggestion why its happening ?

Thanks
4
Report Studio / Re: Concatenate two fields
« Last post by D1234 on Today at 11:49:23 am »
This works perfectly.

Thank you!
5
Report Studio / Re: Concatenate two fields
« Last post by sjdig on Today at 11:08:20 am »
Did you account for the separators as well when determining the length needed?

In my environment, dates are stored as MM/DD/YYYY.

I was able to make concatenation with a date and text field work using the following:

Code: [Select]
cast([Date], varchar(10)) ||' '|| [Field2]
The output does return as YYYY-MM-DD though. If you need it in a certain format, substring may be helpful.
6
Report Studio / Re: Concatenate two fields
« Last post by D1234 on Today at 10:58:46 am »
There is not really any additional information in the detail section of the error. For additional context. One of the fields is a date field and the other is a text field. I tried to make both of them text fields and re-run the new combined field but this returned the same error.
7
Reporting / Rank Function for Item not in List
« Last post by pacificbeavs on Today at 10:20:37 am »
I am trying to display the top sales amounts by salesperson, however I don't want the actual salesperson's name in the list report.  This is a list report in Cognos 11.07.

Let's say we have John (3 million in sales), Jane (2 million in sales), and Joe (1 million in sales). 

If I display the following then it works fine:

Rank   Salesperson    Amount
1           John                3 million
2           Jane                2 million
3            Joe                  1 million

Once I remove the salesperson from the list (but keep it in the query) then it no longer functions properly (it displays rank 1 for 6 million), even after I change rank(amount) to rank(amount for salesperson).  Any thoughts on how to achieve the example above, without displaying the salesperson's name?
8
Report Studio / Re: Concatenate two fields
« Last post by Lynn on Today at 09:56:18 am »
Hi,

When I use the double pipe method I receive this error message

An error occurred while performing operation 'sqlOpenResult' status='-9'.

Thanks

Is there a details link on the page that you can expand to show the details of that message? Often there are further clues in there about the problem.

Also, is your source relational or dimensional (e.g., a cube or DMR)?

If relational, what is the underlying database? SQL Server? Oracle? DB2? Something else?

As sjdig indicated, what are the data types of these two fields you are trying to concatenate?
9
Report Studio / Re: Concatenate two fields
« Last post by sjdig on Today at 09:50:19 am »
Are both the same data type?

You may need to use a cast to support the two being able to concatenate.

For example: [Field1] is an Integer that can be five digits long and [Field2] is a String.

You could do the following:

Code: [Select]
cast([Field1], varchar(5)) ||' '|| [Field2]
You'd just need to determine your highest possible number of digits for the varchar part for [Field1].
10
Hi All ,
I am trying to add "Create custom filter" for some of the query items but it seems the option is not available although the option is available for other fields.
What I noticed is the query item for which option is not available they are created at business view level based on condition on the items which are at database view level .I was wondering is that the reason. Can we resolve the issue ?Any suggestions?

Thanks
Pages: [1] 2 3 ... 10

       
Twittear