cancel
Showing results for 
Search instead for 
Did you mean: 

Check Box or Drow Radio Button on Bex Query

Former Member
0 Kudos

Hi Experts,

Does anyone know to how to put a "Check Box" or "Drow Radio Button" variable on query selection screen?

The user want to switch the order data between open and completed on a same report by a check box / radio button.

Thnaks

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Change the Info Object''s Business Explorere settings for "Filter Value Repr. At Query Exec" under "Business Explorer" tab of Ino Object creation/edit screen.

I hope it will help.

Thanks,

S

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi Hari & Danny,

Pls correct me if I'm wrong. Your solution is based on a "status" Char. in the cube. But I don't want to add a Char in the backend. Is it possible to create a check box w/o a Char in the front end?

Thanks

Former Member
0 Kudos

I had exactly suggested based on that assumption that you will have some char which will show the status of the document.

But seems like you do not have such thing. Can you please explain me without having such characteristic, how do you calculate OPEN / CLOSED thing?

- Danny

Former Member
0 Kudos

Danny, I would differentiate "complete/open" shipment based on if actual delivery end date exist or not. It's a date Char not status. Besides adding a new status Char is there any way to release it in the front end?

Former Member
0 Kudos

Hi,

If you dont have any CHAR to display the status and you want to do this on front end then try Virtual Key Figures for this (If works).

I would suggest populate one flag at the time of loading then only use this drop down/radion for status display on that staged CHAR.

I hope it will help.

Thanks,

S

Former Member
0 Kudos

Hi Linkzhou,

Why don't you directly use a var on Actual Delivery Date & include/exclude on # cases to report open/closed shipments.

Alternatively, You can achieve the same without making changes to backend, if you are ok with using WAD. In WAD 7, you can use a DropDown webitem instead of a RadioButton/Checkbox webitem since you cannot assign a Command on selection from a RadioButton/Checkbox webitem. Also, you would need to design the same in a web template since this will not be made available on your query selection screen.

In the DropDown webitem, use Data Binding Type -> 'Fixed List of Options' , here you can configure

Open -> under Action use Command 'SET_SELECTION_STATE_SIMPLE', choose your Actual Delivery Date char, Sign -> INCLUDING, Operator -> Equals, Equals -> Member Name, Member Name -> Direct Input -> # [Not Assigned]

Closed -> under Action use Command 'SET_SELECTION_STATE_SIMPLE', choose your Actual Delivery Date char, Sign -> EXCLUDING, Operator -> Equals, Equals -> Member Name, Member Name -> Direct Input -> # [Not Assigned]

Now when the user selects Open option from the DropDown webitem, the data provider query will be filtered for open shipments & vice versa for Closed option.

--Priya

Former Member
0 Kudos

Thank you ,Choudhary. It's closer but not the answer I want.

The "check box" variable I wamted is more like a flag. Once you tick it will resticted report to display only completed orders ; if un-check it it would present you the open orders.

I don't want to release it in the backend since addtional effect on delta mechasim have to be implemented.

Thanks

Former Member
0 Kudos

Hi,

I am assuming that you are using BI 7.0 BEx Analyzer.

Instead of giving them option of choosing the type of documents (Open / Close) on the selection screen, why don't you put that selection in a query result and give them a workbook solution.

Once your query is run, you can go in design mode and add the drop down / radio button / check box based on any one characteristic. In your case, it would be the one, which defines whether the document is Open / Closed.

The moment you change the selection, query result would be refreshed.

- Danny

Former Member
0 Kudos

Hi,

Do you have Order Status in your Query. If yes, then you can create a variable restriction on Order Status characteristic in the query. The user can select the status (Open, Closed) from the variable screen.

Another option is use Web Application Designer and assign the Checkbox or Radio button to the Status Infoobject. But the user won't be able to access the checkbox from the selection screen. If you have a variable assigned to the object then, the user can select a value from the selection screen and then if he wants, he can change it later from the report.

Regards,

Hari.

Edited by: Hari Krishnan K on Jul 26, 2010 11:54 AM

Former Member
0 Kudos

Hi,

it will not effect anything in back end.

It will provide you check box on slection screen when you will ask for variables you need to select the as per you need and query will display the desired result.

it is just replacement of default text based slection screen to check box.

There is one more option if you are doing this one Analyzer.

You may include the check box over there and assign data provider to that. It will display all the available values in existing Char as check boxes and after slecting the required ones query results will get changed accordingly.

I hope it will help.

Thanks,

S