cognos report Total defined at any level in dyanmic cube

I have measure column called "Member_Count"
I need to extract member total to "Member_Count"
you can define which level you wanted to make total for my case defined at doctor level.

Make new iteam:

total ([Member_Count] for [Query3].[Doctor])

Derived / Extracted measure in report studio using cognos dynamic cube

If want to create new measure in dyanamic cube cognos while reporting in cognos.

like below.

Please note don't take level don't take description so its better to take Key to calculate extracted measures.

---
CASE WHEN
[Main Service - Key] = 'ACCOMODATION'
THEN [Inputed Quantity]
ELSE 0
END
----

Saving Report Output to the Cognos Server File System - Automatically

Saving Report Output to the Server File System


ENABLING THE SAVE TO FILE WITHIN COGNOS CONFIGURATION

1. From Cognos Connection, click on Launch (top right)
2. Click Cognos Administration
3. Click on Configuration tab
4. Click Dispatchers and Services (left side)
5. Click the Define File System Locations button ( top right)
6.