Standalone function as Measure causes "Select a Context

building semantic layer
1

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?

Thanks

chiragk :us: (BOB member since 2003-10-22)

2

Are you selecting only that Object in the Results Pane or with other objects???

Sridharan :india: (BOB member since 2002-11-08)

3

With other objects.

chiragk :us: (BOB member since 2003-10-22)

4

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.

JP Brooks :us: (BOB member since 2002-10-22)