Search results for query: *

I was handed a new model. In Query Studio, when I select a query item I get a prompt. I assume the filter has been created in Framework Manager, but I can't find the filter. Is there any other place it could be. It's not in query studio, because this happens with a new report.

Calculations like YTD, that have to be query items in the report. Is it easier to create them in the database or in the Framework Manager? Opinions Wanted

Is it possible to copy query subjects between Framework Manager models?

Has anyone else had problem with date formatting in a crosstab when the date is either a column or a row?

Can I use variables in filters and query items?

What is the difference between a Summary Filter and setting a Detail Filter to after Auto Aggregation?

I have a report with nested page sets. I have to change the grouping level of the lists in the report depending on the page. My initial thought was to try this in a query item: Case PageName() When 'Project' Then [Project] When 'Region' Then [Region] Else 'Unknown' End This doesn't work...

In Impromptu, it was possible to reference individual measures in a crosstab measure. This made it easy to do calculations on the crosstab data. How is this done in Report Studio? So if the crosstab produces the following when run: A B Z 1 3 Y 7 8 and I wanted to do a...

What is the "best practice" for importing functions from a database into Framework Manager, and them making them available in Report Studio? thanks,

If I create a date prompt with the range value set to yes, how can I grab the individual dates chosen. For instance, if I want to do a calculation on the first date, like adding months?

I have a two page prompt. The first prompt page has a single list box, with three static choices. I take the users choice from the list box, and use that to filter a query. I then display the filtered results in the second prompt page in a multi-select box. I would like to know why values...

In Report Studio What are the functions in range and between actually calculating? Are they >= and <= or > and <

This is a completely inappropirate post, but... Blom you are the most accomplished Cognos person I've ever encountered. Where did you get your experience, who are you? :)

The client has asked for a report that is essentially 8 different list reports on one page. They call this there scorecard. Here is where I'm looking for suggestions. The report is a multi-page report with page one being the report data rolled up to a company wide level, the next page showing...

Say I have a value which equals .23067, but I format to look like %23. If I do a computation on that value Cognos will use .23067, not the formatted value. Is there a way to force Cognos to use the formatted value?

Is their a way to create pagebreaks based off sections without using page sets?

I've run into this type of problem several times, and I've never found an answer/reason for it. I've been able to come up with various solutions / work arounds, but nothing more. Here is the problem. I have a column in a report, and I want to total it. I have several Groups in the list...

Where could I find the documentation for Cognos global style sheets and classes. I don't have access to Cognos on the servers.

I want to remove the first two characters from a string, but I don't know what those characters are going to be, how would I do this in report studio?

I have a calculated column in a crosstab report. Basically if the condition is true, I want it to return the column, if it's not true I want it to do nothing. At the moment I have this case statement. case [Sales Year] when ?Parameter Year? then 'YTD ' + ?Parameter Year? end This returns the...