Solved

Cognos DMR Model Help

Posted on 2012-03-17
3
708 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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
Hello, In my precious Article  (http://www.experts-exchange.com/Database/Reporting/A_15280-Create-Project-in-Microstrategy-Part-I.html)we saw the Configuration part for Microstrategy which included Metadata Creation and DataSource Preparation as …
This video gives you a great overview about bandwidth monitoring with SNMP and WMI with our network monitoring solution PRTG Network Monitor (https://www.paessler.com/prtg). If you're looking for how to monitor bandwidth using netflow or packet s…
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

707 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now