?
Solved

Cognos DMR Model Help

Posted on 2012-03-17
3
Medium Priority
?
736 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 2000 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Please read the paragraph below before following the instructions in the video — there are important caveats in the paragraph that I did not mention in the video. If your PaperPort 12 or PaperPort 14 is failing to start, or crashing, or hanging, …
Suggested Courses
Course of the Month15 days, 7 hours left to enroll

850 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