Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Cognos Crosstab report w/ Multiple Dimensions on Columns does not display all data values

I have a report with a cross tab in it that has mutliple dimensions for both rows and columns. Data displays properly for all row dimensions (account values, calculations) with the first column dimension (date). The problem comes on the 2nd column dimension. It displays the data for account values but does not display anything for the calculated value (for example if true then (1) else (2) comes up null in the cell). However if I change the formula to a simple value, say (0), then it displays data. The data is partially correct but entirely. The question is 1) why doesn't the formula work and 2) what behavior should I expect when putting in a single value? I was expecting to see the value '0' but it appeared to be more like a summary.

Thanks in advance.

Derry

0 votes



2 answers

Permanent link
Hi Derry,
                Are you getting the correct values when you view output on the query (Query assigned to the Crosstab) itself? 

Thanks.

0 votes

Comments

Hi Valli,

The tabular output has data in it. With the logic mentioned above the data item output in tabular form will display '1', just not the crosstab.


Permanent link
Use a singleton in the cells by setting the property of the cell 'define data' to 'yes'. Then point this singleton to the desired query data item.

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 12,036

Question asked: May 21 '13, 9:23 p.m.

Question was seen: 17,911 times

Last updated: May 23 '13, 11:17 a.m.

Confirmation Cancel Confirm