Search results for query: *

You can also try to filter the query that feeds the prompt.

Try the Status member in slicer area

Informatica technologies are focused on integration. The Informatica ETL is one of the world best. Cognos technologies are focused on query reporting (relational, OLAP). Cognos ETL (Data Manager) is good tool which has a strong integration with Cognos modelisation tool (Framework Manager)...

- Use only one Page in Report Studio - Set the "Maximum rows" property of your lists/crosstabs to 5000 (maximum)

A little summary of the new features: - Total integration of Transformer (Security, Publication of cubes...) - Mode "with no data" in Analysis Studio - Mode Report Studio Express (like an enhanced Analysis Studio)

If your using Cognos 8, try to: - Select more general object in the structure of the crosstab, like the "Crosstab Rows" for example. The style applied to the "Crosstab Rows" impacts all its cells. - Manipulate classes. Click on one cell and take a look at its Class property. Go to the Page...

What do you mean "it does not work fine"? When you enter '1' in your Text Box Prompt, your date is not in the range of selected dates? I'm not sure about that, but I remember that "[Date] between ?from? and ?to?" is not exactly equivalent to "[Date]>=?from? and [Date]<=?to?". "between" may do...

To sum up: 1) Implement a model in a "development language" (where columns contains the name of the table) 2) Translate the model in a "business language" 3) Use the "development language" to develop reports 4) Use the "business language" to access understandable business-oriented labels in...

It has not changed in Cognos 8. The Framework Manager model still ask for a "Business Name". I don't think it is normal to have the name of the table within the name of the column. It's more a technical need that a business need. However, I understand your point. What may interest you is the...

ParamDisplayValue() may transform your date into a char like '27 Nov 2007'. In alphanumerical order: '27 Dec 2007'<'27 Nov 2007' :S... Maybe you should create a calculation in a Query, like: if (?datefrom?<?dateto?) then ('ok') else ('error') end and display it in a list

For conditionnal formating, you need to use "variables". Here, a boolean variable should be ok. The expression of the boolean variable should look like "[Query 1].[Variance]>0". This boolean variable can have two values: Yes or No. Then, you need to link the variable with the object to format...

Indeed, working with cubes in Report Studio is very exciting, you can do a lot a thing with OLAP functions. 1) I understand that you have a member called 'Current Month' that display the value of a measure for the current month. But the member itself shows 'Current Month' instead of 'October...

I don't have the perfect solution, but maybe you could try these: Solution 1) Add a prompt page with a Date Prompt so as to set you dates before running the prompt. Solution 2) Add another 'Yes'/'No'(default selection) prompt (parameter ?activate?) in your Report Page so as to...

Well, there are several techniques that would resolve your issues, but I need more information. Are you working with cubes/DMR or tables? Are you working with Report Studio, Query Studio or Analysis Studio? Is your "list" of GL accounts displayed in a List or a Crosstab? I won't be able to...

I'm not sure I understand why you have several pages. Report Studio generates several pages when a list or a crosstab gives too many results. If there is no list, nor crosstab in your report, then I do not understand your problem. If there is list in your report, the only way to display you...

It is not a KB n°. In the 'Report Studio User Guide', PDF document available on Cognos Support, there is an example of "Page Set" building at Chapter 3.

When you define a "Text Item" and a "List" on a "Page", the "Text Item" will repeat itself on all the occurences of the "Page". I have a solution but only with Cognos 8 Report Studio. The idea is to insert your "Text Item" into the "Overall header". Step 1: Add an "Overall header" (object...

A very good example is given in the Report Studio User Guide, available on the Cognos Support Website. For example, if you need to print 2 pages (one tab, one chart) for the year 2006, then the same 2 pages for the year 2007, you'll a query that returns 2006,2007. You can then link this query...

Hello, do you use Cognos 8 Report Studio? If yes, try to take a look at the "Page Set" functionnality, it is a powerful way to generate a set of page (here 2 pages) for a list of elements (here the elements chosen in your parameter).

Is it possible to check the generated SQL?