URGENT: Help Please Query Join Not Working_Using Descendants Function

[AMC2013]

Hi All

I have a report requirement to create a report that has three prompts Cost Centre, Current Version and Comparative Version, there are 3 Measures and then need to show the variances between Current and Comparative version selected for each of these measures

I have created the three prompts, then created two separate queries that run the data required for Current and then another for Comparative. I then created the 3 variance items required and assigned to a cross tab report. The report worked when run, although the values seemed to be multiplied. To get the correct figures I used the Descendants function to only show the unique members for a specific level of the hierarchy.

Each of the individual queries work and calculate the correct figures, but when I updated the join query, I am getting the following error:

GEN-ERR-0016 - The 'descendants' function is not supported in the context in which it is used.

My data is a planning cube which I created using FM and the data source query type is set to relational.

Any ideas would be greatly appreciated.

[MFGF]

Hi,

Is the package a relational package (ie query subjects and query items) or a dimensional package (ie dimensions, hierarchies, levels, members, attributes)?

if it's a relational package, the descendants() function is not going towork as it is a dimensional function. If it's a dimensional package, you can do everything you need to do in a single query by dragging in the relevant members and measures.

Can you elaborate?

MF.