Finally I understood how it works … below points are clear :
Web service connection for DB
Web service connection for Report Block
Web service connection - QaaWS
How to go for Query Browser
Now finally we have decided to go with the option 2.
And frankly speaking, I am really facing crunch of time and need to deliver this, and I am very new to this area, so would be great if someone can please help me …please
In dashboard I have a push button which shows me one drop down list and two calendars to select start and end date
2. Now important here is How will I pass the values to WEBI latest instance as data will come from the latest instance.
I am not sure how much I could made you to understand but this is really eating me and I need to find it out without helping hands… please guide me if there is any way out and I need to take care of the performance too… which is again next big thing …
The WebI report should run with ALL the data. Since it’s running on a schedule, that shouldn’t be painful.
When you create the web service connection, on the step where you name it there is a button to specify filters. Choose which fields you want to be able to filter on.
When you create a connection on the web service, you will see those filters come up. Each filter allows you to specify a value and an operator. You can link these to fields, so you can even have the operator change. (I usually do this to power an “ALL” selection.)
The possible operators are:
EQUAL
NOT_EQUAL
INLIST
NOT_INLIST
GREATER
GREATER_OR_EQUAL
LESS
LESS_OR_EQUAL
Theoretically you can use the symbols, but I’ve never gotten it to work right for me. This list has always done me right.
Make sure to set getFromLatestInstance to TRUE. I generally have to link it to a cell that contains TRUE to get it to work properly.
As a note, the web service will create two methods. One is GetBlock, which works as I’ve described. The other is Drill. I haven’t figured out yet how Drill works.
Today I will surely try and let you know how it worked … just want one thing, how would I take care of ALL part. For Dates, it is fine as it is SINGLE select but the user can select ALL or a SINGLE value for employee field from the drop down list… so not sure how ALL works here…
If you have “ALL” as a selection in your dropdown list, here is one method to make it work:
You have the results of the dropdown selection go to a cell. Let’s call it A1 for simplicity.
In cell A2, put the formula: =IF(A1=“ALL”,“NOT_EQUAL”,“EQUAL”)
Bind the operator of your filter condition to A2.
Now, when the user selects a date like 6/30/2014, the filter will read EQUAL ‘6/30/2014’. When the user selects ALL the filter will read NOT_EQUAL ‘ALL’, which should be all the dates.
These are just like the “In List” and “Not In List” operators in WebI. They allow you to specify a group of possible values to either include or exclude.
E.g., to select east coast states you might have INLIST “Florida”;“Georgia”;“South Carolina”;“North Carolina”;“Virginia”
(BOB member since 2007-10-05)