SAP Knowledge Base Article - Public

1564957 - BI4.0 Advanced Analysis for OLAP: after reopening a saved workspace, the crosstab shows a warning “No member with Data” after refreshing the analysis using the saved prompt values

Symptom

BI4.0 Advanced Analysis for OLAP, a saved workspace shows crosstab warning “No member with Data” when reopening and refreshing the analysis

no_results.jpg

No results are shown in the workspace after a date interval is chosen in the  variable screen

Environment

  • BI 4.0 Patch 08
  • Advanced Analysis Web (Edition for OLAP)
  • SAP BW 7.01 SP05
  • BEx Query Designer

Reproducing the Issue

  1. Create a BEx query with a Characteristic Selection Structure and a Measure Hierarchy Structure in the Columns.
  2. In BEx, on the Filter tab, create a Characteristic Restriction on a date object, using a Interval - Range variable.
  3. Define the AAWeb connection using ths BEx query in the CMC application, via "OLAP Connections".
  4. Create a new Advanced Analysis Web Workspace using this connection.
  5. Answer the date range.
  6. 1st_refresh.jpg
  7. Generate the Workspace and create an Analysis.
  8. 1st_results.jpg
  9. Save this workspace to your Enterprise Folders.
  10. Exit the Workspace. Log Off of Infoview.
  11. Login again into BI Launchpad.
  12. Open the Saved Workspace again.
  13. The prompt dialogue opens, and the “previously selected prompt values” are green ticked.
  14. 2nd_refresh_saved_workspace.jpg
  15. Click OK to refresh.

Cause

  • in BW traces, error in transaction during BICS_PROV_GET_RESULTS_SET.  Function module BICS_PROV_VAR_SET_VARIABLES error with handle "Specify a value for variable" xxx

bw_trace.jpg

Resolution

  • This issue is being handled by Technical Escalation # 5000318271
  • Product Development are working on Bug Fix ADAPT01526857.
  • The delivery milestone is set to 4.0 SP01 Patch01, RTC is tentatively planned for April 15th

Keywords

KBA , BI-RA-AWB , Analysis, edition for OLAP (Web) , Bug Filed

Product

Crystal Reports 2008 V1