INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

MDX Calculated member to compare dates for SLA purposes

MDX Calculated member to compare dates for SLA purposes

(OP)
Hi,

I have a task table, which contains Task Start Date, Task Due Date and Task Completed Date. I want to use this information to calculate a variety of things.

I created a degenerate dimension from the FACT_Task table called TimeTransactionTask with the three datetime fields as dimension members. How can I now use this to calculate (for example) if the task falls within its service level agreement (I.e. where Task Completed Date <= Task Due Date).

On the surface this seems simple, but the calculated member below does not provide the correct results. I am assuming it is because the evaluation is not hppening at the most granular level. Any ideas?

CODE

CREATE MEMBER CURRENTCUBE.[MEASURES].[TaskUnderSLA]
    AS SUM(IIF([TimeTransactionTask].[TaskComplDateDATETIME].CurrentMember
            <=[TimeTransactionTask].[TaskDueDateDATETIME].CurrentMember
            ,1,0)),
   FORMAT_STRING = "#,#",
   VISIBLE = 1;

EO
Hertfordshire, England

RE: MDX Calculated member to compare dates for SLA purposes

The best solution would be to add a column to your fact table to denote the 1 or 0, then a measure to sum those.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close