How to write an MDX query to create a new Billed Hours measure?

M

Meghanath Singh

Hi,

This is related to Project 2007 Server.

I have a Project-level custom field called 'Project Category' through which
I am classifying whether a project is a billable activity or not. Values are
linked to a lookup table with two entries: Billable & Non-billable.

What I am trying to do is to introduce two new measures: Billed Hours and
Non-billable Hours, through which I will be able to view by each resource how
many of the planned hours (Work) are billable, non-billable or free over a
time period. What I am trying to get from the cube is something like this:

Resource | Billable Hours | Non-billable Hours | Free |
--------------------------------------------------------------------------
Resource 1
--------------------------------------------------------------------------
Resource 2
--------------------------------------------------------------------------
Resource 3
--------------------------------------------------------------------------

I am new to MDX queries. Can someone help me with how I can achieve this?

Thanks

Meghanath
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL Query for actual hours worked by day including summary tasks 3
Calculated Measures MDX error 0
Trying to Create a report for Time Billed vs. Time allocated 3
OLAP Cubes and Custom Fields 1
Query: Billable Hours vs. Non-Billable Hours 3
How to implement two shifts per day with multiple teams 0
Trying to get my head around reporting fields...help!? 1
Administrative built-in tasks and Billable/Non-Billable hours? 0

Top