cognos Audit Milisecond to hour convert

Milisecond to hour calculate in cognos audit

[Audit].[Run Reports].[Execution time]/(1000*60*60)

Cognos report studio image file configuration IIS

Details find in link : https://www-304.ibm.com/support/docview.wss?uid=swg21506690

Configuring WebDav on IIS 7.5 to have access to your image on Report Studio:

 Verify in Server Manager that the following IIS components are installed:
- Webdav Publishing
- Windows Authentication

Go then on Default Web Site and activate Webdav and Windows Authentication (both are disabled by default):

 

 

Double click on WebDav Authoring Rules on Default Web Site level and then click on WebDav Settings…

- Modify "Allow Anonymous Queries" to "True"

- validate clicking on "Apply"

Go then in Samples/images in Cognos IIS alias and add a Webdav rule, for example all content / all users / read as below:

You can now navigate in the Report Studio Browser Image:

Distinct count on report studio

Count(distinct [MBRSHP_NO_BK] for [DOCTOR_NAME])

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. 
   

Cognos dynamic cube with stand alone / New table, no relationship with fact table

Cognos dynamic cube  with stand alone / New table, no relationship with fact table

Separete new table / dimension need to publish in cognos dynamic cube package without joining fact table - wihtout relationship with fact or dimension table, New table means just stand alone table.

Steps:

1. Get Table ready in Database
2. Create new dimension with new table
3. Drag new dimension under existing cube
4. Drag new dimension out of existing fact table (trick is here : Don't put inside measure folder new dimension move to outside of measure folder )
5. Need to define relationship to existing fact table because its (new stand alone table) has no relation with existing fact table.
6. Validate it and publish the cognos dynamic cube package