Search results for query: *

Hello, Software: Cognos BI – Report Studio, Relational Database, v10.0 Object: Moving-Average of sales for 2 weeks back, only considering products that have at least 4 weeks on sale. Data Sample: Product Category Product Type Weeks On Sale Sales Office Supplies Pad of paper 1...

I'm using Cognos 10 and I was wondering if there is a way to pull the Top 5 of a product for sales and then throw all the rest of the sales in product "other"? thx, Q.

I created a crosstab report where product sales are displayed per day. Some products do not have any sales for some days. I set the crosstab to display missing characters as 0. However, I cannot get my line chart to do the same. What happens is the line ends where there is no data for a...

Hello, I would like to allow users to select up to 4 product types. So I created 4 separate prompts. I do this in a relational report as follows (for the actual data query): [ProductType] in (?P1?, ?P2?, ?P3?, ?P4?) This does not work in the dimensional report. For one value, I know I can...

Can anyone recommend a good thrid party mapping software for Cognos BI? I would like to find something easy that is bascially drop and drag, no coding required. I have found SpotOn Vantage and Integeo. thx, Q.

Hello, The end user would like to be able to select the number of rows to return in a HTML driven report. I was thinking I would add a text box prompt on the report and then use javascript to set the number of rows to display. Is this even possible? Cognos BI 8.4 thx, Q.

Hello, I am using Cognos Report Studio 8.4 If I have a crosstab report as follows: Product Year --> | Qty Sales Qty Sales V Year is dynamic, which is why I use a crosstab. I want to be able to click on Qty to drill through to another report and see the...

Hello, I am using BI 8.3 and would like to have a page that prompts the user for a value (Text Box Prompt) and once the value is entered I want to update a Text Item to reflect the entered value +1. So if the user enters a start range of say 1, I want the Text Item to dynamically reflect 2 as...

Hello, I have a pie chart in a list with a section. Everytime there is a change in the section the pie chart will display information that pertains to that section. All of that is working fine. However, I would like to keep the pie slice colors the same for each chart. That way the end user...

Hello, If I have a page set that breaks on say Product Type and each product type has the same or different lines. Is there anyway I can reflect the lines per type in the page header? I am doing this because the user will be prompted to select one or more Product Types as well as one or more...

Hello, I am using BI 8.4. I want to know if it's possible to not run a scheduled report if there is no data? My report is an audit report and when there is not data it still emails an empty page. thx, Q.

Is there any way to remove the "Modified" element from IBM Cognos Connection page? I do not want end users to see the modified date of the reports. I was able to locate the skin and remove the field, but it is still visible in the report. thx. Q.

Hello, I know it's posisble to put a prompt on a report so the user can select the output type. This is handy because when the report is typically rendered in HTML, it re-runs the report again when the user selects "View report in... Format". Is there a way to turn off the reload of the report...

Is there anyway Cognos BI 8.4 can read the files in a directory. What I want to do is create a report that lists all the files that exist in a specific directory. At the moment I am thinking that a bat file can be executed to read the names into a csv file which can then be imported into the...

I thought Cognos BI 8.4 was suppose to have a new "freeze column" attribute? Was I mistaken? thx, Q.

Is there any way to call a report name in the report? For example, if I create a report and save it as "Report A" can I call the name in the header of every prompt page without needing to create a text field and manually typing the name or cut and pastethe name? thx, Q.

Hello, I am using Cognos BI 8.4. I created a datasource and pull text files into the Cognos Framework. Terrible I know, but there is a reason for it. The problem is the text files don't have a header so it pulls in the first value as the field name, making it difficult for me to build queries...

Hello, I am using BI 8.4. What I would like to do is take a begin date prompt and an end date prompt ann list all the dates in between. So if someone chooses begin date = 8/1/2009 and end date = 8/5/2009; I would like to have a query that shows me: 8/1/2009 8/2/2009 8/3/2009..... Is that...

I have created a hyperlink that opens another report. I would like it to also pass a parameter value to the report. The parameter in the second report is optional. I am able to open the report via the link, but it does not limit data based on the paramater. I followed the structure given in the...

Is it possible to alternate row colors in cognso 8.4 BI? I saw one post already in this forum about alternating the colors, but it did not help. Also, I did find a document at the Cognos site, but it did not work. I am using a list report. Any thoughts, ideas....would be great.. thx, Q.