Solved

Cognos DMR Model Help

Posted on 2012-03-17
3
717 Views
Last Modified: 2012-03-18
Here is an attachment and what I'm looking for is
"Number of districts below 25% turnover rate"


**Any further questions let me know please..
Thank you in advance
Untitled.png
0
Comment
Question by:Sunsetbloom
  • 2
3 Comments
 

Author Comment

by:Sunsetbloom
ID: 37733945
Here is a mock up chart what I'm supposed to create... I'm stuck as to how go about the total of my districts to display. The above chart is just a gist as to how my data looks
Untitled2.png
0
 
LVL 12

Accepted Solution

by:
RWrigley earned 500 total points
ID: 37734896
Assuming that the lowest level of your "Total" dimension is called "District", you should just need an expression like:

count(1 within set filter([MyCube].[Total].[Total].[District],[TurnoverRate] < 0.25))

But you may need to be careful depending on if your "turnover rate" is a database item or a calculation.
0
 

Author Closing Comment

by:Sunsetbloom
ID: 37735723
Earlier before posting this question, I used the exact expression like the one you have suggested... but it didn't work because I forgot to refer the lowest level data so used the descendants function.
Thank you so much for your prompt reply. :)
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
This video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…

820 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question