1

Topic: Cognos BI

All greetings! Prompt, in the cross table in Report Studio I can change a separate one cell of the table? I want that it went through calculation on .

2

Re: Cognos BI

Value of a separate cell what ? I want that went through expression

3

Re: Cognos BI

I similar did. How much I remember, used such approach - selected a cell and in properties found the general property - "to Set contents", changed its value with "was not present" on "Yes" and after that in a cell it was possible to place either a constant, or the formula.

4

Re: Cognos BI

Jurii;
And if I want, for example, in this cross table two columns to increase against each other and there was in this separate cell a total. To set contents I found, and here is how the formula to interpose did not understand

5

Re: Cognos BI

Drag in a cell object "request Calculation"

6

Re: Cognos BI

Jurii;
Made, but in the report this cell empty

7

Re: Cognos BI

Became empty

8

Re: Cognos BI

And the formula what specified?

9

Re: Cognos BI

Jurii, in request created a data member
[The name 1] / [the name 2] *100
Then to set contents and request calculation - selected from requests - the data member created by me:
[The name 1] / [the name 2] *100

10

Re: Cognos BI

There there is a row of subtleties...
Try about an insertion of Calculation of request in a cell to create the formula in an equation editor

11

Re: Cognos BI

1994Jurii;
And there is an example as in an equation editor it to carry out? What subtleties are...

12

Re: Cognos BI

I near at hand do not have 10th version IBM Cognos BI, for a long time work in 11 versions.
In an equation editor like all intuitively it is clear. Try .
The subtlety the main that there are tables-schedules in the report, and is Requests which are connected to them, it is necessary to understand, what request under the table. It is necessary to understand object hierarchy of the report. If at you this basic knowledge is not present, to you it will be difficult  wink

13

Re: Cognos BI

Jurii;
I understand as the table is connected to requests. And the request concerns what table. I do not ask to write for me. This forum generally for what?!

14

Re: Cognos BI

Jurii;
11 version did not see. And what difference? I think the big difference is not present

15

Re: Cognos BI

Forum - to help each other. I answered your first questions, and - how to do formulas in an equation editor - it was not possible while to answer the abstract question, when there like all it is obvious - that there is a field for formulas, there are bookmarks with a metalayer, multidimentional and relational functions, parameters, etc. which it is possible to drag in the field for formulas...
In version 11 the interface a little another though as a whole it is finite all advantages of version 10 were saved.
If you cannot solve your problem - address in round-the-clock support desk to the address cognos@yandex.ru, there it will be necessary to give your contact information. There you can inform connection parameters to your server and experts free of charge help you (with reasonable limits to have time to help and to other users IBM Cognos).