I need to display Region = 'CEE' only ,but I need to display the same in all the applications(attached Emma.png) ,I attached that QVD also pls suggest how to do

[#1]

[senpradip007]

Hi palla,

As per my understanding you want to display CEE region only.

Set OnActiveSheet trigger first, select the Region='CEE' and then lock Region field then OnLeaveSheet Unlock Region and Clear the field Region.

Hope it will help you.

[#3]

Hi,

Not sure if I understand you correctly, there can be two scenarios:

1. You want to have only "CEE" as region in your application, in this case you can apply a filter in script on your query as:

Where region = 'CEE'

2. Another possibility, you want all the regions to be available in the application but want to show only CEE on this particular sheet, then you can add an action OnActivateSheet as below:

Action Type: Selection

Action : Select in field

Field : Give the fieldname for Region

Search String : CEE

Hope this helps!

[#4]

Thanks ,but reamining also will be displayed in the drop down ,here my script is there pls check

CompanyLoad:
Select
  PRM.EMMA_GROUP_CODE      as EMMA_Group
,PRM.CO_ID
,PRMH.CUR_CODE                           
,PRM.EMMA_TRSF_COST_GRP
,PRM.EMMA_CGM_GRP
,PRM.EMMA_ELNSP_GRP
,PRMH.EMMA_RPT_UNIT                                       
,PRM.EMMA_INVC_SRC   
,SLLR.GEDW_TRP_KEY                                                                                                          
,PRM.EMMA_REGION_NAME                
,PRM.CO_NAME                        
        
from     DEALLV01.PR_EMMA_PARMS_V001                         PRM
     join DEALLV01.PR_EMMA_PARMS_V001                         PRMH
       on PRM.EMMA_GROUP_CODE = PRMH.EMMA_GROUP_CODE
      and PRMH.CO_ID = '**'
     join dcsav01.vcsa_trading_partner_location               sllr
        on prm.sllr_loc_id = sllr.tp_loc_id
           and sllr.tp_loc_qlfr_code = 'FC'
           and sllr.tp_curr_ind      = 'Y'            
Where
      PRM.EMMA_GROUP_CODE = '$(EMMAGROUP)'
      $(COMPANY)
;   

Company:
left Keep (InvoiceLoad) load distinct
EMMA_Group
,CO_ID
,CUR_CODE                                            as Report_Currency
,GEDW_TRP_KEY                                        as SLLR_TRP_KEY 
,EMMA_TRSF_COST_GRP
,EMMA_CGM_GRP
,EMMA_ELNSP_GRP
//,EMMA_RPT_UNIT                                       as Report_Unit
//,if(EMMA_RPT_UNIT ='FQ','Figured Quantity Units',
//       if(EMMA_RPT_UNIT ='SELL','Selling Units',
//       if(EMMA_RPT_UNIT ='SC','Supply Chain Units','Unknown Unit Requirement')))  as Reporting_Unit
,EMMA_INVC_SRC                                      as Source
,CO_NAME                                            as Company
,EMMA_REGION_NAME                                   as Region
  Resident CompanyLoad;    

Drop Table CompanyLoad;

[callsresri]

pandit is right..

[#6]

If you want to do it at script level then in your script, you can add a filter in "Company" table as :

Where EMMA_REGION_NAME = 'CEE' and that should work.

[#7]

Thanks for  all

[#8]

I want to select APJ if OSUser()=ASIAPACIFIC\

please help