on 07-31-2018 9:32 AM
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.
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])})
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You define the sets in IDT and to use in WEBI reports. Did not understand your question.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
83 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.