Filter lose 0 during navigation

[Former Member]

Good afternoon,

I found a problem with a report developed with BeX query designer. I added dimension 0GL_ACCOUNT as initial filter (select option). I noticed that if I do following steps:

1) Set filter 0070000000 - 0090000000

2) Launch the report

3) Start navigation of the report

4) click back

with this scenario, after some navigation, it is like the filter loses first two zeros (it becomes 7000000 - 9000000) and no data is retrieved. I notice the same behavior if, after launch, I click on "Initial Selections" and relaunch the report.

Did someone find a similar behavior and found a solution?

I Thank everyone for the support!

[Former Member]

I thank everyone for feedback! Next week I will check everything and I will give you my feedback & points!

Regards,

Luca

[former_member230898]

Hi ,

this might be a problem sometimes with customer Exit also

  implement the note

2120102  - Problems with customer exit variables            

Regards,

Bhaskar

[former_member230898]

Hi ,

If you are facing this issue in Netweaver 7.4 Version .. simply apply all the below notes

2109550 - Bookmark deletes filter selection

2101236 - Missing data in query with artificial characteristic Currency/Unit

2101188 - BICS: Filter on structure element is reset to initial selection

2096560 - BEx Web 7.40: Termination when using exceptions or conditions

2092810 - Filter variable on structure becomes ignored

2068075 - BICS: Values of exit variables remain empty after refresh

2064630 - BICS: Compoundment on Hierarchy Node Variable does not work

2052141 - Variable values not correctly resolved

2050425 - BICS: Dynamic filter missing and inconsistent state (N_SX_META_DATA)

This should solve the issue.

Regards,

Bhaskar

[Former Member]

Hi,

Please check below SAP notes which are valid for your BW SP18 7.0.

Please apply the BI Java patches as mentioned which should solve your issue..

1345101 - Empty var. value incorrectly filled after backwrd navigation

1536756 - Filter value lost in BACK_TO_PREVIOUS_STATE for DPs >= 2

Please also apply below notes as it contains ABAP corrections.

1344053 - Empty var. value incorrectly filled after backwrd navigation

Regards,

Amit

[sapna_jgurudutt]

Hi,

Can you please clarify regarding what is the SP level applied to SAP BW ABAP component?

Can you please set the RSADMIN parameter named ALLOW_MULTI_DP_RESET in the relevantb BW Backend system and set the value to 'X' and check whether it helps you.

ALLOW_MULTI_DP_RESET=X

To add 'ALLOW_MULTI_DP_RESET' parameter in the relevant BW Backend table RSADMIN
make use of the ABAP report SAP_RSADMIN_MAINTAIN through the transaction
SE38.

Please refer the following SAP Note for further details:

1581923 - BEx Web: Optimization on Back with Many Data Providers

Thanks & Regards,

Sapna

[Former Member]

Good afternoon,

current BW release is 7.00 SP 18. I will check the two points you told me (add of ALLOW_MULTI_DP_RESET parameter + sap note) and I will let you know the results. In the meantime I thank you.