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 found the solution. Nevermind, but thx.

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

I have encountered this problem several times. Usually I play around with cast...cast one or the other as date or even try varchar..until it works.

Can you do a calculation? [Units]/[GrupCanaVerda]

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

The solution is not perfect, but this is what I did: 1. Unlocked the page. 2. Clicked on the field where I wanted the drill through and set the parameters. 3. Changed the foreground color of the field to blue and underline value(to resemble a hyperlink). What makes it ugly is that it's not a...

Okay - thanks for the "step-by-step". It makes perfect sense. A little clunky, but a nice alternative. I will see if it works for the powers that be. thx, Q.

Ties, thanks for your response. I am not really sure how to go about implementing your alternative solution. Q

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.

Nevermind. I figured it out.

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

Nevermind. I resolved it by using a master detail relationship.

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.

Great - Thanks! That was easy. Now how would I update the GlobalReportStyles.css to apply ReportName() to the page header. Or is that not possible?