on 05-10-2007 6:16 AM
Hi,
I have created a data store element( in fact two data store elements ,one for adding to cart and other for clearing cart) ...i used the following procedure..
1)Add a data store element to the output port of table
2)Right click and select Configure element to configure its properties
3)Create a virtual field for the data store and enter the name of field
4)Click the connecting line to the data store, and name the event
5)Double-click in the Assigned Value column to display the Assign Value dialog box (Expression Editor) & create an expression that maps values from the table to the data store ...the expression i uesd is
<b>IF(CONTAINS(STORE@Items,@Sales_Region),STORE@Items,STORE@Items &(IF(LEN(STORE@Items)>0,'; ',''))&@Sales_Region)</b>
6)Create another data store
7)Rename the event
8)Map the value for the Assigned Value of the input field
the expression used is <b>" "</b>
9)On the Layout board, create buttons for activating and clearing the data store items
10)On the Design board, create a free-standing form called Cart
11)Define a virtual field to display the data store (cart) values and name the field
I want to pass the stored values to another query which has sales region as input variable....
I have created a link from the free standing form to the query and submitted (system action-submit)..
I want all the values in the free standing form to be submitted to the query and the query should get the report for all the selected sales regions...
Any help on this..
Thanks & Regards,
P.Navakanth.
Hi
I have not had time to check out the attached model, but one thing which should be remembered is that there is only one data store for any model, in effect the data stores you have in your model are all the same.
Jarrod Williams
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sorry, I don't understand the issue, but you describe a complex thing, so that after reading I don't understand what do you want. When the values are in the datastore and you fire an event so that the query will be executed then you can reference to the values of your data store in the transition to the query.
Best Regards,
Marcel
PS: Maybe you can share your model here as gml, then I will have a look at it.
Best Regards,
Marcel
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Marcel,
I Have sent you the Model...I will explain u what is the purpose it was created for;
i have two queries( say Q1 & Q2 ) in my BW 3.5 System..Q1 has "Sales Organization" as input variable ( not mandatory) ...and retrives say sales group,open orders,open orders quantity etc...what i have done is i have used "Entry list" element for sales organization ..and used "Exception " ( created virtual field for open orders quantity) to display the results of Q1 in 3 colours( styles) ...for color 2 in the results of Q1 I wanted to select sales group from the results table of Q1 and put the collected sales group in a form( i used data store element)...and then submit the collected sales groups to Q2 which retrives the results of Q2 for that particular sales groups only....
Now ...i have found error in two places...
1)at the entry list... where iam able to see the list of sales organization for the first time of execution of deployed iview in portal.
2)at the data store ...where iam not able to pass all the values from the form to Q2
I think the possible issues should be at the Query level in BW system in defining the variables...( For the entry list issue)
or at defining the formula of the selected field...(for the data store issue)
Can you please help me on this issues...by looking at the model..
Thanks & Regards,
P.Navakanth
Hi Navakanth,
it seems that nobody has tested it with your file. I tried to import it in my system (we are on NW04s SPS10), but an error occurs. The GML file, which you have sended me is corrupt (an attribute is missing). I think there is something wrong. To verify this issue, please send me again the model as gml file.
Best Regards,
Marcel
User | Count |
---|---|
94 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.