Hi Chris,

SCOPE definately helped since the calculated member will be evaluated when the Category is selected on the axis.

When the Category is not selected, on its own, the calculation...

Managed to solve this using SCOPE although not perfect.

Cheers

Hi Raunak,

I have changed the part of the expression you pointed out to:

iif ( isempty([Measures].[Support Hours Bought]) OR [Measures].[Support Hours Bought] = 0, 0, [Measures].[Support Hours Bought] - [Measures].[Duration in...

Hello Raunak,

This is the complete MDX for the calcualted members. There are 2 numeric columns because I am adding 2 calculated members, named Remaining Support Hours as Per Agreement...

Hi Raunak,

It is ignoring the IIF because if I create another calculated measure with same expression but without the IIF as per:

CREATE MEMBER CURRENTCUBE.[Measures].[RSH]

AS [Measures].[Support Hours Bought] - [Measures].[Duration...

Hi Steve,

Go exactly your suggestions so now it's workin Thanks heaps!

Hi Steve,

Thanks for your comment.

I have created the relationship in the DSV but I do not get the wizard to create the Parent-Child dimension, maybe I am missing something?

Thanks

jon

Thanks Arjun for your help. Solution perfectly works 😉

Thanks Arjun for your solution, however, what if the 'large' xml file contains 100,000 'root' nodes?

In addition, the solution returns three columns, not three rows.

Do you think it is...

Hi Jack,

Thanks for your help. Your link and article really helped a lot and managed to get around the problem 😉

Cheers and Thanks

Jonathan

You're Welcome mate... glad to help 🙂

chris.stuart (4/19/2010)

---

Jonathan Mallia (4/16/2010)

---

if you have any indexes, disable or drop them, and recreate afterwards.

Also, do the same from any triggers.

Furthermore, set the database...

if you have any indexes, disable or drop them, and recreate afterwards.

Also, do the same from any triggers.

Furthermore, set the database recovery mode to bulk logged and reset to full...

Thanks for yoiur post Santori.. it was really helpful.

Any othe ideas / suggestions still welcome 🙂

Thank you

Thanks for yoiur post Santori.. it was really helpful.

Any othe ideas / suggestions still welcome 🙂

Thank you

Thanks for getting back to the question 🙂