Extract a single value

[Clint_EastCog]

Hi everyone,

I am a new one to use Cognos Express.
I have Cognos Express and MS SQL Server Analysis Service 2008.

I must doing a simple task in a rapport. I have to extract a single value from a cube. This value depends on tree dimensions.
I use IBM Cognos WorkSpace Advanced and i created a crosstab report. This values appear in the crosstab.
But, how can i delete title, auto created totals,... to isolate the single value that i need.

Does i use a list and create a MDX query instead ?

Sorry for my poor english.

Thanks

[vinothkumar62]

Hi,

First, Let me confirm my understandings.
1. To hide the totals in the reports.
2. Inserting the one particular level in a dimension.

Let me expand one by one.
2. For inserting the one particular level just expand the dimension & select the levels which ever you need & right click -> insert into row / Columns. You can give how you want in the report.

1. To hide the auto totals in the report you can hide both row level & Column level totals by selecting the totals then right click -> hide. This will hide the auto totals. You have to do separately for row & column levels.

Please try & let me know if you have any queries.

Thanks.