I have a universe with several contexts and multiple uses of Aggregate aware. I added an object that calls a function (standalone, no parameter). When I use this object, in my query within condition, query is generated ok and chooses the correct level of aggregation.
But if I select this object in the “Result objects” window, it pops up with the “Select a Context” dialog box. I do not see a reason for this and the Aggregate Navigation seems to be set corretly… Is there any problem with using function within universe or am I missing something?
You need to define this function object as belonging to a table, using the ‘Tables…’ button on the object properties window.
If the function takes parameters then you should set it to the table those parms come from. Otherwise you would need to create one function object per context it could be used in, and set it to a fact table from that context.