If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Report Studio - Properties

Started by Deepika, 04 May 2008 04:57:33 PM

Previous topic - Next topic

Deepika

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? 

rockytopmark

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

blom0344

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?

rockytopmark

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.

blom0344

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

rockytopmark

If you can send me a case example with the GO Sales and Retailers, perhaps I can see what I can do.

blom0344

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