If I'm in Report Studio and I have the properties set to Page, under Data there is a section called properties. When I click on it, it list query items that are in the report with check marks.
Can anybody explain in detail,how does this work?
CFew things... 2 relate to the query items not being in a list, graph or crosstab, yet being needed for either:
1). Conditional Variable - You click query items in the properties setting that you need to reference in the report for use in Conditional Variables. You may not necessarily want these items in the list/graph/xtab but you need to condition off of them
or
2). Drill-Through parameter passing - Same idea... you need to pass a key column, but it would make no sense to include that key in a list/graph/xtab, so adding the check in properties allowas it to be used to satisfy parameters in a drill-through definition.
and the other...
3). If you want to include non-factual information in the body of a Xtab, you will need to have the row or column's properties set to include the non factual item(s) so they can be used in Xtab cells (Define Contents = Yes) like they were facts.
hth
This is pretty cool stuff, rocky..
On the last type of behavior. Suppose I want to display just status codes in the crosstab body (which are non-facts), then the only way to get it to work is to assign a dummy aggregate like maximum on the data-item. Is there another way to get this to work?
Not really sure about the need for the aggregation you mention. I use the Define Contents setting of "Yes." I just looked at a report that utilizes this and there is no aggregation on the data item. Think of these data items as attributes of the Row Edge's source (dimensions...Identifiers). With that, it is really acting like a column in a list report.
I use Crosstab spaces on the Column Edge to achieve my results, and the define contents = Yes is set on the cells in that column.
My primary interest is with a regular crosstab. Say, displaying status codes in the body as intersection of project ID's and a time dimension like month. The codes in the body are numeric values, but not facts. Without an aggregate applied to the data item the crosstab stays empty.
I just wondered if it is possible to get it to work without the maximum aggregate..
If you can send me a case example with the GO Sales and Retailers, perhaps I can see what I can do.
Unfortunately the demo you mention is not installed, so I have no example on a shared source.
The issue is actually even worse. I tried to build a crosstab involving code-strings and Cognos does not allow an aggregate like min or max on an data-item that is used in the body.
Perhaps I am trying to misuse the Cognos crosstab, but these were fairly straightforward exercises with Business Objects.
Example:
- ProjectID Quarter Code
- 1234 Q1 01.ABC
- 1234 Q2 02.DEF
- 4567 Q3 04.JUK
- 7846 Q1 05.RTG
- 0978 Q4 01.ABC