system
July 24, 2013, 7:15am
#1
I have published a WebI block as a webservice, which I consume from dashboards (xcelsius). The webservice has 2 methods available (GetReportBlock and Drill).
There is also the possibility to filter on input values via the operator and value parameters.
Is there any complete list available of all operators I can use (equal, greather than,…) to filter? I would like to implement a between filter, is that also possible? I don’t find any manual about that. thanks!
hanshupe (BOB member since 2011-03-19)
system
July 24, 2013, 3:45pm
#2
As far as I know, the allowed values are:
EQUAL
No Between function that I know of. Please let me know if you figure out how to implement this!
-tkt
theknowtank (BOB member since 2011-04-20)
system
July 24, 2013, 4:02pm
#3
The help file for Bi services is in Webi Help.
Search for BI Service Structure in Webi Help. Also, there is no between boolean command.
I have handled this limitation by using interesting queries.between you could make some creative labels with options like
1 month from choosen date
etc. Its not exactly a between boolean, but it works for practical purposes for any enduser.
This guy also claims to have solved your issue:
I have a Xcelsius dashboard where I connect to a QAAWS, and pass a comma-separated list of values to a variable that has an In List prompt. I did that rather naturally, and it worked.
I’ve since then, consistently, failed to pass a list to a QAAWS variable, and have had to painstaikingly add input variables (with the [+] button), and map each one to a seperate cell.
I just figured out how I did it in the past, and verified that it works.
The secret (which I can’t holler at the top of my lungs…
Cairmor (BOB member since 2008-06-05)
(BOB member since 2008-06-05)