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

Tightly couple a Measure to a Level in Dimension

Started by EE, 15 Dec 2020 10:30:55 AM

Previous topic - Next topic

EE

Hi Team,

Is there any possibility of creating measures for a specific level
Example Benefits dimension have Levels like below

Group
Category
Plan
Option

We need to calculate the Enrollment percent for Group, Category and Plan is Enrollment Count by Group or Category or Plan/ Employee Count by Group
and Enrollment percent for Option is Enrollment Count by Option/Employee Count by Plan

This kind of dimension is used in dashboard crosstab.

If any one came across this approach please let me know.
Thanks in advance