cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Business Objects 4.2 WEBI - Set Functions

sapkh123
Discoverer
0 Kudos

Does anybody know if the set functions can only be used with BEX queries? I ask because I'm not able dot use them with IDT universes.

Accepted Solutions (0)

Answers (2)

Answers (2)

sapkh123
Discoverer
0 Kudos

Thank you for your answer. We dont't have BEX queries. Our universes are in the .unx format based on a Oracle database. In the IDT I can only define the gerarchies. I tried to define the set functions my WEBI report but thats not working.

Example for the set function ancestor

member Ancestor(member;level|distance)

Input

Parameter Description Type Required member Any member member Yes level The level of the ancestor level Either level or distance is required distance The distance of the ancestor level from the current level int Either level or distance is required
=Sum([Query 2].[Internet Sales].[Internet Sales Amount];{Ancestor([Customer Geography];[Customer Geography].[City])})
former_member185603
Active Contributor
0 Kudos

You define the sets in IDT and to use in WEBI reports. Did not understand your question.