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.
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.